[Home] [Help]
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*/
485: WHERE asg.assignment_id = paa.assignment_id
486: AND asg.person_id = ppf.person_id
487: AND ppf.nationality = l_local_nationality
488: AND paa.payroll_action_id = ppa.payroll_action_id
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*/
754: WHERE asg.assignment_id = paa.assignment_id
755: AND asg.person_id = ppf.person_id
756: AND ppf.nationality = l_local_nationality
757: AND paa.payroll_action_id = ppa.payroll_action_id
772: (p_person_id
773: ,l_effective_date
774: ,'DISPLAY_NAME'
775: ,l_user_format)
776: FROM per_people_f ppf --per_all_people_f ppf
777: WHERE person_id = p_person_id
778: AND l_effective_date BETWEEN effective_start_date AND effective_end_date;
779: rec_get_emp_name csr_get_emp_name%ROWTYPE;*/
780:
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*/
1164: WHERE asg.assignment_id = paa.assignment_id
1165: AND asg.person_id = ppf.person_id
1166: AND ppf.nationality = l_local_nationality
1167: AND paa.payroll_action_id = ppa.payroll_action_id
1182: (p_person_id
1183: ,l_effective_date
1184: ,'DISPLAY_NAME'
1185: ,l_user_format)
1186: FROM per_people_f ppf --per_all_people_f ppf
1187: WHERE person_id = p_person_id
1188: AND l_effective_date BETWEEN effective_start_date AND effective_end_date;
1189: rec_get_emp_name csr_get_emp_name%ROWTYPE;*/
1190:
1802: ,pay_assignment_actions paa
1803: ,pay_payroll_actions ppa
1804: ,hr_soft_coding_keyflex hscl
1805: ,per_periods_of_service pos
1806: ,per_people_f ppf /*per_all_people_f ppf*/
1807: WHERE asg.assignment_id = paa.assignment_id
1808: AND asg.person_id = ppf.person_id
1809: AND ppf.nationality = l_local_nationality
1810: AND paa.payroll_action_id = ppa.payroll_action_id
1832: ,pay_assignment_actions paa
1833: ,pay_payroll_actions ppa
1834: ,hr_soft_coding_keyflex hscl
1835: ,per_periods_of_service pos
1836: ,per_people_f ppf /*per_all_people_f ppf*/
1837: WHERE asg.assignment_id = paa.assignment_id
1838: AND asg.person_id = ppf.person_id
1839: AND ppf.nationality = l_local_nationality
1840: AND paa.payroll_action_id = ppa.payroll_action_id
1879: ,pay_assignment_actions paa
1880: ,pay_payroll_actions ppa
1881: ,hr_soft_coding_keyflex hscl
1882: ,per_periods_of_service pos
1883: ,per_people_f ppf /*per_all_people_f ppf*/
1884: WHERE asg.assignment_id = paa.assignment_id
1885: AND asg.person_id = ppf.person_id
1886: AND ppf.nationality = l_local_nationality
1887: AND paa.payroll_action_id = ppa.payroll_action_id
1908: ,l_effective_date
1909: ,'DISPLAY_NAME'
1910: ,l_user_format)*/
1911: national_identifier
1912: FROM per_people_f ppf /*per_all_people_f ppf*/
1913: WHERE person_id = p_person_id
1914: AND l_effective_date BETWEEN effective_start_date AND effective_end_date;
1915: rec_get_emp_name csr_get_emp_name%ROWTYPE;
1916:
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
1948: WHERE asg.assignment_id = paa.assignment_id
1949: AND paa.payroll_action_id = ppa.payroll_action_id
1950: AND ppa.action_type in ('R','Q')
1951: AND ppa.action_status = 'C'