DBA Data[Home] [Help]

APPS.PAY_PAYROLL_ACTIONS_PKG dependencies on FND_DATE

Line 451: select fnd_date.date_to_canonical(pacc.effective_date)||'-'||to_char(pacv.start_cheque_number)

447: -- ChequeWriter run is not kept on the void payroll action record.
448: -- Instead it has to be retrieved through the interlock records it retrieves.
449: --
450: cursor get_void_chq is
451: select fnd_date.date_to_canonical(pacc.effective_date)||'-'||to_char(pacv.start_cheque_number)
452: ||'-'||to_char(pacv.end_cheque_number)
453: from pay_payroll_actions pacc,
454: pay_payroll_actions pacv
455: where pacv.payroll_action_id = p_payroll_action_id