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 PAY_MAGTAPE_GENERIC

Line 247: 'ORG_STRUCT_ID=P',pay_magtape_generic.get_parameter_value('ORG_STRUCT_ID'),

243: * Cursor to fetch header record information *
244: ********************************************************/
245: Cursor Csr_NL_CBS_Header IS
246: SELECT
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'),

Line 249: 'EMPLOYER_ID=P',pay_magtape_generic.get_parameter_value('EMPLOYER_ID'),

245: Cursor Csr_NL_CBS_Header IS
246: SELECT
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'),

Line 250: 'SI_PROVIDER_ID=P',pay_magtape_generic.get_parameter_value('SI_PROVIDER_ID'),

246: SELECT
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,

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 252: 'MEDIUM_CODE=P',pay_magtape_generic.get_parameter_value('MEDIUM_CODE'),

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,
256: 'PERIODIC_REP_START_DATE=P' ,TO_CHAR(fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('REPORTING_DATE'))-28,'DDMMYYYY')

Line 253: 'DENSITY=P',pay_magtape_generic.get_parameter_value('DENSITY'),

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,
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,

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 261: =pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

257: FROM pay_payroll_actions ppa,
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')

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

Line 264: and posv.organization_structure_id = pay_magtape_generic.get_parameter_value('ORG_STRUCT_ID')

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
267: (select * from pay_assignment_actions paa
268: where paa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'));

Line 265: and pai.action_context_id = pay_magtape_generic.get_parameter_value('TRANSFER_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
267: (select * from pay_assignment_actions paa
268: where paa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'));
269:

Line 268: where paa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'));

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
267: (select * from pay_assignment_actions paa
268: where paa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'));
269:
270: /********************************************************
271: * Cursor to fetch Employee record information *
272: ********************************************************/

Line 318: =pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

314: per_all_people_f pap,
315: per_all_assignments_f paa,
316: pay_payrolls_f ppf
317: WHERE pay_act.payroll_action_id
318: =pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
319: AND pay_act.assignment_action_id = cbs_pai.action_context_id
320: AND cbs_pai.action_context_type='AAP'
321: AND cbs_pai.action_information_category = 'NL CBS EMPLOYEE DETAILS'
322: AND cbs_pai.action_information4 = pap.person_id