DBA Data[Home] [Help]

APPS.PAY_KW_MONTHLY_REPORTS dependencies on HR_SOFT_CODING_KEYFLEX

Line 483: ,hr_soft_coding_keyflex hscl

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*/
485: WHERE asg.assignment_id = paa.assignment_id
486: AND asg.person_id = ppf.person_id
487: AND ppf.nationality = l_local_nationality

Line 752: ,hr_soft_coding_keyflex hscl

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*/
754: WHERE asg.assignment_id = paa.assignment_id
755: AND asg.person_id = ppf.person_id
756: AND ppf.nationality = l_local_nationality

Line 1162: ,hr_soft_coding_keyflex hscl

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*/
1164: WHERE asg.assignment_id = paa.assignment_id
1165: AND asg.person_id = ppf.person_id
1166: AND ppf.nationality = l_local_nationality

Line 1804: ,hr_soft_coding_keyflex hscl

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
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

Line 1834: ,hr_soft_coding_keyflex hscl

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
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

Line 1881: ,hr_soft_coding_keyflex hscl

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
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

Line 1946: ,hr_soft_coding_keyflex hscl

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
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')