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 2697: FROM ams_list_entries

2693: -- get the party_id for those list entries
2694:
2695: CURSOR c_parties_det IS
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'

Line 2943: FROM ams_list_entries le

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 *
2943: FROM ams_list_entries le
2944: WHERE le.list_header_id = la.list_header_id) ;
2945: */
2946:
2947: l_return_status VARCHAR2(1);

Line 4018: FROM ams_list_entries le

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 *
4018: FROM ams_list_entries le
4019: WHERE le.list_header_id = la.list_header_id) ;
4020:
4021: -- soagrawa added the following cursor on 30-sep-2003 for stamping version
4022: CURSOR c_cover_letter_det (l_csch_id IN NUMBER) IS

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