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 830: -- Cursor to retrieve end_dates from per_time_periods

826: petf.legislation_code IS NULL
827: )
828: );
829:
830: -- Cursor to retrieve end_dates from per_time_periods
831:
832: Cursor csr_get_end_date
833: (c_assignment_id number
834: ,c_effective_start_date date

Line 837: from per_time_periods ptp

833: (c_assignment_id number
834: ,c_effective_start_date date
835: ,c_effective_end_date date) is
836: select distinct(ptp.end_date) end_date
837: from per_time_periods ptp
838: ,pay_payroll_actions ppa
839: ,pay_assignment_actions paa
840: where ptp.time_period_id = ppa.time_period_id
841: and ppa.payroll_action_id = paa.payroll_action_id

Line 853: from per_time_periods ptp

849: (c_assignment_id number
850: ,c_effective_start_date date
851: ,c_effective_end_date date) is
852: select distinct(ptp.end_date) end_date
853: from per_time_periods ptp
854: ,pay_payroll_actions ppa
855: ,pay_assignment_actions paa
856: where ptp.time_period_id = ppa.time_period_id
857: and ppa.payroll_action_id = paa.payroll_action_id

Line 1285: ,per_time_periods PTP

1281: ,pay_payroll_actions PACT
1282: ,pay_run_results RR
1283: ,pay_run_result_values TARGET
1284: ,pay_balance_feeds_f FEED
1285: ,per_time_periods PTP
1286: WHERE BAL_ASSACT.assignment_action_id = p_asg_act_id
1287: and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id
1288: and FEED.balance_type_id = p_balance_type_id + DECODE(TARGET.input_value_id,null,0,0) -- 10510987
1289: and FEED.input_value_id = TARGET.input_value_id

Line 1315: FROM per_time_periods ptp

1311: ,p_effective_start_date DATE
1312: )
1313: IS
1314: SELECT max(ptp.end_date) previous_payroll_date
1315: FROM per_time_periods ptp
1316: ,per_all_assignments_f paaf
1317: WHERE ptp.payroll_id = paaf.payroll_id
1318: AND paaf.assignment_id = p_assignment_id
1319: AND ptp.end_date <= p_effective_start_date ;

Line 1331: FROM per_time_periods ptp

1327: ,p_effective_start_date DATE
1328: )
1329: IS
1330: SELECT min(ptp.end_date) next_payroll_date
1331: FROM per_time_periods ptp
1332: ,per_all_assignments_f paaf
1333: WHERE ptp.payroll_id = paaf.payroll_id
1334: AND paaf.assignment_id = p_assignment_id
1335: AND ptp.end_date >= p_effective_start_date ;