DBA Data[Home] [Help]

APPS.AMS_FULFILL_PVT dependencies on AMS_LIST_HEADERS_ALL

Line 440: FROM ams_list_headers_all

436:
437: --anchaudh added for R12
438: CURSOR c_bypass_flag IS
439: SELECT APPLY_SUPPRESSION_FLAG
440: FROM ams_list_headers_all
441: WHERE arc_list_used_by = 'CSCH'
442: AND list_used_by_id = p_schedule_id;
443:
444: l_subject VARCHAR2(1000) ;

Line 776: FROM ams_list_headers_all

772: IS
773:
774: CURSOR c_list_details IS
775: SELECT object_version_number
776: FROM ams_list_headers_all
777: WHERE list_header_id = p_list_header_id ;
778:
779:
780: l_list_rec AMS_LISTHEADER_PVT.list_header_rec_type;

Line 1912: FROM ams_list_headers_all

1908: -- to change submit_batch_request to submit_mass_request
1909: CURSOR c_list_hdr_det IS
1910: SELECT list_used_by_id,
1911: arc_list_used_by
1912: FROM ams_list_headers_all
1913: WHERE list_header_id = p_list_header_id ;
1914: l_list_hdr_rec c_list_hdr_det%ROWTYPE ;
1915:
1916: -- Following code is added by ptendulk on 8th Mar