APPS.PAY_KW_MONTHLY_REPORTS dependencies on PER_PEOPLE_F

Line 416: ,per_all_people_f ppf /*per_people_f ppf*/

412: FROM per_all_assignments_f asg /*per_assignments_f asg*/
413: ,pay_assignment_actions paa
414: ,pay_payroll_actions ppa
415: ,hr_soft_coding_keyflex hscl
416: ,per_all_people_f ppf /*per_people_f ppf*/
417: WHERE asg.assignment_id = paa.assignment_id
418: AND asg.person_id = ppf.person_id
419: AND ppf.nationality = l_local_nationality
420: AND paa.payroll_action_id = ppa.payroll_action_id

Line 602: ,per_people_f ppf /*per_all_people_f ppf*/

598: FROM per_assignments_f asg /*per_all_assignments_f asg*/
599: ,pay_assignment_actions paa
600: ,pay_payroll_actions ppa
601: ,hr_soft_coding_keyflex hscl
602: ,per_people_f ppf /*per_all_people_f ppf*/
603: WHERE asg.assignment_id = paa.assignment_id
604: AND asg.person_id = ppf.person_id
605: AND ppf.nationality = l_local_nationality
606: AND paa.payroll_action_id = ppa.payroll_action_id

Line 625: FROM per_people_f ppf --per_all_people_f ppf

621: (p_person_id
622: ,l_effective_date
623: ,'DISPLAY_NAME'
624: ,l_user_format)
625: FROM per_people_f ppf --per_all_people_f ppf
626: WHERE person_id = p_person_id
627: AND l_effective_date BETWEEN effective_start_date AND effective_end_date;
628: rec_get_emp_name csr_get_emp_name%ROWTYPE;*/
629:

Line 1012: ,per_people_f ppf /*per_all_people_f ppf*/

1008: FROM per_assignments_f asg /*per_all_assignments_f asg*/
1009: ,pay_assignment_actions paa
1010: ,pay_payroll_actions ppa
1011: ,hr_soft_coding_keyflex hscl
1012: ,per_people_f ppf /*per_all_people_f ppf*/
1013: WHERE asg.assignment_id = paa.assignment_id
1014: AND asg.person_id = ppf.person_id
1015: AND ppf.nationality = l_local_nationality
1016: AND paa.payroll_action_id = ppa.payroll_action_id

Line 1035: FROM per_people_f ppf --per_all_people_f ppf

1031: (p_person_id
1032: ,l_effective_date
1033: ,'DISPLAY_NAME'
1034: ,l_user_format)
1035: FROM per_people_f ppf --per_all_people_f ppf
1036: WHERE person_id = p_person_id
1037: AND l_effective_date BETWEEN effective_start_date AND effective_end_date;
1038: rec_get_emp_name csr_get_emp_name%ROWTYPE;*/
1039:

Line 1648: ,per_people_f ppf /*per_all_people_f ppf*/

1644: ,pay_assignment_actions paa
1645: ,pay_payroll_actions ppa
1646: ,hr_soft_coding_keyflex hscl
1647: ,per_periods_of_service pos
1648: ,per_people_f ppf /*per_all_people_f ppf*/
1649: WHERE asg.assignment_id = paa.assignment_id
1650: AND asg.person_id = ppf.person_id
1651: AND ppf.nationality = l_local_nationality
1652: AND paa.payroll_action_id = ppa.payroll_action_id

Line 1678: ,per_people_f ppf /*per_all_people_f ppf*/

1674: ,pay_assignment_actions paa
1675: ,pay_payroll_actions ppa
1676: ,hr_soft_coding_keyflex hscl
1677: ,per_periods_of_service pos
1678: ,per_people_f ppf /*per_all_people_f ppf*/
1679: WHERE asg.assignment_id = paa.assignment_id
1680: AND asg.person_id = ppf.person_id
1681: AND ppf.nationality = l_local_nationality
1682: AND paa.payroll_action_id = ppa.payroll_action_id

Line 1724: ,per_people_f ppf /*per_all_people_f ppf*/

1720: ,pay_assignment_actions paa
1721: ,pay_payroll_actions ppa
1722: ,hr_soft_coding_keyflex hscl
1723: ,per_periods_of_service pos
1724: ,per_people_f ppf /*per_all_people_f ppf*/
1725: WHERE asg.assignment_id = paa.assignment_id
1726: AND asg.person_id = ppf.person_id
1727: AND ppf.nationality = l_local_nationality
1728: AND paa.payroll_action_id = ppa.payroll_action_id

Line 1753: FROM per_people_f ppf /*per_all_people_f ppf*/

1749: ,l_effective_date
1750: ,'DISPLAY_NAME'
1751: ,l_user_format)*/
1752: national_identifier
1753: FROM per_people_f ppf /*per_all_people_f ppf*/
1754: WHERE person_id = p_person_id
1755: AND l_effective_date BETWEEN effective_start_date AND effective_end_date;
1756: rec_get_emp_name csr_get_emp_name%ROWTYPE;
1757: