eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_IE_PAYFILE_SEPA dependencies on FND_DATE

Line 56: ,'CREATION_DATE=P', to_char(fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('PROCESSING_DATE')), 'RRRR-MM-DD"T"HH24:MI:SS')

52: CURSOR CSR_IE_HDR_FTR IS
53: SELECT DISTINCT 'TRANSFER_PARA_PMNT1=P',NULL
54: --To print the closing tag correctlty in case of multiple Employers.
55: --,'CREATION_DATE=P', to_char(ppa.effective_date, 'RRRR-MM-DD"T"HH24:MI:SS')
56: ,'CREATION_DATE=P', to_char(fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('PROCESSING_DATE')), 'RRRR-MM-DD"T"HH24:MI:SS')
57: ,'PROCESS_DATE=P' ,to_char(fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('PROCESSING_DATE')), 'RRRR-MM-DD')
58: ,'BATCH_BOOKING=P',decode(pay_ie_payfile_sepa.get_parameter(ppa.legislative_parameters,'BATCH_BOOKING'),'Y','TRUE','N','FALSE','TRUE')
59: ,'TRANSFER_ORG_PAY_METHOD_ID=P',to_char(ppa.org_payment_method_id)
60: ,'DATE_EARNED=C',to_char(ppa.effective_date, 'RRRR/MM/DD HH24:MI:SS')

Line 57: ,'PROCESS_DATE=P' ,to_char(fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('PROCESSING_DATE')), 'RRRR-MM-DD')

53: SELECT DISTINCT 'TRANSFER_PARA_PMNT1=P',NULL
54: --To print the closing tag correctlty in case of multiple Employers.
55: --,'CREATION_DATE=P', to_char(ppa.effective_date, 'RRRR-MM-DD"T"HH24:MI:SS')
56: ,'CREATION_DATE=P', to_char(fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('PROCESSING_DATE')), 'RRRR-MM-DD"T"HH24:MI:SS')
57: ,'PROCESS_DATE=P' ,to_char(fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('PROCESSING_DATE')), 'RRRR-MM-DD')
58: ,'BATCH_BOOKING=P',decode(pay_ie_payfile_sepa.get_parameter(ppa.legislative_parameters,'BATCH_BOOKING'),'Y','TRUE','N','FALSE','TRUE')
59: ,'TRANSFER_ORG_PAY_METHOD_ID=P',to_char(ppa.org_payment_method_id)
60: ,'DATE_EARNED=C',to_char(ppa.effective_date, 'RRRR/MM/DD HH24:MI:SS')
61: ,'ORG_PAY_METHOD_ID=C',ppa.org_payment_method_id

Line 93: ,'REQ_EXEC_DATE=P',to_char(fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('PROCESSING_DATE')), 'RRRR-MM-DD')

89: ********************************************************/
90: CURSOR CSR_IE_PMNT_INFO IS
91: SELECT distinct 'PARA_PMNT1=P' ,to_char(pea.external_account_id)
92: --To print the closing tag correctlty in case of multiple Employers.
93: ,'REQ_EXEC_DATE=P',to_char(fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('PROCESSING_DATE')), 'RRRR-MM-DD')
94: ,'DBTR_NAME=P',hou.name
95: ,'TRANSFER_ORGANIZATION_ID=P',to_char(hou.organization_id)
96: ,'EXTERNAL_ACCOUNT_ID=P',to_char(pea.external_account_id)
97: ,'IBAN=P',NVL(pea.SEGMENT7,' ')

Line 155: Group by to_char(fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('PROCESSING_DATE')), 'RRRR-MM-DD')

151: -- and hsck.segment4 = hou.organization_id
152: AND ppa.effective_date between paaf.effective_start_date and paaf.effective_end_date
153: AND ppa.effective_date between ppf.effective_start_date and ppf.effective_end_date
154: )
155: Group by to_char(fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('PROCESSING_DATE')), 'RRRR-MM-DD')
156: ,hou.name
157: ,hou.organization_id
158: ,pea.external_account_id
159: ,NVL(pea.SEGMENT7,' ')