APPS.PAY_GB_MOVDED_EDI dependencies on FND_DATE

Line 169: 'EFFECTIVE_DATE=P', fnd_date.date_to_canonical(pay.effective_date)

165: 'TOWN_OR_CITY=P', nvl(upper(addr.action_information8),' '),
166: 'STUDENT_LOAN_FLAG_START_DATE=P', nvl(p453.action_information10,'X'),
167: 'STUDENT_LOAN_FLAG_END_DATE=P', nvl(p453.action_information11,'4712/12/31 00:00:00'),
168: 'STUDENT_LOAN_FLAG_EFFECTIVE_END_DATE=P', nvl(p453.action_information12,'4712/12/31 00:00:00') ,
169: 'EFFECTIVE_DATE=P', fnd_date.date_to_canonical(pay.effective_date)
170: from pay_payroll_actions pay,
171: pay_assignment_actions paa,
172: pay_action_information addr,
173: pay_action_information peo,

Line 436: 'EFFECTIVE_DATE=P', fnd_date.date_to_canonical(pay.effective_date),

432: 'TOWN_OR_CITY=P', nvl(upper(addr.action_information8),' '),
433: 'STUDENT_LOAN_FLAG_START_DATE=P', nvl(p453.action_information10,'X'),
434: 'STUDENT_LOAN_FLAG_END_DATE=P', nvl(p453.action_information11,'4712/12/31 00:00:00'),
435: 'STUDENT_LOAN_FLAG_EFFECTIVE_END_DATE=P', nvl(p453.action_information12,'4712/12/31 00:00:00') ,
436: 'EFFECTIVE_DATE=P', fnd_date.date_to_canonical(pay.effective_date),
437: --Bug 7157720 report PREVIOUS_TAX_PAID_NOTIFIED if >=0
438: -- Bug 6994632 assigning NULL if it is zero
439: 'PREVIOUS_TAX_PAID_NOTIFIED=P', nvl(p453.action_information13,' '),
440: --'PREVIOUS_TAX_PAID_NOTIFIED=P', nvl(decode(p453.action_information13,0,' ',p453.action_information13),' '),

Line 531: 'EFFECTIVE_DATE=P', fnd_date.date_to_canonical(pay.effective_date)

527: 'TAX_CODE_LEAVING=P', nvl(p46p.action_information6,' '),
528: 'TAX_BASIS_PREV=P', nvl(p46p.action_information7,' '),
529: 'PREV_PAY_TYPE=P', nvl(p46p.action_information8,' '),
530: 'PREV_PAY_PERIOD=P', nvl(p46p.action_information9,' '),
531: 'EFFECTIVE_DATE=P', fnd_date.date_to_canonical(pay.effective_date)
532: from pay_payroll_actions pay,
533: pay_assignment_actions paa,
534: pay_action_information addr,
535: pay_action_information peo,

Line 599: 'EFFECTIVE_DATE=P', fnd_date.date_to_canonical(pay.effective_date)

595: 'TITLE=P', nvl(substr(peo.action_information14,1,4),' '),
596: 'TOWN_OR_CITY=P', nvl(upper(addr.action_information8),' '),
597: 'SEX=P', nvl(peo.action_information17,' '),
598: 'JOB_TITLE=P', nvl(peo.action_information18,' '),
599: 'EFFECTIVE_DATE=P', fnd_date.date_to_canonical(pay.effective_date)
600: from pay_payroll_actions pay,
601: pay_assignment_actions paa,
602: pay_action_information addr,
603: pay_action_information peo,