DBA Data[Home] [Help]

APPS.OZF_FUNDS_PUB dependencies on AMS_LIST_HEADERS_ALL

Line 1461: FROM ams_list_headers_all list, ams_list_headers_all_tl tl

1457: AND oito.organization_id = p_segment_id;
1458:
1459: CURSOR c_segment_list (p_segment_id IN NUMBER) IS
1460: SELECT 1
1461: FROM ams_list_headers_all list, ams_list_headers_all_tl tl
1462: WHERE list.list_header_id = tl.list_header_id
1463: AND userenv('LANG') = language
1464: AND status_code in ( 'AVAILABLE','LOCKED','EXECUTED','EXECUTING','VALIDATED','VALIDATING')
1465: AND list.list_header_id = p_segment_id;