DBA Data[Home] [Help]

APPS.AMS_ACT_LIST_PVT dependencies on AMS_LIST_CONT_RESTRICTIONS

Line 2168: FROM ams_list_cont_restrictions acr,

2164: --tied to the same datasource as the TG, and
2165: --the status in AVAILABLE or LOCKED
2166: CURSOR c_get_list(l_source_type VARCHAR2, l_media_id NUMBER) is
2167: SELECT acr.list_header_id
2168: FROM ams_list_cont_restrictions acr,
2169: ams_list_headers_all alh
2170: WHERE acr.list_header_id = alh.list_header_id
2171: AND alh.status_code in ('AVAILABLE','LOCKED')
2172: AND alh.list_source_type = l_source_type