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

Line 647: per_time_periods ptp

643: min(ptp.start_date) start_year,
644: max(ptp.end_date) end_year
645: FROM pay_payroll_actions ppa,
646: pay_assignment_actions paa,
647: per_time_periods ptp
648: WHERE assignment_action_id = p_last_asg_action_id
649: AND ppa.time_period_id = ptp.time_period_id
650: AND ppa.payroll_id = ptp.payroll_id
651: AND paa.payroll_action_id = ppa.payroll_action_id;

Line 662: FROM per_time_periods ptp

658: WHERE p_period_type = ptpt.period_type;
659:
660: CURSOR get_week_53_start(p_payroll_id NUMBER, p_prl_max_period_number NUMBER, p_prl_start_year DATE, p_prl_end_year DATE) IS
661: SELECT start_date
662: FROM per_time_periods ptp
663: WHERE payroll_id = p_payroll_id
664: AND regular_payment_date BETWEEN p_prl_start_year AND p_prl_end_year
665: AND period_num = p_prl_max_period_number;
666:

Line 720: per_time_periods ptp

716: MAX(pact.effective_date) effective_date
717: FROM pay_assignment_actions paa,
718: per_all_assignments_f paaf,
719: pay_payroll_actions pact,
720: per_time_periods ptp
721: WHERE paa.assignment_id = paaf.assignment_id
722: AND paaf.person_id = p_person_id
723: AND paa.payroll_action_id = pact.payroll_action_id
724: AND pact.time_period_id = ptp.time_period_id

Line 3124: FROM per_time_periods ptp

3120: min(start_date) start_year,
3121: max(end_date) end_year,
3122: max(period_type) period_type,
3123: max(period_num) max_period_number
3124: FROM per_time_periods ptp
3125: WHERE ptp.payroll_id = p_payroll_id
3126: AND ptp.regular_payment_date BETWEEN p_start_year
3127: AND p_end_year;
3128: --

Line 3352: , per_time_periods ptp

3348: || paa.assignment_action_id), 16))
3349: , max (pact.effective_date) effective_date
3350: FROM pay_assignment_actions paa
3351: , pay_payroll_actions pact
3352: , per_time_periods ptp
3353: WHERE paa.assignment_id = p_asgid
3354: AND paa.payroll_action_id = pact.payroll_action_id
3355: --AND pact.payroll_id = l_payroll_id --commented for testing
3356: AND pact.time_period_id = ptp.time_period_id

Line 3883: , per_time_periods ptp

3879: || paa.assignment_action_id), 16))
3880: , max (pact.effective_date) effective_date
3881: FROM pay_assignment_actions paa
3882: , pay_payroll_actions pact
3883: , per_time_periods ptp
3884: WHERE paa.assignment_id = p_asgid
3885: AND paa.payroll_action_id = pact.payroll_action_id
3886: AND pact.payroll_id = l_payroll_id
3887: AND pact.time_period_id = ptp.time_period_id

Line 3968: per_time_periods ptp

3964: MAX(pact.effective_date) effective_date
3965: FROM pay_assignment_actions paa,
3966: per_all_assignments_f paaf,
3967: pay_payroll_actions pact,
3968: per_time_periods ptp
3969: WHERE paa.assignment_id = paaf.assignment_id
3970: AND paaf.person_id = c_person_id --41650
3971: AND paa.payroll_action_id = pact.payroll_action_id
3972: AND pact.time_period_id = ptp.time_period_id