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_NZ_HOLIDAYS_2003 dependencies on PER_TIME_PERIODS

Line 252: , per_time_periods ptp

248: FROM pay_assignment_actions paa
249: , per_assignments_f paf
250: , pay_payrolls_f ppf
251: , pay_payroll_actions ppa
252: , per_time_periods ptp
253: WHERE paf.assignment_id = p_assignment_id
254: AND ppa.action_type in ('R','Q')
255: AND p_effective_date BETWEEN paf.effective_start_date
256: AND paf.effective_end_date

Line 861: from per_time_periods ptp

857: and p_effective_date between effective_start_date and effective_end_date;
858: --
859: cursor csr_get_days_in_period is
860: select ptp.end_date - ptp.start_date days_in_period
861: from per_time_periods ptp
862: , per_assignments_f paf
863: where paf.assignment_id = p_assignment_id
864: and p_current_day between paf.effective_start_date and paf.effective_end_date
865: and paf.payroll_id = ptp.payroll_id

Line 1054: from per_time_periods ptp

1050: and p_effective_date between effective_start_date and effective_end_date;
1051: --
1052: cursor csr_get_days_in_period is
1053: select ptp.end_date - ptp.start_date days_in_period
1054: from per_time_periods ptp
1055: , per_assignments_f paf
1056: where paf.assignment_id = p_assignment_id
1057: and p_current_day between paf.effective_start_date and paf.effective_end_date
1058: and paf.payroll_id = ptp.payroll_id

Line 1614: from per_time_periods bptp

1610: --
1611: cursor csr_get_payment_date is
1612: --select pptp.end_date
1613: select pptp.regular_payment_date
1614: from per_time_periods bptp
1615: , per_time_periods pptp
1616: where bptp.payroll_id = p_payroll_id -- identify driving period
1617: and bptp.time_period_id = p_time_period_id -- identify driving period
1618: and pptp.payroll_id = p_payroll_id -- match payroll

Line 1615: , per_time_periods pptp

1611: cursor csr_get_payment_date is
1612: --select pptp.end_date
1613: select pptp.regular_payment_date
1614: from per_time_periods bptp
1615: , per_time_periods pptp
1616: where bptp.payroll_id = p_payroll_id -- identify driving period
1617: and bptp.time_period_id = p_time_period_id -- identify driving period
1618: and pptp.payroll_id = p_payroll_id -- match payroll
1619: and bptp.start_date = pptp.end_date + 1; -- idenfity previous period

Line 2114: , per_time_periods ptp

2110: , pay_assignment_actions paa
2111: , pay_assignment_actions cur_paa
2112: , pay_payroll_actions cur_ppa
2113: , pay_element_entries_f entry
2114: , per_time_periods ptp
2115: where runs.element_type_id = p_element_type_id
2116: and input.element_type_id = runs.element_type_id
2117: and input.name = p_rate_name
2118: and result.run_result_id = runs.run_result_id

Line 2260: FROM per_time_periods ptp

2256: CURSOR get_pay_period_details(c_eff_date IN DATE) IS
2257: --
2258: SELECT ptp.time_period_id
2259: ,ptp.end_date
2260: FROM per_time_periods ptp
2261: WHERE ptp.payroll_id = p_payroll_id
2262: AND c_eff_date BETWEEN ptp.start_date
2263: AND ptp.end_date;
2264: --

Line 2544: FROM per_time_periods ptp

2540: CURSOR get_curr_period_start
2541: IS
2542: --
2543: SELECT ptp.start_date
2544: FROM per_time_periods ptp
2545: ,pay_payroll_actions ppa
2546: WHERE ppa.payroll_action_id = p_payroll_action_id
2547: AND ppa.time_period_id = ptp.time_period_id;
2548: --