Query to get Bank Branch Information

-

   SELECT BANK_HOME_COUNTRY,

       COUNTRY_NAME AS G2_COUNTRY_NAME,

                   SUBSTR(START_DATE,1,10) AS G2_START_DATE,

                   SUBSTR(END_DATE,1,10) AS G2_END_DATE,

                   BANK_NAME AS G2_BANK_NAME,

                   BANK_BRANCH_NAME AS G2_BANK_BRANCH_NAME,

                   BRANCH_NUMBER AS G2_ROUTING_NUMBER

  FROM CE_BANK_BRANCHES_V

ORDER BY BANK_NAME,BANK_BRANCH_NAME

Comments

Post a Comment

Popular posts from this blog

Oracle Fusion HCM - Enhancements to Summary of Changes and History Sections in Redwood Workforce Structures Pages

-
Image
 The  Summary of Changes  and  History  sections on Redwood  Workforce Structures  pages now display  additional attributes , providing a more detailed view of historical and recent changes to your workforce data. These enhancements apply to the following Redwood pages: Redwood Page New Attributes in Summary of Changes and History Sections Departments Status Divisions Status Disability Organizations Status Enterprise HCM Information Status Jobs Annual Working Duration Scheduling Group Standard Annual Working Duration Standard Working Hours Standard Working Frequency Locations Annual Working Duration Standard Annual Working Duration Standard Working Hours Standard Working Frequency Reporting Establishments Status Worker Unions Status These additional attributes are now visible in both the  Summary of Changes  and  History  sections, enabling users to quickly access and review key data points related to structural and job-related...
Read more

Query to get Salary Change details in Fusion HCM

-
 SELECT papf.person_number PERSON_NUMBER, (select full_name from per_person_names_f ppnf where ppnf.person_id = papf.person_id and name_type = 'GLOBAL' and trunc(sysdate) between ppnf.effective_start_date and ppnf.effective_end_date) person_name, ple.name LEGAL_EMPLOYE, (CASE  when cs.SALARY_BASIS_CODE = 'ANNUAL' THEN 'Salary Change'  else  'Hourly Rate Change' end)  ACTION_NAME, to_char(cs_old.salary_amount) OLD_DATA,  to_char(CS.salary_amount) NEW_DATA    ,TO_CHAR(cs.date_from, 'MM/DD/YYYY') EFFECTIVE_DATE    ,  TO_CHAR(cs.creation_date, 'MM/DD/YYYY') CHANGED_DATE    , cs.LAST_UPDATED_BY CHANGED_BY           from  fusion.CMP_SALARY cs,           CMP_SALARY cs_old,   PER_ALL_ASSIGNMENTS_M  PAAM,   PER_ALL_PEOPLE_F PAPF   ,per_legal_employers ple          where 1 = 1    AND PAPF.PERSON_ID = P...
Read more

🤖 Benefits Analyst: Oracle’s AI Assistant for Employee Benefits Clarity

-
Managing employee benefits shouldn't be complicated—and with Oracle’s  Benefits Analyst AI Agent , it no longer is. Built on Oracle’s robust  AI Agent framework , this intelligent digital assistant is redefining how employees interact with their benefits data. Whether it's health coverage, dental plans, or retirement options, the Benefits Analyst empowers employees to  instantly access, understand, and act on their benefits information —all through a secure, conversational interface. 🌟 What is the Benefits Analyst? The  Benefits Analyst  is an AI-powered digital assistant that helps employees: 💡 Understand what benefits they’re enrolled in 🔍 Get policy details and provider contact information 🧾 Access enrollment status, coverage tiers, and dependents ✅ Find accurate, up-to-date info without contacting HR or navigating multiple systems And it all happens through  natural language interactions —just ask, and get what you need. 🛠️ Key Features ⚡ Instant A...
Read more