APPS.PAY_IN_24Q_ER_RETURNS dependencies on FND_DATE

Line 354: , TO_CHAR(fnd_date.canonical_to_date(pai.action_information5),'DDMMYYYY')

350: , pai.action_information1
351: , 'BANK_BRANCH_CODE=P'
352: , SUBSTR(pai.action_information4,1,7)||'^'
353: , 'CHALLAN_DATE=P'
354: , TO_CHAR(fnd_date.canonical_to_date(pai.action_information5),'DDMMYYYY')
355: , 'TDS_DEP=P'
356: , NVL(pai.action_information6,'0')||'.00'
357: , 'SURCHARGE=P'
358: , NVL(pai.action_information7,'0')||'.00'

Line 383: AND fnd_date.canonical_to_date(pai.action_information5)<=fnd_date.CHARDATE_TO_DATE(SYSDATE)

379: AND action_context_type = 'PA'
380: AND action_information3 = g_gre_org_id
381: AND action_information2 = g_assess_year||g_quarter
382: AND pai.action_context_id= pay_magtape_generic.get_parameter_value('MAX_ACTION_CONTEXT_ID')
383: AND fnd_date.canonical_to_date(pai.action_information5)<=fnd_date.CHARDATE_TO_DATE(SYSDATE)
384: UNION
385: SELECT
386: 'TOT_DEDUCTEE_REC=P'
387: , '0'

Line 429: AND fnd_date.canonical_to_date(pai.action_information5)<=fnd_date.CHARDATE_TO_DATE(SYSDATE)

425: AND action_context_type = 'PA'
426: AND action_information3 = g_gre_org_id
427: AND action_information2 = g_assess_year||g_quarter
428: AND pai.action_context_id= pay_magtape_generic.get_parameter_value('MAX_ACTION_CONTEXT_ID')
429: AND fnd_date.canonical_to_date(pai.action_information5)<=fnd_date.CHARDATE_TO_DATE(SYSDATE)
430: )
431: ORDER BY 32;
432:
433:

Line 456: , TO_CHAR(fnd_date.canonical_to_date( pai.action_information4),'DDMMYYYY')

452: , pay_in_24q_er_returns.get_format_value(NVL(pai.action_information9,'0'))
453: , 'AMOUNT_PAYMENT=P'
454: , pay_in_24q_er_returns.get_format_value(NVL(pai.action_information5,'0'))
455: , 'PAYMENT_DATE=P'
456: , TO_CHAR(fnd_date.canonical_to_date( pai.action_information4),'DDMMYYYY')
457: , 'TAX_RATE=P'
458: , NVL(pai.action_information13,'0')
459: , 'DED_REC_INDEX=P'
460: , action_information25

Line 495: , TO_CHAR(fnd_date.canonical_to_date(action_information9),'DDMMYYYY')

491: , SUBSTR(action_information6,1,75)
492: , 'EMP_DESIGNATION=P'
493: , SUBSTR (action_information8,1,15)||'^'
494: , 'EMP_START_DATE=P'
495: , TO_CHAR(fnd_date.canonical_to_date(action_information9),'DDMMYYYY')
496: , 'EMP_END_DATE=P'
497: , TO_CHAR(fnd_date.canonical_to_date(action_information10),'DDMMYYYY')
498: , 'CHAPTER_VIA_COUNT=P'
499: , pay_in_24q_er_returns.chapter_VIA_rec_count(action_context_id,source_id)

Line 497: , TO_CHAR(fnd_date.canonical_to_date(action_information10),'DDMMYYYY')

493: , SUBSTR (action_information8,1,15)||'^'
494: , 'EMP_START_DATE=P'
495: , TO_CHAR(fnd_date.canonical_to_date(action_information9),'DDMMYYYY')
496: , 'EMP_END_DATE=P'
497: , TO_CHAR(fnd_date.canonical_to_date(action_information10),'DDMMYYYY')
498: , 'CHAPTER_VIA_COUNT=P'
499: , pay_in_24q_er_returns.chapter_VIA_rec_count(action_context_id,source_id)
500: , 'F16_SEC17_SAL=P'
501: , pay_in_24q_er_returns.get_24Q_values('IN_24Q_SALARY','F16 Salary Under Section 17',action_context_id,source_id,1)