APPS.PAY_NL_PAYFILE_SEPA dependencies on FND_DATE

Line 72: ,to_char(fnd_date.canonical_to_date(pay_nl_general.get_parameter(

68: ,NULL
69: ,'CREATION_DATE=P'
70: ,to_char(ppa.effective_date, 'RRRR-MM-DD"T"HH24:MI:SS')
71: ,'PROCESS_DATE=P'
72: ,to_char(fnd_date.canonical_to_date(pay_nl_general.get_parameter(
73: ppa.legislative_parameters,
74: 'PROCESS_DATE')), 'RRRR-MM-DD')
75: ,'BATCH_BOOKING=P'
76: ,decode(pay_nl_general.get_parameter(ppa.legislative_parameters,'BATCH_BOOKING'),'Y','TRUE','N','FALSE','TRUE')

Line 110: ,to_char(fnd_date.canonical_to_date(pay_nl_general.get_parameter(

106: SELECT 'PARA_PMNT1=P'
107: --To print the closing tag correctlty in case of multiple Employers.
108: ,to_char(hou.organization_id)||to_char(pea.external_account_id)||to_char(hoi.org_information4)
109: ,'REQ_EXEC_DATE=P'
110: ,to_char(fnd_date.canonical_to_date(pay_nl_general.get_parameter(
111: ppa.legislative_parameters,
112: 'PROCESS_DATE')), 'RRRR-MM-DD')
113: ,'DBTR_NAME=P'
114: ,hou.name

Line 177: Group by to_char(fnd_date.canonical_to_date(pay_nl_general.get_parameter(

173: AND ppf.prl_information_category = 'NL'
174: AND ppa.effective_date between paaf.effective_start_date and paaf.effective_end_date
175: AND ppa.effective_date between ppf.effective_start_date and ppf.effective_end_date
176: )
177: Group by to_char(fnd_date.canonical_to_date(pay_nl_general.get_parameter(
178: ppa.legislative_parameters,
179: 'PROCESS_DATE')), 'RRRR-MM-DD')
180: ,hou.name
181: ,hou.organization_id