APPS.PAY_KW_MONTHLY_REPORTS dependencies on PER_ASSIGNMENTS_F

Line 480: FROM per_all_assignments_f asg /*per_assignments_f asg*/

476: DECLARE
477: CURSOR csr_get_assacts IS
478: SELECT distinct asg.assignment_id
479: ,paa.assignment_action_id
480: FROM per_all_assignments_f asg /*per_assignments_f asg*/
481: ,pay_assignment_actions paa
482: ,pay_payroll_actions ppa
483: ,hr_soft_coding_keyflex hscl
484: ,per_all_people_f ppf /*per_people_f ppf*/

Line 749: FROM per_assignments_f asg /*per_all_assignments_f asg*/

745: CURSOR csr_get_emp IS
746: SELECT distinct asg.person_id
747: ,paa.assignment_action_id
748: ,hscl.segment2
749: FROM per_assignments_f asg /*per_all_assignments_f asg*/
750: ,pay_assignment_actions paa
751: ,pay_payroll_actions ppa
752: ,hr_soft_coding_keyflex hscl
753: ,per_people_f ppf /*per_all_people_f ppf*/

Line 1159: FROM per_assignments_f asg /*per_all_assignments_f asg*/

1155: SELECT distinct asg.person_id
1156: ,paa.assignment_action_id
1157: ,hscl.segment2
1158: ,asg.assignment_id
1159: FROM per_assignments_f asg /*per_all_assignments_f asg*/
1160: ,pay_assignment_actions paa
1161: ,pay_payroll_actions ppa
1162: ,hr_soft_coding_keyflex hscl
1163: ,per_people_f ppf /*per_all_people_f ppf*/

Line 1801: FROM per_assignments_f asg /*per_all_assignments_f asg*/

1797: CURSOR csr_get_new_emp IS
1798: SELECT distinct asg.person_id
1799: ,paa.assignment_action_id
1800: ,pos.date_start
1801: FROM per_assignments_f asg /*per_all_assignments_f asg*/
1802: ,pay_assignment_actions paa
1803: ,pay_payroll_actions ppa
1804: ,hr_soft_coding_keyflex hscl
1805: ,per_periods_of_service pos

Line 1831: FROM per_assignments_f asg /*per_all_assignments_f asg*/

1827: SELECT distinct asg.person_id
1828: ,paa.assignment_action_id
1829: ,pos.actual_termination_date
1830: ,ppa.date_earned
1831: FROM per_assignments_f asg /*per_all_assignments_f asg*/
1832: ,pay_assignment_actions paa
1833: ,pay_payroll_actions ppa
1834: ,hr_soft_coding_keyflex hscl
1835: ,per_periods_of_service pos

Line 1856: FROM per_assignments_f asg /*per_all_assignments_f asg*/

1852:
1853: /*Cursor for fetching effective date of salary change*/
1854: CURSOR csr_get_salary_date (p_person_id NUMBER) IS
1855: SELECT date_earned, paa.assignment_action_id
1856: FROM per_assignments_f asg /*per_all_assignments_f asg*/
1857: ,pay_assignment_actions paa
1858: ,pay_payroll_actions ppa
1859: ,per_periods_of_service pos
1860: WHERE asg.assignment_id = paa.assignment_id

Line 1878: FROM per_assignments_f asg /*per_all_assignments_f asg*/

1874: SELECT distinct asg.person_id
1875: ,asg.assignment_id
1876: ,paa.assignment_action_id
1877: ,date_earned
1878: FROM per_assignments_f asg /*per_all_assignments_f asg*/
1879: ,pay_assignment_actions paa
1880: ,pay_payroll_actions ppa
1881: ,hr_soft_coding_keyflex hscl
1882: ,per_periods_of_service pos

Line 1943: FROM per_assignments_f asg

1939: /* CURSOR csr_get_emp (l_employer_id number, l_date date , l_nat varchar2) IS
1940: SELECT distinct asg.person_id
1941: ,asg.assignment_id
1942: ,paa.assignment_action_id
1943: FROM per_assignments_f asg
1944: ,pay_assignment_actions paa
1945: ,pay_payroll_actions ppa
1946: ,hr_soft_coding_keyflex hscl
1947: ,per_people_f ppf