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_VETC_TAP dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 189: from per_org_structure_elements ose

185: --
186: -- Start with the GRE, head down to find the establishments,
187: (
188: select ose.organization_id_child
189: from per_org_structure_elements ose
190: where ose.org_structure_version_id +0 =
191: pay_magtape_generic.get_parameter_value('TRANSFER_ORG_STR_V_ID')
192: connect by prior ose.organization_id_child = ose.organization_id_parent
193: and ose.org_structure_version_id +0 =

Line 315: FROM per_org_structure_elements ose

311: to_number(pay_magtape_generic.get_parameter_value('TRANSFER_ESTABLISHMENT_ID'))
312: FROM dual
313: UNION
314: SELECT ose.organization_id_child
315: FROM per_org_structure_elements ose
316: WHERE ose.org_structure_version_id + 0 =
317: pay_magtape_generic.get_parameter_value('TRANSFER_ORG_STR_V_ID')
318: -- AND ose.organization_id_child = ass.organization_id
319: CONNECT BY PRIOR ose.organization_id_child =

Line 409: FROM per_org_structure_elements ose

405: to_number(pay_magtape_generic.get_parameter_value('TRANSFER_ESTABLISHMENT_ID'))
406: FROM dual
407: UNION
408: SELECT ose.organization_id_child
409: FROM per_org_structure_elements ose
410: WHERE ose.org_structure_version_id + 0 =
411: pay_magtape_generic.get_parameter_value('TRANSFER_ORG_STR_V_ID')
412: -- AND ose.organization_id_child = ass.organization_id
413: CONNECT BY PRIOR ose.organization_id_child =

Line 478: FROM per_org_structure_elements ose

474: to_number(pay_magtape_generic.get_parameter_value('TRANSFER_ESTABLISHMENT_ID'))
475: FROM dual
476: UNION
477: SELECT ose.organization_id_child
478: FROM per_org_structure_elements ose
479: WHERE ose.org_structure_version_id + 0 =
480: pay_magtape_generic.get_parameter_value('TRANSFER_ORG_STR_V_ID')
481: -- AND ose.organization_id_child = ass.organization_id
482: CONNECT BY PRIOR ose.organization_id_child =

Line 532: FROM per_org_structure_elements ose

528: 'TRANSFER_ESTABLISHMENT_ID'))
529: FROM dual
530: UNION
531: SELECT ose.organization_id_child
532: FROM per_org_structure_elements ose
533: WHERE ose.org_structure_version_id + 0 =
534: pay_magtape_generic.get_parameter_value('TRANSFER_ORG_STR_V_ID')
535: CONNECT BY PRIOR ose.organization_id_child =
536: ose.organization_id_parent