APPS.AMS_IMPORTCLIENT_PVT dependencies on AMS_LEAD_MAPPING_V

Line 282: -- Function Transfer data from the "ams_lead_mapping_v" to

278: -- Start of comments
279: -- API Name Load_Lead_Data_To_Interface
280: -- Type Private
281: -- Pre-reqs None.
282: -- Function Transfer data from the "ams_lead_mapping_v" to
283: -- the "as_import_interface" table.
284: -- Parameters
285: -- IN
286: -- p_import_list_header_id NUMBER Required

Line 622: FROM ams_lead_mapping_v

618: CATEGORY_ID_1, CATEGORY_ID_2, CATEGORY_ID_3, CATEGORY_ID_4,
619: CATEGORY_ID_5, SALES_METHODOLOGY_ID, DUNS_NUMBER_C,
620: SOURCE_SECONDARY_REFERENCE,
621: NOTE_TYPE
622: FROM ams_lead_mapping_v
623: WHERE import_list_header_id = p_list_header_id
624: AND load_status IN ('ACTIVE', 'RELOAD');
625: BEGIN
626: --

Line 1496: l_field_table_name VARCHAR2(30) := 'AMS_LEAD_MAPPING_V';

1492: l_num_col_names char_data_set_type_w;
1493: l_str_data char_data_set_type_w;
1494: l_num_data num_data_set_type_w;
1495: l_row_count NUMBER;
1496: l_field_table_name VARCHAR2(30) := 'AMS_LEAD_MAPPING_V';
1497: l_batch_id NUMBER;
1498:
1499: --06/16/2001 huili
1500: l_dup_flag VARCHAR2(1);