DBA Data[Home] [Help]

APPS.PAY_IE_NES_REPORT_PKG dependencies on HR_SOFT_CODING_KEYFLEX

Line 1008: hr_soft_coding_keyflex scl

1004: per_all_people_f ppf,
1005: pay_all_payrolls_f papf,
1006: pay_payroll_actions ppa,
1007: pay_assignment_actions paa,
1008: hr_soft_coding_keyflex scl
1009: where paaf.business_group_id = '|| g_business_group_id
1010: ||' and papf.business_group_id = paaf.business_group_id and '
1011: ||''''|| g_reference_end_date||''''||' between paaf.effective_start_date and paaf.effective_end_date '
1012: ||' and paaf.person_id = ppf.person_id '

Line 1064: hr_soft_coding_keyflex scl

1060: per_all_people_f ppf,
1061: pay_all_payrolls_f papf,
1062: pay_payroll_actions ppa,
1063: pay_assignment_actions paa,
1064: hr_soft_coding_keyflex scl
1065: where paaf.business_group_id = '|| g_business_group_id
1066: ||' and papf.business_group_id = paaf.business_group_id and '
1067: ||''''|| g_reference_end_date||''''||' between paaf.effective_start_date and paaf.effective_end_date '
1068: ||' and paaf.person_id = ppf.person_id '

Line 1214: ,hr_soft_coding_keyflex scl

1210: FROM pay_assignment_actions paa
1211: ,pay_payroll_actions ppa
1212: ,per_all_assignments_f paaf
1213: ,pay_all_payrolls_f papf
1214: ,hr_soft_coding_keyflex scl
1215: WHERE paaf.person_id=c_person_id
1216: AND paa.assignment_id=paaf.assignment_id
1217: AND paa.payroll_action_id=ppa.payroll_action_id
1218: AND ppa.action_type in ('Q','B','R','I','V')

Line 1233: ,hr_soft_coding_keyflex scl

1229: FROM pay_assignment_actions paa
1230: ,pay_payroll_actions ppa
1231: ,per_all_assignments_f paaf
1232: ,pay_all_payrolls_f papf
1233: ,hr_soft_coding_keyflex scl
1234: WHERE paaf.person_id=c_person_id
1235: AND paa.assignment_id=paaf.assignment_id
1236: AND paa.payroll_action_id=ppa.payroll_action_id
1237: AND ppa.action_type in ('Q','B','R','I','V')

Line 1377: ,hr_soft_coding_keyflex scl

1373: FROM pay_assignment_actions paa
1374: ,pay_payroll_actions ppa
1375: ,per_all_assignments_f paaf
1376: ,pay_all_payrolls_f papf
1377: ,hr_soft_coding_keyflex scl
1378: WHERE paaf.person_id=c_person_id
1379: AND paa.assignment_id in (select paaf.assignment_id
1380: from per_all_assignments_f paaf, per_assignment_extra_info paei
1381: where paaf.person_id = c_person_id

Line 1403: ,hr_soft_coding_keyflex scl

1399: FROM pay_assignment_actions paa
1400: ,pay_payroll_actions ppa
1401: ,per_all_assignments_f paaf
1402: ,pay_all_payrolls_f papf
1403: ,hr_soft_coding_keyflex scl
1404: WHERE paaf.person_id=c_person_id
1405: AND paa.assignment_id in (select paaf.assignment_id
1406: from per_all_assignments_f paaf, per_assignment_extra_info paei
1407: where paaf.person_id = c_person_id