BI Publisher - Thinkapace Consulting – Transforming Businesses with ERP - Page 2

SQL to pull Balance Feeds

SQL to pull Balance Feeds

SQL to pull Position and Parent Position

SQL to pull Position and Parent Position

Select DISTINCT papf_empp.person_number employee_number,ppnf.first_name||’ ‘||ppnf.last_name employee_name,(select hapft.namefrom hr_all_positions_f hapf, HR_ALL_POSITIONS_F_TL...

SQL to pull active Personal Payment Methods

SQL to pull active Personal Payment Methods

SQL to Fetch the Action which action has been performed and when for the cancelled work relationship and Reverse Termination in Oracle Fusion

SQL to Fetch the Action which action has been performed and when for the cancelled work relationship and Reverse Termination in Oracle Fusion

SQL to Fetch the Absence Plan Name and Its Element

SQL to Fetch the Absence Plan Name and Its Element

SQL to pull the Terminated Employees

SQL to pull the Terminated Employees

SQL to pull the Absence Accrual Balance

SQL to pull the Absence Accrual Balance

SQL to Fetch the Address Change

SQL to pull the Old and New Salary in Oracle Fusion

SQL to pull the Old and New Salary in Oracle Fusion

SQL to pull the Job Change

SQL to pull the Job Change