APPS.CS_SYSTEMS_COMMON_PUB SQL Statements

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

Line: 7

       SELECT customer_id INTO l_cust_id FROM FND_USER WHERE user_id =
       p_user_id;

Line: 16

       SELECT system_id INTO l_system_id FROM CS_SYSTEMS_ALL_VL WHERE name=p_system_name;

Line: 65

         SELECT system_id INTO l_result FROM cs_systems_all_vl WHERE system_id=l_system_id AND (end_date_active IS null OR (end_date_active > l_curr_date));

Line: 69

         SELECT system_id INTO l_result FROM cs_systems_all_vl WHERE system_id=p_system_id AND (end_date_active IS null OR (end_date_active > l_curr_date));

Line: 191

      open x_system_data for SELECT DISTINCT system_id, name FROM cs_system_party_links_v WHERE party_id = l_party_id AND (end_date_active IS null OR (end_date_active > l_curr_date)) ORDER BY system_id;

Line: 221

         open x_system_data for SELECT distinct system_id, name FROM cs_systems_all_vl WHERE parent_system_id = l_system_id ORDER BY system_id;

Line: 225

        open x_system_data for SELECT distinct system_id, name FROM cs_systems_all_vl WHERE parent_system_id = p_system_id ORDER BY system_id;

Line: 267

        SELECT count(*) INTO l_system_count FROM cs_system_party_links_v WHERE system_id = l_system_id AND party_id = l_party_id and (end_date is null or end_date < l_curr_date);

Line: 271

        SELECT count(*) INTO l_system_count FROM cs_system_party_links_v WHERE system_id = p_system_id AND party_id = l_party_id and (end_date is null or end_date < l_curr_date);

Line: 310

        SELECT count(*) INTO l_system_count FROM cs_system_party_links_v WHERE system_id = l_system_id  and (end_date is null or end_date < l_curr_date);

Line: 318

        SELECT count(*) INTO l_system_count FROM cs_system_party_links_v WHERE system_id = p_system_id and (end_date is null or end_date < l_curr_date);

Line: 358

        SELECT count(*) INTO l_system_count FROM
	   cs_systems_all_b a, hz_cust_accounts b,
	   hz_parties c, fnd_user d
        WHERE a.system_id=l_system_id AND
        a.customer_id=b.cust_account_id AND
        b.party_id=c.party_id AND
        c.party_type='PERSON' AND
        c.party_id=d.customer_id;

Line: 374

        SELECT count(*) INTO l_system_count FROM
        cs_systems_all_b a, hz_cust_accounts b,
        hz_parties c, fnd_user d
        WHERE a.system_id=p_system_id AND
        a.customer_id=b.cust_account_id AND
        b.party_id=c.party_id AND
        c.party_type='PERSON' AND
        c.party_id=d.customer_id;