APPS.ENG_CHANGE_LIFECYCLE_UTIL dependencies on PER_ORGANIZATION_STRUCTURES

Line 2013: l_hierarchy_name per_organization_structures.name%TYPE;

2009:
2010: --l_co_type_id eng_engineering_changes.CHANGE_ORDER_TYPE_ID%TYPE;
2011: l_auto_prop_flag eng_type_org_properties.AUTO_PROPAGATE_FLAG%TYPE;
2012: l_change_notice eng_engineering_changes.change_notice%TYPE;
2013: l_hierarchy_name per_organization_structures.name%TYPE;
2014: l_org_name org_organization_definitions.organization_name%TYPE;
2015: l_row_cnt NUMBER := 0;
2016:
2017: l_doc_lc_object_flag BOOLEAN := FALSE ;

Line 2027: per_organization_structures pos,

2023: pos.name,
2024: ood.name organization_name
2025: FROM eng_type_org_properties op,
2026: eng_engineering_changes ec,
2027: per_organization_structures pos,
2028: hr_all_organization_units_tl ood
2029: WHERE ec.change_id = p_change_id
2030: --AND ec.PLM_OR_ERP_CHANGE = 'PLM'
2031: AND op.change_type_id = ec.change_order_type_id

Line 6535: l_hierarchy_name per_organization_structures.name%TYPE;

6531:
6532: -- for auto-propagation if it's defined for first phase
6533: l_auto_prop_flag eng_type_org_properties.AUTO_PROPAGATE_FLAG%TYPE;
6534: l_change_notice eng_engineering_changes.change_notice%TYPE;
6535: l_hierarchy_name per_organization_structures.name%TYPE;
6536: l_org_name org_organization_definitions.organization_name%TYPE;
6537: l_row_cnt NUMBER := 0;
6538: CURSOR c_orgProp IS
6539: SELECT op.auto_propagate_flag,

Line 6545: per_organization_structures pos,

6541: pos.name,
6542: ood.name organization_name
6543: FROM eng_type_org_properties op,
6544: eng_engineering_changes ec,
6545: per_organization_structures pos,
6546: hr_all_organization_units_tl ood
6547: WHERE ec.change_id = p_change_id
6548: --AND ec.PLM_OR_ERP_CHANGE = 'PLM'
6549: AND op.change_type_id = ec.change_order_type_id