DBA Data[Home] [Help]

APPS.PAY_NL_CBS_FILE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 267: (select * from pay_assignment_actions paa

263: and nvl(posv.date_to,hr_general.end_of_time)
264: and posv.organization_structure_id = pay_magtape_generic.get_parameter_value('ORG_STRUCT_ID')
265: and pai.action_context_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
266: AND EXISTS
267: (select * from pay_assignment_actions paa
268: where paa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'));
269:
270: /********************************************************
271: * Cursor to fetch Employee record information *

Line 312: pay_assignment_actions pay_act,

308: 'CBS_SICKNESS_DAYS=P' ,cbs_pai.action_information22,
309: 'CBS_SI_DAYS_QUARTER=P' ,cbs_pai.action_information23,
310: 'CBS_FOREIGN_WORK=P' ,pap.per_information14
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