APPS.PAY_IN_PAYSLIP_ARCHIVE dependencies on PER_TIME_PERIODS

Line 649: ,per_time_periods ptp

645: FROM pay_assignment_actions paa
646: ,pay_payroll_actions ppa
647: ,pay_run_results prr
648: ,pay_run_result_values prrv
649: ,per_time_periods ptp
650: ,pay_element_types_f pet
651: ,pay_input_values_f piv
652: ,pay_element_entries_f pee
653: ,per_absence_attendance_types pat

Line 1610: ,p_time_period_id => p_time_period_id -- time_period_id from per_time_periods

1606: ,p_curr_eff_date => p_run_effective_date -- run effective_date
1607: ,p_date_earned => p_date_earned -- payroll date_earned
1608: ,p_curr_pymt_eff_date => p_latest_period_payment_date -- latest payment date
1609: ,p_tax_unit_id => l_tax_unit_id -- tax_unit_id needed for Choose Payslip region.
1610: ,p_time_period_id => p_time_period_id -- time_period_id from per_time_periods
1611: ,p_ppp_source_action_id => NULL
1612: ,p_run_action_id => p_pay_assignment_action_id
1613: );
1614: pay_in_utils.set_location(g_debug,l_procedure, 30);

Line 4076: ,per_time_periods ptp

4072: ,pay_assignment_actions paa_run
4073: ,pay_action_interlocks pai_run
4074: ,pay_payroll_actions ppa_pre
4075: ,pay_payroll_actions ppa_run
4076: ,per_time_periods ptp
4077: ,per_business_groups pbg
4078: WHERE paa_arch_mst.assignment_action_id = p_master_aa_id
4079: AND paa_arch_chd.source_action_id = paa_arch_mst.assignment_action_id
4080: AND paa_arch_chd.payroll_action_id = paa_arch_mst.payroll_action_id

Line 4171: per_time_periods ptp,

4167: IS
4168: SELECT pps.actual_termination_date
4169: FROM pay_payroll_actions ppa,
4170: pay_assignment_actions paa,
4171: per_time_periods ptp,
4172: per_all_assignments_f paf,
4173: per_periods_of_service pps
4174: WHERE paa.assignment_action_id = p_assignment_action_id
4175: AND ppa.payroll_action_id = paa.payroll_action_id

Line 4433: ,p_time_period_id => csr_rec.time_period_id -- time_period_id from per_time_periods

4429: ,p_curr_pymt_ass_act_id => csr_rec.pre_assignment_action_id -- prepayment assignment_action_id
4430: ,p_date_earned => csr_rec.run_date_earned -- payroll date_earned
4431: ,p_latest_period_payment_date => l_payment_date -- latest payment date
4432: ,p_run_effective_date => csr_rec.run_effective_date -- run effective Date
4433: ,p_time_period_id => csr_rec.time_period_id -- time_period_id from per_time_periods
4434: ,p_pre_effective_date => csr_rec.pre_effective_date -- prepayment effective date
4435: );
4436: pay_in_utils.set_location(g_debug,l_procedure, 200);
4437: