DBA Data[Home] [Help]

APPS.PAY_IE_EHECS_REPORT_PKG dependencies on PAY_ALL_PAYROLLS_F

Line 791: pay_all_payrolls_f papf,

787: /* 6856486 modified the employment_category 's IN condition to a value fetch from USER TABLE EHECS_ASG_CATG_TAB */
788: l_select_str :='select distinct paaf.assignment_id asgid
789: from per_all_assignments_f paaf,
790: per_all_people_f ppf,
791: pay_all_payrolls_f papf,
792: pay_payroll_actions ppa,
793: hr_soft_coding_keyflex scl
794: where paaf.business_group_id = '|| g_business_group_id
795: ||' and papf.business_group_id = paaf.business_group_id '

Line 2400: pay_all_payrolls_f papf,

2396: ) EHECS_CATG,
2397: paaf.assignment_id
2398: from
2399: per_all_assignments_f paaf,
2400: pay_all_payrolls_f papf,
2401: hr_soft_coding_keyflex scl
2402: where
2403: paaf.business_group_id = g_business_group_id
2404: and paaf.payroll_id is not null

Line 2509: pay_all_payrolls_f papf,

2505: ) EHECS_CATG,
2506: paaf.assignment_id
2507: from
2508: per_all_assignments_f paaf,
2509: pay_all_payrolls_f papf,
2510: hr_soft_coding_keyflex scl
2511: where
2512: paaf.business_group_id = g_business_group_id
2513: and paaf.payroll_id is not null

Line 2620: pay_all_payrolls_f papf,

2616: paaf.assignment_id,
2617: pps.period_of_service_id
2618: from
2619: per_all_assignments_f paaf,
2620: pay_all_payrolls_f papf,
2621: hr_soft_coding_keyflex scl,
2622: per_periods_of_service pps
2623: where
2624: paaf.business_group_id = g_business_group_id

Line 2711: pay_all_payrolls_f papf,

2707: IS
2708: select distinct papf.payroll_id
2709: from
2710: per_all_assignments_f paaf,
2711: pay_all_payrolls_f papf,
2712: hr_soft_coding_keyflex scl
2713: where
2714: paaf.business_group_id = g_business_group_id
2715: and paaf.payroll_id is not null

Line 2764: pay_all_payrolls_f papf,

2760: ) EHECS_CATG,
2761: paaf.assignment_id
2762: from
2763: per_all_assignments_f paaf,
2764: pay_all_payrolls_f papf,
2765: hr_soft_coding_keyflex scl
2766: where
2767: paaf.business_group_id = g_business_group_id
2768: and paaf.payroll_id is not null