APPS.PYIEEXC dependencies on PAY_PAYROLL_ACTIONS

Line 69: pay_payroll_actions PACT

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;
73:

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

192: + decode(sign( BACT.effective_date - to_date('01-01-'
193: || to_char(BACT.effective_date,'YYYY'),'DD-MM-YYYY')),
194: -1,-1,0)),'DD-MM-YYYY') finyear, BACT.payroll_id
195: into l_tax_year_start, l_user_payroll_id
196: from pay_payroll_actions BACT
197: where BACT.payroll_action_id = p_user_payroll_action_id;
198: --
199: --
200: if p_owner_effective_date < l_tax_year_start then

Line 270: from pay_payroll_actions

266: */
267:
268: select time_period_id
269: into l_user_time_period_id
270: from pay_payroll_actions
271: where payroll_action_id = p_user_payroll_action_id;
272:
273: select time_period_id
274: into l_owner_time_period_id

Line 275: from pay_payroll_actions

271: where payroll_action_id = p_user_payroll_action_id;
272:
273: select time_period_id
274: into l_owner_time_period_id
275: from pay_payroll_actions
276: where payroll_action_id = p_owner_payroll_action_id;
277:
278: if l_user_time_period_id = l_owner_time_period_id then
279: p_expiry_information := 0;

Line 405: from pay_payroll_actions BACT

401: + decode(sign( BACT.effective_date - to_date('01-01-'
402: || to_char(BACT.effective_date,'YYYY'),'DD-MM-YYYY')),
403: -1,-1,0)),'DD-MM-YYYY') finyear, BACT.payroll_id
404: into l_tax_year_start, l_user_payroll_id
405: from pay_payroll_actions BACT
406: where BACT.payroll_action_id = p_user_payroll_action_id;
407: --
408: --
409: if p_owner_effective_date < l_tax_year_start then

Line 471: pay_payroll_actions ppa,

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