APPS.PER_OPL_ORGH dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 43: (business_group_id PER_org_structure_elements.business_group_id%TYPE

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

Line 44: ,organization_id PER_org_structure_elements.organization_id_parent%TYPE

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

Line 252: PER_org_structure_elements ose

248: ose.organization_id_child
249: ,ose.organization_id_parent
250: ,NVL(ose.last_update_date, g_start_of_time) last_update_date
251: FROM
252: PER_org_structure_elements ose
253: WHERE ose.org_structure_version_id = g_fetch_osv_id(p_index)) hier
254: START WITH hier.organization_id_parent = g_fetch_top_org_id(p_index)
255: CONNECT BY PRIOR hier.organization_id_child = organization_id_parent;
256: /******************************/

Line 352: PER_org_structure_elements ose

348: ,osv.date_from
349: ,NVL(osv.date_to,g_end_of_time)
350: ,osv.business_group_id
351: FROM
352: PER_org_structure_elements ose
353: ,PER_org_structure_versions osv
354: ,PER_organization_structures ost
355: WHERE osv.org_structure_version_id = ose.org_structure_version_id
356: AND ost.organization_structure_id = osv.organization_structure_id

Line 366: FROM PER_org_structure_elements ose2

362: or ose.business_group_id is null)
363: -- AND ost.primary_structure_flag = 'Y'
364: AND NOT EXISTS
365: (SELECT NULL
366: FROM PER_org_structure_elements ose2
367: WHERE ose2.org_structure_version_id = ose.org_structure_version_id
368: AND ose2.organization_id_child = ose.organization_id_parent);
369:
370: l_return_code PLS_INTEGER;