[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