APPS.PAY_IE_EHECS_REPORT_PKG dependencies on PAY_ALL_PAYROLLS_F

Line 965: pay_all_payrolls_f papf,

961: /* 6856486 modified the employment_category 's IN condition to a value fetch from USER TABLE EHECS_ASG_CATG_TAB */
962: l_select_str :='select distinct paaf.assignment_id asgid
963: from per_all_assignments_f paaf,
964: per_all_people_f ppf,
965: pay_all_payrolls_f papf,
966: pay_payroll_actions ppa,
967: hr_soft_coding_keyflex scl
968: where paaf.business_group_id = '|| g_business_group_id
969: ||' and papf.business_group_id = paaf.business_group_id '

Line 1135: pay_all_payrolls_f papf -- 9776525

1131: ,hourly_salaried_code hourly_or_salaried /*6856473*/
1132: ,papf.PERIOD_TYPE /* 9776525 */
1133: FROM
1134: per_all_assignments_f paaf,
1135: pay_all_payrolls_f papf -- 9776525
1136: WHERE paaf.assignment_id = c_assignment_id
1137: and paaf.person_id = c_person_id
1138: and paaf.effective_start_date <= g_qtr_end_date
1139: and paaf.effective_end_date >= g_qtr_start_date

Line 2683: pay_all_payrolls_f papf,

2679: ) EHECS_CATG,
2680: paaf.assignment_id
2681: from
2682: per_all_assignments_f paaf,
2683: pay_all_payrolls_f papf,
2684: hr_soft_coding_keyflex scl
2685: where
2686: paaf.business_group_id = g_business_group_id
2687: and paaf.payroll_id is not null

Line 2794: pay_all_payrolls_f papf,

2790: ) EHECS_CATG,
2791: paaf.assignment_id
2792: from
2793: per_all_assignments_f paaf,
2794: pay_all_payrolls_f papf,
2795: hr_soft_coding_keyflex scl
2796: where
2797: paaf.business_group_id = g_business_group_id
2798: and paaf.payroll_id is not null

Line 2907: pay_all_payrolls_f papf,

2903: paaf.assignment_id,
2904: pps.period_of_service_id
2905: from
2906: per_all_assignments_f paaf,
2907: pay_all_payrolls_f papf,
2908: hr_soft_coding_keyflex scl,
2909: per_periods_of_service pps
2910: where
2911: paaf.business_group_id = g_business_group_id

Line 2998: pay_all_payrolls_f papf,

2994: IS
2995: select distinct papf.payroll_id
2996: from
2997: per_all_assignments_f paaf,
2998: pay_all_payrolls_f papf,
2999: hr_soft_coding_keyflex scl
3000: where
3001: paaf.business_group_id = g_business_group_id
3002: and paaf.payroll_id is not null

Line 3051: pay_all_payrolls_f papf,

3047: ) EHECS_CATG,
3048: paaf.assignment_id
3049: from
3050: per_all_assignments_f paaf,
3051: pay_all_payrolls_f papf,
3052: hr_soft_coding_keyflex scl
3053: where
3054: paaf.business_group_id = g_business_group_id
3055: and paaf.payroll_id is not null