APPS.POS_HZ_PARTY_SITE_BO_TBL_PKG SQL Statements

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

Line: 83

        SELECT pos_hz_party_site_bo(NULL, -- COMMON_OBJ_ID
                                    ps.party_site_id,
                                    NULL, --PS.ORIG_SYSTEM,
                                    NULL, --PS.ORIG_SYSTEM_REFERENCE,
                                    hz_extract_bo_util_pvt.get_parent_object_type('HZ_PARTIES',
                                                                                  ps.party_id),
                                    ps.party_id,
                                    ps.party_site_number,
                                    ps.mailstop,
                                    ps.identifying_address_flag,
                                    ps.status,
                                    ps.party_site_name,
                                    ps.attribute_category,
                                    ps.attribute1,
                                    ps.attribute2,
                                    ps.attribute3,
                                    ps.attribute4,
                                    ps.attribute5,
                                    ps.attribute6,
                                    ps.attribute7,
                                    ps.attribute8,
                                    ps.attribute9,
                                    ps.attribute10,
                                    ps.attribute11,
                                    ps.attribute12,
                                    ps.attribute13,
                                    ps.attribute14,
                                    ps.attribute15,
                                    ps.attribute16,
                                    ps.attribute17,
                                    ps.attribute18,
                                    ps.attribute19,
                                    ps.attribute20,
                                    ps.language,
                                    ps.addressee,
                                    ps.program_update_date,
                                    ps.created_by_module,
                                    hz_extract_bo_util_pvt.get_user_name(ps.created_by),
                                    ps.creation_date,
                                    ps.last_update_date,
                                    hz_extract_bo_util_pvt.get_user_name(ps.last_updated_by),
                                    ps.actual_content_source,
                                    ps.global_location_number,
                                    pos_supplier_uda_bo_pkg.get_uda_for_supplier_site(p_party_id,
                                                                                      ps.party_site_id,
                                                                                      NULL,
                                                                                      'SUPP_ADDR_LEVEL')) BULK COLLECT
        INTO   x_party_site_objs
        FROM   hz_party_sites ps
        WHERE  party_id = p_party_id;