APPS.PAY_PYIEEXC dependencies on PAY_PAYROLL_ACTIONS

Line 64: from per_time_periods ptp, pay_payroll_actions ppa

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

Line 109: from pay_payroll_actions BACT

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

Line 154: from pay_payroll_actions

150: */
151:
152: select time_period_id
153: into l_user_time_period_id
154: from pay_payroll_actions
155: where payroll_action_id = p_user_payroll_action_id;
156:
157: select time_period_id
158: into l_owner_time_period_id

Line 159: from pay_payroll_actions

155: where payroll_action_id = p_user_payroll_action_id;
156:
157: select time_period_id
158: into l_owner_time_period_id
159: from pay_payroll_actions
160: where payroll_action_id = p_owner_payroll_action_id;
161:
162: if l_user_time_period_id = l_owner_time_period_id then
163: p_expiry_information := 0;