DBA Data[Home] [Help]

APPS.INV_MGD_PRD_CONTROL_MEDIATOR dependencies on PER_ORGANIZATION_STRUCTURES

Line 1089: FROM per_organization_structures

1085: IF l_property_flag = 'N' THEN
1086: -- get hierarchy name
1087: SELECT name
1088: INTO l_hierarchy_name
1089: FROM per_organization_structures
1090: WHERE organization_structure_id = p_org_hierarchy_id;
1091:
1092: -- get the hierarchy property text
1093: SELECT meaning

Line 1124: FROM per_organization_structures

1120: IF l_property_flag = 'N' THEN
1121: -- get hierarchy name
1122: SELECT name
1123: INTO l_hierarchy_name
1124: FROM per_organization_structures
1125: WHERE organization_structure_id = p_org_hierarchy_id;
1126:
1127: -- get the hierarchy property text
1128: SELECT meaning