APPS.PYIEEXC dependencies on PER_TIME_PERIODS

Line 68: from per_time_periods TP,

64: l_return_val DATE := NULL;
65: BEGIN
66: select TP.end_date + 1
67: into l_return_val
68: from per_time_periods TP,
69: pay_payroll_actions PACT
70: where PACT.payroll_action_id = p_pactid
71: and PACT.payroll_id = TP.payroll_id
72: and p_date between TP.start_date and TP.end_date;

Line 124: from per_time_periods ptp, pay_payroll_actions ppa

120: l_period_start_date date;
121: begin
122: select ptp.start_date
123: into l_period_start_date
124: from per_time_periods ptp, pay_payroll_actions ppa
125: where ppa.payroll_action_id = p_user_payroll_action_id
126: and ppa.payroll_id = ptp.payroll_id
127: and p_user_effective_date between ptp.start_date and ptp.end_date;
128: -- see if balance was written in this period. If not it is expired

Line 470: from --per_time_periods PTP,

466: + decode(sign( PPA.effective_date - to_date('01-01-'
467: || to_char(PPA.effective_date,'YYYY'),'DD-MM-YYYY')),
468: -1,-1,0)),'DD-MM-YYYY') finyear
469: into l_tax_year_start
470: from --per_time_periods PTP,
471: pay_payroll_actions ppa,
472: pay_assignment_actions paa
473: where ppa.payroll_action_id = paa.payroll_action_id
474: and paa.assignment_action_id = p_asg_action