DBA Data[Home] [Help]

APPS.PAY_IE_NES_REPORT_PKG dependencies on PAY_ALL_PAYROLLS_F

Line 1005: pay_all_payrolls_f papf,

1001:
1002: l_select_str1 :='select count (distinct paaf.assignment_id )
1003: from per_all_assignments_f paaf,
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

Line 1061: pay_all_payrolls_f papf,

1057: || 'from ( '
1058: || 'select distinct paaf.assignment_id asgid
1059: from per_all_assignments_f paaf,
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

Line 1213: ,pay_all_payrolls_f papf

1209: paa.assignment_action_id),16))
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

Line 1232: ,pay_all_payrolls_f papf

1228: paa.assignment_action_id),16))
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

Line 1376: ,pay_all_payrolls_f papf

1372: paa.assignment_action_id),16))
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

Line 1402: ,pay_all_payrolls_f papf

1398: paa.assignment_action_id),16))
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