eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_IE_EHECS_REPORT_PKG dependencies on PAY_ALL_PAYROLLS

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 1196: p_payroll_id pay_all_payrolls.payroll_id%type) IS

1192: /* 9776525 start */
1193: --
1194: /* commented as a part of bug 10040939
1195: CURSOR csr_paid_pay_periods (p_assignment_id per_all_assignments_f.assignment_id%type,
1196: p_payroll_id pay_all_payrolls.payroll_id%type) IS
1197: select count(ptp.time_period_id)
1198: from per_time_periods ptp,
1199: pay_payroll_actions ppa,
1200: pay_assignment_actions paa

Line 1216: p_payroll_id pay_all_payrolls.payroll_id%type) IS

1212: --
1213: /* 9776525 end */
1214: /* 10040939 start */
1215: CURSOR csr_paid_pay_periods (p_assignment_id per_all_assignments_f.assignment_id%type,
1216: p_payroll_id pay_all_payrolls.payroll_id%type) IS
1217: select count(ptp.time_period_id)
1218: from per_time_periods ptp
1219: where ptp.payroll_id = p_payroll_id
1220: and ptp.time_period_id in ( select ppa.time_period_id

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