APPS.CSM_CSP_REQ_HEADERS_EVENT_PKG SQL Statements

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

Line: 25

SELECT cas.party_site_id,hrl.org_id,b_user_id
FROM po_location_associations_all hrl, HZ_CUST_ACCT_SITES_ALL cas
    ,CSP_REQUIREMENT_HEADERS rh
WHERE REQUIREMENT_HEADER_ID=b_rhId AND hrl.location_id=rh.ship_to_location_id
and hrl.address_id=cas.cust_acct_site_id AND hrl.org_id=cas.org_id
AND NOT EXISTS(SELECT 1 FROM CSM_PARTY_SITES_ACC acc
               WHERE acc.party_site_id=cas.party_site_id
			   AND acc.user_id=b_user_id);

Line: 46

   CSM_ACC_PKG.Insert_Acc
     ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
      ,P_ACC_TABLE_NAME         => g_acc_table_name1
      ,P_SEQ_NAME               => g_acc_sequence_name1
      ,P_PK1_NAME               => g_pk1_name1
      ,P_PK1_NUM_VALUE          => p_requirement_header_id
      ,P_USER_ID                => p_user_id
     );

Line: 94

   CSM_ACC_PKG.Delete_Acc
     ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
      ,P_ACC_TABLE_NAME         => g_acc_table_name1
      ,P_PK1_NAME               => g_pk1_name1
      ,P_PK1_NUM_VALUE          => p_requirement_header_id
      ,P_USER_ID                => p_user_id
     );

Line: 135

       CSM_ACC_PKG.Update_Acc
          ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
           ,P_ACC_TABLE_NAME         => g_acc_table_name1
           ,P_ACCESS_ID              => l_access_id
           ,P_USER_ID                => p_user_id
          );