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.PQP_GB_T1_PENSION_EXTRACTS dependencies on PER_TIME_PERIODS

Line 834: -- Cursor to retrieve end_dates from per_time_periods

830: petf.legislation_code IS NULL
831: )
832: );
833:
834: -- Cursor to retrieve end_dates from per_time_periods
835:
836: Cursor csr_get_end_date
837: (c_assignment_id number
838: ,c_effective_start_date date

Line 841: from per_time_periods ptp

837: (c_assignment_id number
838: ,c_effective_start_date date
839: ,c_effective_end_date date) is
840: select distinct(ptp.end_date) end_date
841: from per_time_periods ptp
842: ,pay_payroll_actions ppa
843: ,pay_assignment_actions paa
844: where ptp.time_period_id = ppa.time_period_id
845: and ppa.payroll_action_id = paa.payroll_action_id

Line 860: from per_time_periods ptp

856: (c_assignment_id number
857: ,c_effective_start_date date
858: ,c_effective_end_date date) is
859: select distinct(ptp.end_date) end_date
860: from per_time_periods ptp
861: ,pay_payroll_actions ppa
862: ,pay_assignment_actions paa
863: where ptp.time_period_id = ppa.time_period_id
864: and ppa.payroll_action_id = paa.payroll_action_id

Line 1306: ,per_time_periods PTP

1302: ,pay_payroll_actions PACT
1303: ,pay_run_results RR
1304: ,pay_run_result_values TARGET
1305: ,pay_balance_feeds_f FEED
1306: ,per_time_periods PTP
1307: WHERE BAL_ASSACT.assignment_action_id = p_asg_act_id
1308: and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id
1309: and FEED.balance_type_id = p_balance_type_id + DECODE(TARGET.input_value_id,null,0,0) -- 10510987
1310: and FEED.input_value_id = TARGET.input_value_id

Line 1336: FROM per_time_periods ptp

1332: ,p_effective_start_date DATE
1333: )
1334: IS
1335: SELECT max(ptp.end_date) previous_payroll_date
1336: FROM per_time_periods ptp
1337: ,per_all_assignments_f paaf
1338: WHERE ptp.payroll_id = paaf.payroll_id
1339: AND paaf.assignment_id = p_assignment_id
1340: AND ptp.end_date < p_effective_start_date ;

Line 1352: FROM per_time_periods ptp

1348: ,p_effective_start_date DATE
1349: )
1350: IS
1351: SELECT min(ptp.end_date) next_payroll_date
1352: FROM per_time_periods ptp
1353: ,per_all_assignments_f paaf
1354: WHERE ptp.payroll_id = paaf.payroll_id
1355: AND paaf.assignment_id = p_assignment_id
1356: AND ptp.end_date >= p_effective_start_date ;