APPS.AMS_SCHEDULERULES_PVT dependencies on AMS_ACT_LISTS

Line 30: FROM ams_act_lists la

26: RETURN VARCHAR2
27: IS
28: CURSOR c_target_det
29: IS SELECT 1
30: FROM ams_act_lists la
31: WHERE list_act_type = 'TARGET'
32: AND list_used_by = p_obj_type --'CSCH'
33: AND list_used_by_id = p_schedule_id
34: AND EXISTS (SELECT *

Line 2427: -- created in the ams_act_lists table.

2423: -- target group screen to modify the details.
2424: --
2425: -- NOTE
2426: -- The list of Type Target is created in list header and the association is
2427: -- created in the ams_act_lists table.
2428: --
2429: -- HISTORY
2430: -- 18-May-2001 ptendulk Created.
2431: -- 18-Aug-2001 ptendulk Modified the Target group name

Line 2700: FROM ams_act_lists

2696: SELECT party_id
2697: FROM ams_list_entries
2698: WHERE list_header_id =
2699: (SELECT list_header_id
2700: FROM ams_act_lists
2701: WHERE list_used_by = 'CSCH'
2702: AND list_act_type = 'TARGET'
2703: AND list_used_by_id = p_schedule_id)
2704: AND enabled_flag = 'Y';

Line 2938: FROM ams_act_lists la

2934: -- on 19-mar-2002 for bug# 2263166
2935:
2936: CURSOR c_tgrp_det
2937: IS SELECT list_header_id
2938: FROM ams_act_lists la
2939: WHERE list_act_type = 'TARGET'
2940: AND list_used_by = 'CSCH'
2941: AND list_used_by_id = p_schedule_id
2942: AND EXISTS (SELECT *

Line 4013: FROM ams_act_lists la

4009: result OUT NOCOPY VARCHAR2) IS
4010:
4011: CURSOR c_tgrp_det(l_csch_id IN NUMBER) IS
4012: SELECT list_header_id
4013: FROM ams_act_lists la
4014: WHERE list_act_type = 'TARGET'
4015: AND list_used_by = 'CSCH'
4016: AND list_used_by_id = l_csch_id
4017: AND EXISTS (SELECT *

Line 4518: from ams_act_lists la, ams_list_entries le, hz_parties pa, hz_relationships rel

4514: select decode(pa.party_type,'PARTY_RELATIONSHIP','ORGANIZATION','PERSON') party_type,
4515: decode(pa.party_type,'PARTY_RELATIONSHIP',rel.subject_id,null) contact_party_id,
4516: decode(pa.party_type,'PARTY_RELATIONSHIP',TO_NUMBER(le.col147),le.party_id) main_party_id,
4517: decode(pa.party_type,'PARTY_RELATIONSHIP',le.party_id,null) rel_party_id
4518: from ams_act_lists la, ams_list_entries le, hz_parties pa, hz_relationships rel
4519: where la.list_header_id = le.list_header_id
4520: and la.list_act_type = 'TARGET'
4521: and la.list_used_by = 'CSCH'
4522: and la.list_used_by_id = p_obj_id