APPS.OZF_SD_REQUEST_PUB dependencies on AMS_PARTY_MARKET_SEGMENTS

Line 2295: FROM ams_party_market_segments ams

2291: WHERE request_customer_id = p_request_customer_id;
2292:
2293: CURSOR c_buying_group(p_party_id IN NUMBER)IS
2294: SELECT party_id
2295: FROM ams_party_market_segments ams
2296: WHERE ams.market_qualifier_type = 'BG'
2297: AND ams.market_qualifier_reference = ams.party_id
2298: AND EXISTS
2299: (SELECT 1

Line 2300: FROM ams_party_market_segments

2296: WHERE ams.market_qualifier_type = 'BG'
2297: AND ams.market_qualifier_reference = ams.party_id
2298: AND EXISTS
2299: (SELECT 1
2300: FROM ams_party_market_segments
2301: WHERE market_qualifier_type = 'BG'
2302: AND market_qualifier_reference = ams.market_qualifier_reference
2303: AND market_qualifier_reference <> party_id)
2304: AND party_id = p_party_id;