APPS.PAY_CN_PAYSLIP_ARCHIVE dependencies on PER_TIME_PERIODS

Line 462: ,per_time_periods ptp

458: FROM pay_assignment_actions paa
459: ,pay_payroll_actions ppa
460: ,pay_run_results prr
461: ,pay_run_result_values prrv
462: ,per_time_periods ptp
463: ,pay_element_types_f pet
464: ,pay_input_values_f piv
465: ,pay_element_entries_f pee
466: ,per_absence_attendance_types pat

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

1794: ,p_curr_eff_date => p_run_effective_date -- run effective_date
1795: ,p_date_earned => p_date_earned -- payroll date_earned
1796: ,p_curr_pymt_eff_date => p_latest_period_payment_date -- latest payment date
1797: ,p_tax_unit_id => l_tax_unit_id -- tax_unit_id needed for Choose Payslip region.
1798: ,p_time_period_id => p_time_period_id -- time_period_id from per_time_periods
1799: ,p_ppp_source_action_id => NULL
1800: ,p_run_action_id => p_pay_assignment_action_id
1801: );
1802:

Line 2041: ,per_time_periods ptp

2037: ,pay_assignment_actions paa_run
2038: ,pay_action_interlocks pai_run
2039: ,pay_payroll_actions ppa_pre
2040: ,pay_payroll_actions ppa_run
2041: ,per_time_periods ptp
2042: ,per_business_groups pbg
2043: WHERE paa_arch_mst.assignment_action_id = p_master_aa_id
2044: AND paa_arch_chd.source_action_id = paa_arch_mst.assignment_action_id
2045: AND paa_arch_chd.payroll_action_id = paa_arch_mst.payroll_action_id

Line 2079: per_time_periods ptp,

2075: IS
2076: SELECT pps.actual_termination_date
2077: FROM pay_payroll_actions ppa,
2078: pay_assignment_actions paa,
2079: per_time_periods ptp,
2080: per_all_assignments_f paf,
2081: per_periods_of_service pps
2082: WHERE paa.assignment_action_id = p_assignment_action_id
2083: AND ppa.payroll_action_id = paa.payroll_action_id

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

2199: ,p_curr_pymt_ass_act_id => csr_rec.pre_assignment_action_id -- prepayment assignment_action_id
2200: ,p_date_earned => csr_rec.run_date_earned -- payroll date_earned
2201: ,p_latest_period_payment_date => l_payment_date -- latest payment date
2202: ,p_run_effective_date => csr_rec.run_effective_date -- run effective Date
2203: ,p_time_period_id => csr_rec.time_period_id -- time_period_id from per_time_periods
2204: ,p_pre_effective_date => csr_rec.pre_effective_date -- prepayment effective date
2205: );
2206:
2207: