APPS.HRI_OPL_ORGH_CT dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 39: (business_group_id per_org_structure_elements.business_group_id%TYPE

35: /******************************************************************************/
36:
37: /* Information to be held for each link in a chain */
38: TYPE g_link_record_type IS RECORD
39: (business_group_id per_org_structure_elements.business_group_id%TYPE
40: ,organization_id per_org_structure_elements.organization_id_parent%TYPE
41: ,last_chng_date DATE);
42:
43: /* Table type to hold information about the current chain */

Line 40: ,organization_id per_org_structure_elements.organization_id_parent%TYPE

36:
37: /* Information to be held for each link in a chain */
38: TYPE g_link_record_type IS RECORD
39: (business_group_id per_org_structure_elements.business_group_id%TYPE
40: ,organization_id per_org_structure_elements.organization_id_parent%TYPE
41: ,last_chng_date DATE);
42:
43: /* Table type to hold information about the current chain */
44: TYPE g_chain_type IS TABLE OF g_link_record_type INDEX BY BINARY_INTEGER;

Line 315: per_org_structure_elements ose

311: ose.organization_id_child
312: ,ose.organization_id_parent
313: ,NVL(ose.last_update_date, g_start_of_time) last_update_date
314: FROM
315: per_org_structure_elements ose
316: WHERE ose.org_structure_version_id = p_osv_id) hier
317: START WITH hier.organization_id_parent = p_top_org_id
318: CONNECT BY PRIOR hier.organization_id_child = organization_id_parent;
319: /******************************/

Line 482: per_org_structure_elements ose

478: ,osv.date_from start_date
479: ,NVL(osv.date_to,g_end_of_time) end_date
480: ,osv.business_group_id bgr_id
481: FROM
482: per_org_structure_elements ose
483: ,per_org_structure_versions osv
484: ,per_organization_structures ost
485: WHERE osv.org_structure_version_id = ose.org_structure_version_id
486: AND ost.organization_structure_id = osv.organization_structure_id

Line 490: FROM per_org_structure_elements ose2

486: AND ost.organization_structure_id = osv.organization_structure_id
487: AND osv.org_structure_version_id = v_version_id
488: AND NOT EXISTS
489: (SELECT NULL
490: FROM per_org_structure_elements ose2
491: WHERE ose2.org_structure_version_id = ose.org_structure_version_id
492: AND ose2.organization_id_child = ose.organization_id_parent);
493:
494: l_profile_structure NUMBER;