APPS.PAY_KR_PAYSLIP_ARCHIVE dependencies on PER_TIME_PERIODS

Line 720: per_time_periods ptp

716: pay_assignment_actions paa_run,
717: pay_action_interlocks pai_run,
718: pay_payroll_actions ppa_pre,
719: pay_payroll_actions ppa_run,
720: per_time_periods ptp
721: WHERE paa_arch_mst.assignment_action_id = p_master_aa_id
722: AND paa_arch_chd.source_action_id = paa_arch_mst.assignment_action_id
723: AND paa_arch_chd.payroll_action_id = paa_arch_mst.payroll_action_id
724: AND paa_arch_chd.assignment_id = paa_arch_mst.assignment_id

Line 751: FROM per_time_periods ptp

747: IS
748: SELECT ptp.end_date end_date,
749: ptp.regular_payment_date regular_payment_date,
750: ptp.time_period_id time_period_id
751: FROM per_time_periods ptp
752: ,pay_payroll_actions ppa
753: WHERE ptp.payroll_id = ppa.payroll_id
754: AND ppa.payroll_action_id = ( SELECT payroll_action_id
755: FROM pay_assignment_actions

Line 766: per_time_periods ptp,

762: SELECT pps.actual_termination_date
763: FROM per_all_assignments_f paf,
764: per_periods_of_service pps,
765: pay_assignment_actions paa,
766: per_time_periods ptp,
767: pay_payroll_actions ppa
768: WHERE paa.assignment_action_id = p_assignment_action_id
769: AND ptp.payroll_id = ppa.payroll_id
770: AND paf.assignment_id = paa.assignment_id

Line 792: l_time_period_id per_time_periods.time_period_id%TYPE;

788: l_line_sequence NUMBER;
789: l_period_end_date DATE;
790: l_payment_date DATE;
791: l_regular_payment_date DATE;
792: l_time_period_id per_time_periods.time_period_id%TYPE;
793:
794: BEGIN
795:
796: if g_debug then