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 2415: -- created in the ams_act_lists table.

2411: -- target group screen to modify the details.
2412: --
2413: -- NOTE
2414: -- The list of Type Target is created in list header and the association is
2415: -- created in the ams_act_lists table.
2416: --
2417: -- HISTORY
2418: -- 18-May-2001 ptendulk Created.
2419: -- 18-Aug-2001 ptendulk Modified the Target group name

Line 2688: FROM ams_act_lists

2684: SELECT party_id
2685: FROM ams_list_entries
2686: WHERE list_header_id =
2687: (SELECT list_header_id
2688: FROM ams_act_lists
2689: WHERE list_used_by = 'CSCH'
2690: AND list_act_type = 'TARGET'
2691: AND list_used_by_id = p_schedule_id)
2692: AND enabled_flag = 'Y';

Line 2926: FROM ams_act_lists la

2922: -- on 19-mar-2002 for bug# 2263166
2923:
2924: CURSOR c_tgrp_det
2925: IS SELECT list_header_id
2926: FROM ams_act_lists la
2927: WHERE list_act_type = 'TARGET'
2928: AND list_used_by = 'CSCH'
2929: AND list_used_by_id = p_schedule_id
2930: AND EXISTS (SELECT *

Line 3983: FROM ams_act_lists la

3979: result OUT NOCOPY VARCHAR2) IS
3980:
3981: CURSOR c_tgrp_det(l_csch_id IN NUMBER) IS
3982: SELECT list_header_id
3983: FROM ams_act_lists la
3984: WHERE list_act_type = 'TARGET'
3985: AND list_used_by = 'CSCH'
3986: AND list_used_by_id = l_csch_id
3987: AND EXISTS (SELECT *

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

4484: select decode(pa.party_type,'PARTY_RELATIONSHIP','ORGANIZATION','PERSON') party_type,
4485: decode(pa.party_type,'PARTY_RELATIONSHIP',rel.subject_id,null) contact_party_id,
4486: decode(pa.party_type,'PARTY_RELATIONSHIP',TO_NUMBER(le.col147),le.party_id) main_party_id,
4487: decode(pa.party_type,'PARTY_RELATIONSHIP',le.party_id,null) rel_party_id
4488: from ams_act_lists la, ams_list_entries le, hz_parties pa, hz_relationships rel
4489: where la.list_header_id = le.list_header_id
4490: and la.list_act_type = 'TARGET'
4491: and la.list_used_by = 'CSCH'
4492: and la.list_used_by_id = p_obj_id