DBA Data[Home] [Help]

APPS.POS_ORG_HASH_PKG SQL Statements

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

Line: 11

	SELECT 1
	  FROM hr_operating_units
	  WHERE organization_id = p_org_id;
Line: 16

     SELECT hashkey
       FROM pos_org_hash
       WHERE org_id = p_org_id;
Line: 37

      INSERT INTO pos_org_hash(org_id, hashkey) VALUES (p_org_id, l_hashkey);
Line: 52

  SELECT org_id
  FROM   pos_org_hash
  WHERE  hashkey = p_hashkey;