DBA Data[Home] [Help]

APPS.PAY_NL_CBS_FILE dependencies on HR_GENERAL

Line 263: and nvl(posv.date_to,hr_general.end_of_time)

259: pay_action_information pai
260: WHERE ppa.payroll_action_id
261: =pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
262: and fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('REPORTING_DATE')) between posv.date_from
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