DBA Data[Home] [Help]

APPS.AML_FIND_PARTY_MATCH_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 28

    SELECT party_id
    INTO   l_party_id
    FROM   hz_parties hzp
    WHERE  hzp.party_name = imp.customer_name;
Line: 35

    UPDATE as_import_interface
       SET party_id = l_party_id
     WHERE import_interface_id = imp.import_interface_id;