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 PER_TIME_PERIODS

Line 984: from per_time_periods

980: AND (paa.source_action_id is not null or ppa.action_type in ('I','V','B'))
981: AND ppa.effective_date between g_qtr_start_date and g_qtr_end_date
982: --bug 7294966
983: /* ( select max(pay_advice_date)
984: from per_time_periods
985: where payroll_id = p_payroll_id
986: and pay_advice_date <= g_qtr_end_date
987: )
988: */

Line 2412: from per_time_periods ptp

2408: and scl.segment4 = g_employer_id
2409: and paaf.employee_category = nvl(g_occupational_category,paaf.employee_category)
2410: /*
2411: and ( select min(ptp.pay_advice_date)
2412: from per_time_periods ptp
2413: where ptp.payroll_id = paaf.payroll_id
2414: and ptp.pay_advice_date >= g_qtr_start_date
2415: )
2416: */

Line 2459: from per_time_periods

2455: paa.assignment_id = paaf.assignment_id
2456: AND ppa.payroll_action_id = paa.payroll_action_id
2457: AND (paa.source_action_id is not null or ppa.action_type in ('I','V','B'))
2458: AND ppa.effective_date = (select min(regular_payment_date) --min(pay_advice_date) --bug 7294966
2459: from per_time_periods
2460: where payroll_id = paaf.payroll_id
2461: --and pay_advice_date >= g_qtr_start_date
2462: and regular_payment_date >= g_qtr_start_date --bug 7294966
2463: )

Line 2521: from per_time_periods ptp

2517: and scl.segment4 = g_employer_id
2518: and paaf.employee_category = nvl(g_occupational_category,paaf.employee_category)
2519: /*
2520: and ( select max(ptp.pay_advice_date)
2521: from per_time_periods ptp
2522: where ptp.payroll_id = paaf.payroll_id
2523: and ptp.pay_advice_date <= g_qtr_end_date
2524: )
2525: */

Line 2568: from per_time_periods

2564: paa.assignment_id = paaf.assignment_id
2565: AND ppa.payroll_action_id = paa.payroll_action_id
2566: AND (paa.source_action_id is not null or ppa.action_type in ('I','V','B'))
2567: AND ppa.effective_date = (select max(regular_payment_date) --max(pay_advice_date) --bug 7294966
2568: from per_time_periods
2569: where payroll_id = paaf.payroll_id
2570: --and pay_advice_date <= g_qtr_end_date
2571: and regular_payment_date <= g_qtr_end_date --bug 7294966
2572: )

Line 2662: from per_time_periods ptp

2658: --
2659: --and g_qtr_start_date between paaf.effective_start_date and paaf.effective_end_date
2660: /*
2661: and ( select min(ptp.pay_advice_date)
2662: from per_time_periods ptp
2663: where ptp.payroll_id = paaf.payroll_id
2664: and ptp.pay_advice_date >= g_qtr_start_date
2665: )
2666: */

Line 2685: from per_time_periods

2681: paa.assignment_id = paaf.assignment_id
2682: AND ppa.payroll_action_id = paa.payroll_action_id
2683: AND (paa.source_action_id is not null or ppa.action_type in ('I','V'))
2684: AND ppa.effective_date between (select min(pay_advice_date)
2685: from per_time_periods
2686: where payroll_id = paaf.payroll_id
2687: and pay_advice_date >= g_qtr_start_date
2688: )
2689: AND g_qtr_end_date

Line 2731: from per_time_periods ptp

2727:
2728: CURSOR csr_period_dates(p_payroll_id Number)
2729: IS
2730: select pay_advice_date
2731: from per_time_periods ptp
2732: where ptp.payroll_id = p_payroll_id
2733: and ptp.pay_advice_date between g_qtr_start_date and g_qtr_end_date;
2734:
2735: