DBA Data[Home] [Help]

APPS.PAY_MX_SOE_SS_PKG dependencies on FND_DATE

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

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