APPS.PYIEEXC dependencies on PAY_PAYROLL_ACTIONS

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 114: from pay_payroll_actions BACT

110: + decode(sign( BACT.effective_date - to_date('01-01-'
111: || to_char(BACT.effective_date,'YYYY'),'DD-MM-YYYY')),
112: -1,-1,0)),'DD-MM-YYYY') finyear, BACT.payroll_id
113: into l_tax_year_start, l_user_payroll_id
114: from pay_payroll_actions BACT
115: where BACT.payroll_action_id = p_user_payroll_action_id;
116: --
117: --
118: if p_owner_effective_date < l_tax_year_start then

Line 159: from pay_payroll_actions

155: */
156:
157: select time_period_id
158: into l_user_time_period_id
159: from pay_payroll_actions
160: where payroll_action_id = p_user_payroll_action_id;
161:
162: select time_period_id
163: into l_owner_time_period_id

Line 164: from pay_payroll_actions

160: where payroll_action_id = p_user_payroll_action_id;
161:
162: select time_period_id
163: into l_owner_time_period_id
164: from pay_payroll_actions
165: where payroll_action_id = p_owner_payroll_action_id;
166:
167: if l_user_time_period_id = l_owner_time_period_id then
168: p_expiry_information := 0;

Line 240: from pay_payroll_actions BACT

236: + decode(sign( BACT.effective_date - to_date('01-01-'
237: || to_char(BACT.effective_date,'YYYY'),'DD-MM-YYYY')),
238: -1,-1,0)),'DD-MM-YYYY') finyear, BACT.payroll_id
239: into l_tax_year_start, l_user_payroll_id
240: from pay_payroll_actions BACT
241: where BACT.payroll_action_id = p_user_payroll_action_id;
242: --
243: --
244: if p_owner_effective_date < l_tax_year_start then

Line 278: pay_payroll_actions ppa,

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
282: and ppa.payroll_id = p_payroll_id;