APPS.AMS_SCHEDULERULES_PVT dependencies on AMS_LIST_ENTRIES

Line 35: FROM ams_list_entries le

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 *
35: FROM ams_list_entries le
36: WHERE le.list_header_id = la.list_header_id) ;
37: l_dummy NUMBER ;
38: BEGIN
39: OPEN c_target_det ;

Line 2685: FROM ams_list_entries

2681: -- get the party_id for those list entries
2682:
2683: CURSOR c_parties_det IS
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'

Line 2931: FROM ams_list_entries le

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 *
2931: FROM ams_list_entries le
2932: WHERE le.list_header_id = la.list_header_id) ;
2933: */
2934:
2935: l_return_status VARCHAR2(1);

Line 3988: FROM ams_list_entries le

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 *
3988: FROM ams_list_entries le
3989: WHERE le.list_header_id = la.list_header_id) ;
3990:
3991: -- soagrawa added the following cursor on 30-sep-2003 for stamping version
3992: CURSOR c_cover_letter_det (l_csch_id IN NUMBER) IS

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