DBA Data[Home] [Help]

APPS.PAY_MX_SOE_SS_PKG dependencies on FND_DATE

Line 377: ,replace(substr(FND_DATE.DATE_TO_CANONICAL(pa.effective_date),1,10),'/','-') jsqldate --YYYY-MM-DD

373: --
374: cursor getParameters(c_assignment_action_id in number) is
375: select pa.payroll_id
376: --, to_number(to_char(pa.effective_date,'J')) effective_date
377: ,replace(substr(FND_DATE.DATE_TO_CANONICAL(pa.effective_date),1,10),'/','-') jsqldate --YYYY-MM-DD
378: ,'' || pa.effective_date || '' effective_date
379: , aa.assignment_id
380: , pa.business_group_id
381: , aa.tax_unit_id