APPS.PAY_YEAR_END_EXTRACT dependencies on PER_TIME_PERIODS

Line 481: ,per_time_periods BPTP

477: ,pay_element_links_f EL_NI
478: ,pay_payroll_actions PACT
479: ,pay_assignment_actions ASSACT
480: ,pay_payroll_actions BACT
481: ,per_time_periods BPTP
482: ,per_time_periods PPTP
483: ,pay_assignment_actions BAL_ASSACT
484: where BAL_ASSACT.assignment_action_id = cp_l_asg_id
485: and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id

Line 482: ,per_time_periods PPTP

478: ,pay_payroll_actions PACT
479: ,pay_assignment_actions ASSACT
480: ,pay_payroll_actions BACT
481: ,per_time_periods BPTP
482: ,per_time_periods PPTP
483: ,pay_assignment_actions BAL_ASSACT
484: where BAL_ASSACT.assignment_action_id = cp_l_asg_id
485: and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id
486: and FEED.balance_type_id = BAL.balance_type_id

Line 854: from per_time_periods ptp

850: -- set the start and end dates for the payroll year
851: update pay_gb_year_end_payrolls ye_roll
852: set ( START_YEAR, END_YEAR ,PERIOD_TYPE, MAX_PERIOD_NUMBER) =
853: ( select min(start_date), max(end_date), max(PERIOD_TYPE), max(PERIOD_NUM)
854: from per_time_periods ptp
855: where PTP.payroll_id = ye_roll.payroll_id
856: and PTP.regular_payment_date between
857: l_start_year and l_end_year);
858: --

Line 863: ( select min(start_date), max(end_date) from per_time_periods ptp

859: hr_utility.set_location('PAY_YEAR_END_EXTRACT.EXTRACT',8);
860: -- set the start and end dates for the previous payroll year
861: update pay_gb_year_end_payrolls ye_roll
862: set ( START_PREVIOUS_YEAR, END_PREVIOUS_YEAR ) =
863: ( select min(start_date), max(end_date) from per_time_periods ptp
864: where PTP.payroll_id = ye_roll.payroll_id
865: and PTP.regular_payment_date between
866: add_months(l_start_year,-12)
867: and add_months(l_end_year,-12));