DBA Data[Home] [Help]

APPS.AMS_SCHEDULERULES_PVT dependencies on AMS_LIST_HEADERS_ALL

Line 679: FROM ams_list_headers_all

675: WHERE schedule_id = p_schedule_rec.schedule_id;
676:
677: CURSOR c_list_header IS
678: SELECT 1
679: FROM ams_list_headers_all
680: WHERE arc_list_used_by = 'CSCH'
681: AND list_used_by_id = p_schedule_rec.schedule_id
682: AND status_code <> 'NEW';
683:

Line 839: FROM ams_list_headers_all

835: WHERE schedule_id = p_schedule_rec.schedule_id;
836:
837: CURSOR c_list_header IS
838: SELECT 1
839: FROM ams_list_headers_all
840: WHERE arc_list_used_by = 'CSCH'
841: AND list_used_by_id = p_schedule_rec.schedule_id
842: AND status_code <> 'NEW';
843:

Line 1528: FROM ams_list_headers_all

1524: IS
1525:
1526: CURSOR c_list_details IS
1527: SELECT object_version_number
1528: FROM ams_list_headers_all
1529: WHERE list_header_id = p_list_header_id ;
1530:
1531: -- g_pkg_name CONSTANT VARCHAR2(30) := 'NONE';
1532: