APPS.PAY_BF_EXPC dependencies on PAY_PAYROLL_ACTIONS

Line 76: pay_payroll_actions BACT

72: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
73: -1,-1,0)),'DD-MM-YYYY') finyear
74: into l_tax_year_start
75: from per_time_periods PTP,
76: pay_payroll_actions BACT
77: where BACT.payroll_action_id = p_user_payroll_action_id
78: and PTP.time_period_id = BACT.time_period_id;
79:
80: if p_owner_effective_date >= l_tax_year_start then

Line 137: pay_payroll_actions BACT

133: || to_char(PTP.regular_payment_date,'YYYY'),'DD-MM-YYYY')),
134: -1,-1,0)),'DD-MM-YYYY') finyear
135: into l_tax_year_start
136: from per_time_periods PTP,
137: pay_payroll_actions BACT
138: where BACT.payroll_action_id = p_user_payroll_action_id
139: and PTP.time_period_id = BACT.time_period_id;
140:
141: if p_owner_effective_date >= l_tax_year_start then

Line 175: pay_payroll_actions PACT

171: begin
172: select TP.start_date
173: into l_period_start_date
174: from per_time_periods TP,
175: pay_payroll_actions PACT
176: where PACT.payroll_action_id = p_user_payroll_action_id
177: and PACT.payroll_id = TP.payroll_id
178: and p_user_effective_date between TP.start_date and TP.end_date;
179:

Line 214: pay_payroll_actions PACT

210: begin
211: select TP.start_date
212: into l_period_start_date
213: from per_time_periods TP,
214: pay_payroll_actions PACT
215: where PACT.payroll_action_id = p_user_payroll_action_id
216: and PACT.payroll_id = TP.payroll_id
217: and p_user_effective_date between TP.start_date and TP.end_date;
218: if p_owner_effective_date >= l_period_start_date then

Line 257: pay_payroll_actions PACT

253: select TP.start_date
254: into l_period_start_date
255: from per_time_periods TP,
256: pay_assignment_actions ACT,
257: pay_payroll_actions PACT
258: where ACT.assignment_action_id = p_user_assignment_action_id
259: and ACT.payroll_action_id = PACT.payroll_action_id
260: and PACT.payroll_id = TP.payroll_id
261: and p_user_effective_date between TP.start_date and TP.end_date;