APPS.PAY_NZ_PAYSLIP_ARCHIVE dependencies on PER_TIME_PERIODS

Line 900: ,per_time_periods ptp

896: ,pay_assignment_actions paa_run
897: ,pay_action_interlocks pai_run
898: ,pay_payroll_actions ppa_pre
899: ,pay_payroll_actions ppa_run
900: ,per_time_periods ptp
901: ,per_business_groups pbg
902: WHERE paa_arch_mst.assignment_action_id = p_master_aa_id
903: AND paa_arch_chd.source_action_id = paa_arch_mst.assignment_action_id
904: AND paa_arch_chd.payroll_action_id = paa_arch_mst.payroll_action_id

Line 938: per_time_periods ptp,

934: IS
935: SELECT pps.actual_termination_date
936: FROM pay_payroll_actions ppa,
937: pay_assignment_actions paa,
938: per_time_periods ptp,
939: per_all_assignments_f paf,
940: per_periods_of_service pps
941: WHERE paa.assignment_action_id = p_assignment_action_id
942: AND ppa.payroll_action_id = paa.payroll_action_id

Line 952: l_time_period_id per_time_periods.time_period_id%type; /* Bug No : 2491444 */

948:
949:
950: l_pre_pay_assact_id NUMBER;
951: l_period_end_date DATE;
952: l_time_period_id per_time_periods.time_period_id%type; /* Bug No : 2491444 */
953: l_payment_date DATE :=NULL;
954:
955: BEGIN
956:

Line 1043: , p_time_period_id => csr_rec.time_period_id -- time_period_id of per_time_periods

1039: , p_curr_pymt_ass_act_id => csr_rec.pre_assignment_action_id -- prepayment assignment_action_id
1040: , p_date_earned => csr_rec.run_date_earned -- payroll date_earned
1041: , p_curr_pymt_eff_date => l_payment_date -- latest payment period end date
1042: , p_run_effective_date => csr_rec.run_effective_date -- run effective Date
1043: , p_time_period_id => csr_rec.time_period_id -- time_period_id of per_time_periods
1044: );
1045:
1046:
1047: -- Call to procedure to archive accrual and absennce details