APPS.AMS_MKT_SEGMENTS_PVT dependencies on AMS_PARTY_MARKET_SEGMENTS

Line 11: FUNCTION Get_Mkt_Segments ( p_party_id ams_party_market_segments.party_id%TYPE := NULL ,

7: -- HISTORY
8: -- 10/14/99 abhola Create.
9: ---------------------------------------------------------------------
10:
11: FUNCTION Get_Mkt_Segments ( p_party_id ams_party_market_segments.party_id%TYPE := NULL ,
12: p_target_segment_id ams_party_market_segments.market_segment_id%TYPE := NULL)
13:
14: RETURN PartyMktSegTabTyp IS
15:

Line 12: p_target_segment_id ams_party_market_segments.market_segment_id%TYPE := NULL)

8: -- 10/14/99 abhola Create.
9: ---------------------------------------------------------------------
10:
11: FUNCTION Get_Mkt_Segments ( p_party_id ams_party_market_segments.party_id%TYPE := NULL ,
12: p_target_segment_id ams_party_market_segments.market_segment_id%TYPE := NULL)
13:
14: RETURN PartyMktSegTabTyp IS
15:
16: x_PartyMktSegTabTyp PartyMktSegTabTyp;

Line 19: CURSOR c_party (c_party_id IN ams_party_market_segments.party_id%TYPE)

15:
16: x_PartyMktSegTabTyp PartyMktSegTabTyp;
17: i BINARY_INTEGER := 0;
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

Line 23: ams_party_market_segments b

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'
27: AND a.arc_act_market_segment_used_by = 'CAMP';

Line 29: CURSOR c_target ( c_target_id IN ams_party_market_segments.market_segment_id%TYPE)

25: AND b.market_segment_id = a.market_segment_id
26: -- AND b.market_segment_flag = 'N'
27: AND a.arc_act_market_segment_used_by = 'CAMP';
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

Line 36: CURSOR c_party_target ( c_party_id IN ams_party_market_segments.party_id%TYPE,

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,
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,

Line 37: c_target_id IN ams_party_market_segments.market_segment_id%TYPE )

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,
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

Line 41: ams_party_market_segments b

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
45: -- AND b.market_segment_flag = 'N'