APPS.PYIEEXC dependencies on PER_TIME_PERIODS

Line 69: from per_time_periods ptp, pay_payroll_actions ppa

65: l_period_start_date date;
66: begin
67: select ptp.start_date
68: into l_period_start_date
69: from per_time_periods ptp, pay_payroll_actions ppa
70: where ppa.payroll_action_id = p_user_payroll_action_id
71: and ppa.payroll_id = ptp.payroll_id
72: and p_user_effective_date between ptp.start_date and ptp.end_date;
73: -- see if balance was written in this period. If not it is expired

Line 277: from --per_time_periods PTP,

273: + decode(sign( PPA.effective_date - to_date('01-01-'
274: || to_char(PPA.effective_date,'YYYY'),'DD-MM-YYYY')),
275: -1,-1,0)),'DD-MM-YYYY') finyear
276: into l_tax_year_start
277: from --per_time_periods PTP,
278: pay_payroll_actions ppa,
279: pay_assignment_actions paa
280: where ppa.payroll_action_id = paa.payroll_action_id
281: and paa.assignment_action_id = p_asg_action