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_NL_CBS_FILE dependencies on FND_DATE

Line 251: 'REPORTING_DATE=P',TO_CHAR(fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('REPORTING_DATE')),'DDMMYYYY'),

247: 'ORG_STRUCT_ID=P',pay_magtape_generic.get_parameter_value('ORG_STRUCT_ID'),
248: 'BUSINESS_GROUP_ID=P',ppa.business_group_id,
249: 'EMPLOYER_ID=P',pay_magtape_generic.get_parameter_value('EMPLOYER_ID'),
250: 'SI_PROVIDER_ID=P',pay_magtape_generic.get_parameter_value('SI_PROVIDER_ID'),
251: 'REPORTING_DATE=P',TO_CHAR(fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('REPORTING_DATE')),'DDMMYYYY'),
252: 'MEDIUM_CODE=P',pay_magtape_generic.get_parameter_value('MEDIUM_CODE'),
253: 'DENSITY=P',pay_magtape_generic.get_parameter_value('DENSITY'),
254: 'ORG_STRUCT_VERSION_ID=P',posv.organization_structure_id,
255: 'REPORTING_SEQUENCE=P',pai.action_information4,

Line 256: 'PERIODIC_REP_START_DATE=P' ,TO_CHAR(fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('REPORTING_DATE'))-28,'DDMMYYYY')

252: 'MEDIUM_CODE=P',pay_magtape_generic.get_parameter_value('MEDIUM_CODE'),
253: 'DENSITY=P',pay_magtape_generic.get_parameter_value('DENSITY'),
254: 'ORG_STRUCT_VERSION_ID=P',posv.organization_structure_id,
255: 'REPORTING_SEQUENCE=P',pai.action_information4,
256: 'PERIODIC_REP_START_DATE=P' ,TO_CHAR(fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('REPORTING_DATE'))-28,'DDMMYYYY')
257: FROM pay_payroll_actions ppa,
258: per_org_structure_versions posv,
259: pay_action_information pai
260: WHERE ppa.payroll_action_id

Line 262: and fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('REPORTING_DATE')) between posv.date_from

258: per_org_structure_versions posv,
259: pay_action_information pai
260: WHERE ppa.payroll_action_id
261: =pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
262: and fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('REPORTING_DATE')) between posv.date_from
263: and nvl(posv.date_to,hr_general.end_of_time)
264: and posv.organization_structure_id = pay_magtape_generic.get_parameter_value('ORG_STRUCT_ID')
265: and pai.action_context_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
266: AND EXISTS