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.PER_US_VETS_TAP dependencies on PER_GEN_HIERARCHY_NODES

Line 91: per_gen_hierarchy_nodes pgn

87: pgn.entity_id,
88: 'TRANSFER_ESTABLISHMENT_ID1=P',
89: pgn.entity_id
90: FROM per_gen_hierarchy_versions pgv,
91: per_gen_hierarchy_nodes pgn
92: where pgv.hierarchy_version_id =
93: pay_magtape_generic.get_parameter_value('TRANSFER_ORG_STR_V_ID')
94: AND pgv.hierarchy_version_id = pgn.hierarchy_version_id
95: and pgn.node_type = 'PAR';

Line 141: ,per_gen_hierarchy_nodes pghn

137: hoi3.org_information1
138: from
139: hr_location_extra_info hlei1
140: ,hr_location_extra_info hlei2
141: ,per_gen_hierarchy_nodes pghn
142: ,per_gen_hierarchy_nodes pgn
143: ,hr_locations_all eloc
144: ,hr_organization_units hou
145: ,hr_organization_information hoi1

Line 142: ,per_gen_hierarchy_nodes pgn

138: from
139: hr_location_extra_info hlei1
140: ,hr_location_extra_info hlei2
141: ,per_gen_hierarchy_nodes pghn
142: ,per_gen_hierarchy_nodes pgn
143: ,hr_locations_all eloc
144: ,hr_organization_units hou
145: ,hr_organization_information hoi1
146: ,hr_organization_information hoi2

Line 241: from per_gen_hierarchy_nodes

237: AND ass.effective_end_date >=
238: to_date(pay_magtape_generic.get_parameter_value('TRANSFER_DATE_END'),'YYYY/MM/DD HH24:MI:SS')
239: AND ass.location_id in
240: (select entity_id
241: from per_gen_hierarchy_nodes
242: where node_type = 'EST'
243: and entity_id = pay_magtape_generic.get_parameter_value('TRANSFER_ESTABLISHMENT_ID')
244: and hierarchy_version_id = pay_magtape_generic.get_parameter_value('TRANSFER_ORG_STR_V_ID')
245: union

Line 247: from per_gen_hierarchy_nodes pghn,

243: and entity_id = pay_magtape_generic.get_parameter_value('TRANSFER_ESTABLISHMENT_ID')
244: and hierarchy_version_id = pay_magtape_generic.get_parameter_value('TRANSFER_ORG_STR_V_ID')
245: union
246: select pghn2.entity_id
247: from per_gen_hierarchy_nodes pghn,
248: per_gen_hierarchy_nodes pghn2
249: where pghn.entity_id = pay_magtape_generic.get_parameter_value('TRANSFER_ESTABLISHMENT_ID')
250: and pghn.hierarchy_version_id = pghn2.hierarchy_version_id
251: and pghn2.parent_hierarchy_node_id = pghn.hierarchy_node_id

Line 248: per_gen_hierarchy_nodes pghn2

244: and hierarchy_version_id = pay_magtape_generic.get_parameter_value('TRANSFER_ORG_STR_V_ID')
245: union
246: select pghn2.entity_id
247: from per_gen_hierarchy_nodes pghn,
248: per_gen_hierarchy_nodes pghn2
249: where pghn.entity_id = pay_magtape_generic.get_parameter_value('TRANSFER_ESTABLISHMENT_ID')
250: and pghn.hierarchy_version_id = pghn2.hierarchy_version_id
251: and pghn2.parent_hierarchy_node_id = pghn.hierarchy_node_id
252: and pghn2.node_type = 'LOC'

Line 318: from per_gen_hierarchy_nodes

314: AND ass.effective_end_date >=
315: to_date(pay_magtape_generic.get_parameter_value('TRANSFER_DATE_END'),'YYYY/MM/DD HH24:MI:SS')
316: AND ass.location_id in
317: (select entity_id
318: from per_gen_hierarchy_nodes
319: where node_type = 'EST'
320: and entity_id = pay_magtape_generic.get_parameter_value('TRANSFER_ESTABLISHMENT_ID')
321: and hierarchy_version_id = pay_magtape_generic.get_parameter_value('TRANSFER_ORG_STR_V_ID')
322: union

Line 324: from per_gen_hierarchy_nodes pghn,

320: and entity_id = pay_magtape_generic.get_parameter_value('TRANSFER_ESTABLISHMENT_ID')
321: and hierarchy_version_id = pay_magtape_generic.get_parameter_value('TRANSFER_ORG_STR_V_ID')
322: union
323: select pghn2.entity_id
324: from per_gen_hierarchy_nodes pghn,
325: per_gen_hierarchy_nodes pghn2
326: where pghn.entity_id = pay_magtape_generic.get_parameter_value('TRANSFER_ESTABLISHMENT_ID')
327: and pghn.hierarchy_version_id = pghn2.hierarchy_version_id
328: and pghn2.parent_hierarchy_node_id = pghn.hierarchy_node_id

Line 325: per_gen_hierarchy_nodes pghn2

321: and hierarchy_version_id = pay_magtape_generic.get_parameter_value('TRANSFER_ORG_STR_V_ID')
322: union
323: select pghn2.entity_id
324: from per_gen_hierarchy_nodes pghn,
325: per_gen_hierarchy_nodes pghn2
326: where pghn.entity_id = pay_magtape_generic.get_parameter_value('TRANSFER_ESTABLISHMENT_ID')
327: and pghn.hierarchy_version_id = pghn2.hierarchy_version_id
328: and pghn2.parent_hierarchy_node_id = pghn.hierarchy_node_id
329: and pghn2.node_type = 'LOC'

Line 366: from per_gen_hierarchy_nodes

362: AND ass.effective_end_date >=
363: to_date(pay_magtape_generic.get_parameter_value('TRANSFER_DATE_START'),'YYYY/MM/DD HH24:MI:SS')
364: AND ass.location_id IN
365: (select entity_id
366: from per_gen_hierarchy_nodes
367: where node_type = 'EST'
368: and entity_id = pay_magtape_generic.get_parameter_value('TRANSFER_ESTABLISHMENT_ID')
369: and hierarchy_version_id = pay_magtape_generic.get_parameter_value('TRANSFER_ORG_STR_V_ID')
370: union

Line 372: from per_gen_hierarchy_nodes pghn,

368: and entity_id = pay_magtape_generic.get_parameter_value('TRANSFER_ESTABLISHMENT_ID')
369: and hierarchy_version_id = pay_magtape_generic.get_parameter_value('TRANSFER_ORG_STR_V_ID')
370: union
371: select pghn2.entity_id
372: from per_gen_hierarchy_nodes pghn,
373: per_gen_hierarchy_nodes pghn2
374: where pghn.entity_id = pay_magtape_generic.get_parameter_value('TRANSFER_ESTABLISHMENT_ID')
375: and pghn.hierarchy_version_id = pghn2.hierarchy_version_id
376: and pghn2.parent_hierarchy_node_id = pghn.hierarchy_node_id

Line 373: per_gen_hierarchy_nodes pghn2

369: and hierarchy_version_id = pay_magtape_generic.get_parameter_value('TRANSFER_ORG_STR_V_ID')
370: union
371: select pghn2.entity_id
372: from per_gen_hierarchy_nodes pghn,
373: per_gen_hierarchy_nodes pghn2
374: where pghn.entity_id = pay_magtape_generic.get_parameter_value('TRANSFER_ESTABLISHMENT_ID')
375: and pghn.hierarchy_version_id = pghn2.hierarchy_version_id
376: and pghn2.parent_hierarchy_node_id = pghn.hierarchy_node_id
377: and pghn2.node_type = 'LOC'

Line 412: from per_gen_hierarchy_nodes

408: AND nvl(job.date_to,to_date('31/12/4712','DD/MM/YYYY')) >=
409: to_date(pay_magtape_generic.get_parameter_value('TRANSFER_DATE_START'),'YYYY/MM/DD HH24:MI:SS')
410: AND ass.location_id IN
411: (select entity_id
412: from per_gen_hierarchy_nodes
413: where node_type = 'EST'
414: and entity_id = pay_magtape_generic.get_parameter_value('TRANSFER_ESTABLISHMENT_ID')
415: and hierarchy_version_id = pay_magtape_generic.get_parameter_value('TRANSFER_ORG_STR_V_ID')
416: union

Line 418: from per_gen_hierarchy_nodes pghn,

414: and entity_id = pay_magtape_generic.get_parameter_value('TRANSFER_ESTABLISHMENT_ID')
415: and hierarchy_version_id = pay_magtape_generic.get_parameter_value('TRANSFER_ORG_STR_V_ID')
416: union
417: select pghn2.entity_id
418: from per_gen_hierarchy_nodes pghn,
419: per_gen_hierarchy_nodes pghn2
420: where pghn.entity_id = pay_magtape_generic.get_parameter_value('TRANSFER_ESTABLISHMENT_ID')
421: and pghn.hierarchy_version_id = pghn2.hierarchy_version_id
422: and pghn2.parent_hierarchy_node_id = pghn.hierarchy_node_id

Line 419: per_gen_hierarchy_nodes pghn2

415: and hierarchy_version_id = pay_magtape_generic.get_parameter_value('TRANSFER_ORG_STR_V_ID')
416: union
417: select pghn2.entity_id
418: from per_gen_hierarchy_nodes pghn,
419: per_gen_hierarchy_nodes pghn2
420: where pghn.entity_id = pay_magtape_generic.get_parameter_value('TRANSFER_ESTABLISHMENT_ID')
421: and pghn.hierarchy_version_id = pghn2.hierarchy_version_id
422: and pghn2.parent_hierarchy_node_id = pghn.hierarchy_node_id
423: and pghn2.node_type = 'LOC'