DBA Data[Home] [Help]

APPS.PAY_NL_CBS_FILE dependencies on PER_ALL_ASSIGNMENTS_F

Line 315: per_all_assignments_f paa,

311: FROM
312: pay_assignment_actions pay_act,
313: pay_action_information cbs_pai,
314: per_all_people_f pap,
315: per_all_assignments_f paa,
316: pay_payrolls_f ppf
317: WHERE pay_act.payroll_action_id
318: =pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
319: AND pay_act.assignment_action_id = cbs_pai.action_context_id

Line 329: from per_all_assignments_f asg

325: AND ppf.payroll_id = paa.payroll_id
326: AND cbs_pai.effective_date between pap.effective_start_date and pap.effective_end_date
327: AND cbs_pai.effective_date between ppf.effective_start_date and ppf.effective_end_date
328: AND paa.effective_end_date in(select max(asg.effective_end_date)
329: from per_all_assignments_f asg
330: where asg.effective_end_date >= cbs_pai.effective_date
331: and asg.assignment_id=paa.assignment_id)
332: ORDER BY ppf.period_type;
333: END PAY_NL_CBS_FILE;