APPS.AMS_MKT_SEGMENTS_PVT dependencies on AMS_ACT_MARKET_SEGMENTS

Line 22: FROM ams_act_market_segments a,

18:
19: CURSOR c_party (c_party_id IN ams_party_market_segments.party_id%TYPE)
20: IS
21: SELECT a.market_segment_id, a.act_market_segment_used_by_id
22: FROM ams_act_market_segments a,
23: ams_party_market_segments b
24: WHERE b.party_id = c_party_id
25: AND b.market_segment_id = a.market_segment_id
26: -- AND b.market_segment_flag = 'N'

Line 32: FROM ams_act_market_segments a

28:
29: CURSOR c_target ( c_target_id IN ams_party_market_segments.market_segment_id%TYPE)
30: IS
31: SELECT a.market_segment_id, a.act_market_segment_used_by_id
32: FROM ams_act_market_segments a
33: WHERE a.market_segment_id = c_target_id
34: AND a.arc_act_market_segment_used_by = 'CAMP';
35:
36: CURSOR c_party_target ( c_party_id IN ams_party_market_segments.party_id%TYPE,

Line 40: FROM ams_act_market_segments a,

36: CURSOR c_party_target ( c_party_id IN ams_party_market_segments.party_id%TYPE,
37: c_target_id IN ams_party_market_segments.market_segment_id%TYPE )
38: IS
39: SELECT a.market_segment_id, a.act_market_segment_used_by_id
40: FROM ams_act_market_segments a,
41: ams_party_market_segments b
42: WHERE b.party_id = c_party_id
43: AND b.market_segment_id = c_target_id
44: AND b.market_segment_id = a.market_segment_id