DBA Data[Home] [Help]

APPS.PAY_SIMULATOR_PKG dependencies on PER_TIME_PERIODS

Line 759: per_time_periods ptp

755: SELECT paa.assignment_id, ptp.start_date, ptp.end_date
756: INTO v_ass_id,v_period_start_date,v_period_end_date
757: FROM pay_assignment_actions paa,
758: pay_payroll_actions ppa,
759: per_time_periods ptp
760: WHERE paa.assignment_action_id = p_assact_id
761: AND ppa.payroll_action_id = paa.payroll_action_id
762: AND ptp.time_period_id = ppa.time_period_id
763: ;

Line 845: per_time_periods ptp

841: SELECT paa.assignment_id, ptp.end_date
842: INTO v_asg_id,v_effective_date
843: FROM pay_assignment_actions paa,
844: pay_payroll_actions ppa,
845: per_time_periods ptp
846: WHERE paa.assignment_action_id = p_assact_id
847: AND ppa.payroll_action_id = paa.payroll_action_id
848: AND ptp.time_period_id = ppa.time_period_id
849: ;

Line 950: per_time_periods ptp

946: SELECT paa.assignment_id, ptp.start_date, ptp.end_date
947: INTO v_ass_id,v_period_start_date,v_period_end_date
948: FROM pay_assignment_actions paa,
949: pay_payroll_actions ppa,
950: per_time_periods ptp
951: WHERE paa.assignment_action_id = p_assact_id
952: AND ppa.payroll_action_id = paa.payroll_action_id
953: AND ptp.time_period_id = ppa.time_period_id
954: ;