APPS.MST_WB_UTIL dependencies on WSH_LOCATION_OWNERS

Line 561: FROM wsh_location_owners wlo

557: WHERE HZP.PARTY_ID = P_party_id;
558:
559: CURSOR chk_owner_info(p_location_id IN NUMBER) IS
560: SELECT wlo.OWNER_TYPE, wlo.OWNER_PARTY_ID
561: FROM wsh_location_owners wlo
562: WHERE wlo.wsh_location_id = p_location_id;
563:
564: CURSOR chk_cust_site(p_location_id IN NUMBER, p_owner_party_id IN NUMBER) IS
565: SELECT 1

Line 1007: FROM wsh_location_owners wlo

1003: -- SQL repository issues as on 25-05-04:
1004: -- Rewritten sql to avoid ORDER BY clause
1005: CURSOR get_owner(p_owner_type IN Number) IS
1006: SELECT wlo.owner_party_id, wlo.owner_type
1007: FROM wsh_location_owners wlo
1008: WHERE wlo.wsh_location_id =
1009: (SELECT flp.location_id
1010: FROM fte_location_parameters flp
1011: WHERE flp.facility_id = p_facility_ID )

Line 1015: FROM wsh_location_owners wlo,

1011: WHERE flp.facility_id = p_facility_ID )
1012: AND Wlo.owner_type = p_owner_type;
1013: /*CURSOR get_owner IS
1014: SELECT wlo.owner_party_id, wlo.owner_type
1015: FROM wsh_location_owners wlo,
1016: fte_location_parameters flp
1017: WHERE wlo.wsh_location_id = flp.location_id
1018: AND flp.facility_id = p_facility_ID
1019: ORDER BY wlo.owner_type;*/

Line 2467: FROM wsh_location_owners wlo

2463:
2464: BEGIN
2465: SELECT wlo.OWNER_PARTY_ID
2466: INTO l_owner_party_id
2467: FROM wsh_location_owners wlo
2468: WHERE wlo.wsh_location_id = P_Location_id
2469: AND wlo.owner_type = P_Owner_Type;
2470: IF P_Owner_Type = 1 THEN
2471: l_Name := fnd_profile.value('MST_COMPANY_NAME');