APPS.HRFASTANSWERS dependencies on PER_ORGANIZATION_STRUCTURES

Line 103: from per_organization_structures ost

99: ( cp_bus_id Number
100: , cp_str_id Number )
101: is
102: select ost.organization_structure_id
103: from per_organization_structures ost
104: where ost.organization_structure_id = cp_str_id
105: and ost.business_group_id = cp_bus_id;
106:
107: cursor c_sp_bureau

Line 137: from per_organization_structures ost

133: cursor c_primary
134: ( cp_bus_id Number )
135: is
136: select ost.organization_structure_id
137: from per_organization_structures ost
138: where ost.business_group_id = cp_bus_id
139: and ost.primary_structure_flag = 'Y';
140:
141: l_all_org Varchar2(80);

Line 1139: from per_organization_structures ost

1135: ( cp_bus_id Number
1136: , cp_str_id Number )
1137: is
1138: select ose.org_structure_element_id
1139: from per_organization_structures ost
1140: , per_org_structure_versions osv
1141: , per_org_structure_elements ose
1142: where ost.business_group_id = cp_bus_id
1143: and ost.organization_structure_id = cp_str_id

Line 1192: from per_organization_structures ost

1188: ( cp_bus_id Number
1189: , cp_str_id Number )
1190: is
1191: select osv.org_structure_version_id
1192: from per_organization_structures ost
1193: , per_org_structure_versions osv
1194: where ost.business_group_id = cp_bus_id
1195: and ost.organization_structure_id = cp_str_id
1196: and ost.organization_structure_id = osv.organization_structure_id

Line 1242: from per_organization_structures s

1238: ( cp_bus_id Number
1239: , cp_str_id Number )
1240: is
1241: select v.org_structure_version_id
1242: from per_organization_structures s
1243: , per_org_structure_versions v
1244: where s.business_group_id = cp_bus_id
1245: and s.organization_structure_id = cp_str_id
1246: and s.organization_structure_id = v.organization_structure_id