APPS.PAY_AU_EXC dependencies on PER_TIME_PERIODS

Line 54: FROM per_time_periods ptp,

50: /* Get the date next to the end date of the given period,
51: having the payroll action id */
52: SELECT PTP.end_date+1
53: INTO l_next_to_end_date
54: FROM per_time_periods ptp,
55: pay_payroll_actions pact
56: WHERE pact.payroll_action_id = p_payroll_action_id
57: AND pact.payroll_id = ptp.payroll_id
58: AND p_given_date between ptp.start_date and ptp.end_date;

Line 197: , per_time_periods ptp

193: , p_assignment_action_id number
194: , p_effective_date date) is
195: select ptp.time_period_id
196: from pay_payroll_actions act
197: , per_time_periods ptp
198: where payroll_action_id = p_payroll_action_id
199: and act.date_earned between ptp.start_date and ptp.end_date
200: and act.payroll_id = ptp.payroll_id
201: and act.effective_date = p_effective_date;