APPS.IBE_ATP_PVT SQL Statements

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

Line: 46

           select site_use.site_use_id
           from hz_party_sites party_site,
                hz_cust_acct_sites_all acct_site,
                hz_cust_site_uses_all site_use
           where party_site.party_site_id = acct_site.party_site_id
           and   acct_site.cust_acct_site_id = site_use.cust_acct_site_id
           and   party_site.party_site_id = l_party_site_id;

Line: 224

              SELECT meaning
                INTO x_atp_line_tbl(j).error_message
                FROM fnd_lookup_values
                WHERE language = l_lang_code
                  AND view_application_id = 700
                  AND security_group_id =
                        fnd_global.lookup_security_group(lookup_type,
                                                         view_application_id)
                  AND lookup_type = 'MTL_DEMAND_INTERFACE_ERRORS'
                  AND TO_NUMBER(lookup_code) = l_atp_tbl(i).error_code;