APPS.ENG_CHANGE_LIFECYCLE_UTIL dependencies on PER_ORGANIZATION_STRUCTURES

Line 2039: l_hierarchy_name per_organization_structures.name%TYPE;

2035:
2036: --l_co_type_id eng_engineering_changes.CHANGE_ORDER_TYPE_ID%TYPE;
2037: l_auto_prop_flag eng_type_org_properties.AUTO_PROPAGATE_FLAG%TYPE;
2038: l_change_notice eng_engineering_changes.change_notice%TYPE;
2039: l_hierarchy_name per_organization_structures.name%TYPE;
2040: l_org_name org_organization_definitions.organization_name%TYPE;
2041: l_row_cnt NUMBER := 0;
2042:
2043: l_doc_lc_object_flag BOOLEAN := FALSE ;

Line 2053: per_organization_structures pos,

2049: pos.name,
2050: ood.name organization_name
2051: FROM eng_type_org_properties op,
2052: eng_engineering_changes ec,
2053: per_organization_structures pos,
2054: hr_all_organization_units_tl ood
2055: WHERE ec.change_id = p_change_id
2056: --AND ec.PLM_OR_ERP_CHANGE = 'PLM'
2057: AND op.change_type_id = ec.change_order_type_id

Line 6705: l_hierarchy_name per_organization_structures.name%TYPE;

6701:
6702: -- for auto-propagation if it's defined for first phase
6703: l_auto_prop_flag eng_type_org_properties.AUTO_PROPAGATE_FLAG%TYPE;
6704: l_change_notice eng_engineering_changes.change_notice%TYPE;
6705: l_hierarchy_name per_organization_structures.name%TYPE;
6706: l_org_name org_organization_definitions.organization_name%TYPE;
6707: l_row_cnt NUMBER := 0;
6708: CURSOR c_orgProp IS
6709: SELECT op.auto_propagate_flag,

Line 6715: per_organization_structures pos,

6711: pos.name,
6712: ood.name organization_name
6713: FROM eng_type_org_properties op,
6714: eng_engineering_changes ec,
6715: per_organization_structures pos,
6716: hr_all_organization_units_tl ood
6717: WHERE ec.change_id = p_change_id
6718: --AND ec.PLM_OR_ERP_CHANGE = 'PLM'
6719: AND op.change_type_id = ec.change_order_type_id