APPS.AMS_IMPORTCLIENT_PVT dependencies on AMS_LIST_SRC_FIELDS

Line 1517: FROM ams_list_src_fields A, ams_imp_list_headers_all b

1513: AND default_flag = 'Y';
1514:
1515: CURSOR c_list_fields (l_import_list_header_id NUMBER) IS
1516: SELECT A.field_column_name, B.batch_id
1517: FROM ams_list_src_fields A, ams_imp_list_headers_all b
1518: WHERE b.IMPORT_LIST_HEADER_ID = l_import_list_header_id
1519: AND b.LIST_SOURCE_TYPE_ID = A.LIST_SOURCE_TYPE_ID
1520: ORDER BY LIST_SOURCE_FIELD_ID;
1521:

Line 1796: FROM ams_list_src_fields A, ams_imp_list_headers_all b

1792: AND default_flag = 'Y';
1793:
1794: CURSOR c_list_fields (l_import_list_header_id NUMBER) IS
1795: SELECT A.field_column_name, A.FIELD_TABLE_NAME, B.BATCH_ID
1796: FROM ams_list_src_fields A, ams_imp_list_headers_all b
1797: WHERE b.IMPORT_LIST_HEADER_ID = l_import_list_header_id
1798: AND b.LIST_SOURCE_TYPE_ID = A.LIST_SOURCE_TYPE_ID
1799: ORDER BY LIST_SOURCE_FIELD_ID;
1800: