APPS.HZ_EXTRACT_BO_UTIL_PVT SQL Statements

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

Line: 19

	 SELECT 'Y'
	 FROM HZ_BUS_OBJ_TRACKING
	 WHERE parent_bo_code is null
	 and event_id = p_event_id
	 and  child_entity_name = 'HZ_PARTIES'
	 and child_id  = nvl(p_party_id, child_id)
	 and child_bo_code = p_bo_code
	 and nvl(parent_event_flag, p_event_type) = p_event_type
	 and rownum = 1;

Line: 65

	select party_type
	from hz_parties
	where party_id = p_parent_id;

Line: 70

	select party_type
	from hz_parties p, hz_cust_accounts ca
	where p.party_id = ca.party_id
        and ca.cust_account_id = p_parent_id;

Line: 76

        select contact_point_type
        from HZ_CONTACT_POINTS
        where contact_point_id = p_parent_id;

Line: 129

		select user_name
		from fnd_user
		where user_id = p_user_id;

Line: 159

	 SELECT child_id
	 FROM HZ_BUS_OBJ_TRACKING
	 WHERE parent_bo_code is null
	 and event_id = p_event_id
	 and  child_entity_name = 'HZ_PARTIES';

Line: 293

    SELECT 'X'
    FROM HZ_CONTACT_POINTS
    WHERE contact_point_id = l_cp_id
    AND contact_point_type = l_cp_type;

Line: 299

    SELECT 'X'
    FROM HZ_ORG_CONTACTS
    WHERE org_contact_id = l_oc_id;

Line: 304

    SELECT 'X'
    FROM HZ_PARTIES
    WHERE party_id = l_pty_id
    AND party_type = l_pty_type
    AND status in ('A', 'I');

Line: 311

    SELECT 'X'
    FROM HZ_PARTY_SITES
    WHERE party_site_id = l_ps_id;

Line: 316

    SELECT 'X'
    FROM HZ_LOCATIONS
    WHERE location_id = l_loc_id;

Line: 321

    SELECT 'X'
    FROM HZ_CUST_ACCOUNT_ROLES
    WHERE cust_account_role_id = l_cr_id;

Line: 326

    SELECT 'X'
    FROM HZ_CUST_ACCOUNTS
    WHERE cust_account_id = l_ca_id;

Line: 331

    SELECT 'X'
    FROM HZ_CUST_ACCT_SITES
    WHERE cust_acct_site_id = l_cas_id;

Line: 336

    SELECT 'X'
    FROM HZ_CUST_SITE_USES
    WHERE site_use_id = l_casu_id;