APPS.IBY_BEPKEYS_PKG SQL Statements

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

Line: 45

select ownerid, name
from iby_bepkeys a, iby_bepinfo b
where a.key = ci_bepkey
and a.ownertype = ci_ownertype
and a.bepid = ci_bepid
AND a.bepid = b.bepid;

Line: 71

** Precedure: deleteBEPKeys
** Purpose: delete ALL bepkeys associated with a payee
**
**
*/
procedure deleteBEPKeys(i_ownerid in iby_bepkeys.ownerid%type,
			i_ownertype in iby_bepkeys.ownertype%type)
is
begin
	DELETE FROM iby_bepkeys
	WHERE ownerid = i_ownerid
	AND ownertype = i_ownertype;

Line: 83

end deleteBEPKeys;

Line: 121

    SELECT iby_bepkeys_s.NEXTVAL
    INTO l_bep_account_id
    FROM dual;

Line: 126

        INSERT INTO iby_bepkeys ( bep_account_id, bepid, ownertype,
                                ownerid, key, defaults,
				last_update_date, last_updated_by,
				creation_date, created_by,
				last_update_login, object_version_number)
        VALUES ( l_bep_account_id, l_bepid, i_ownertype,
                 i_ownerid, i_key, i_default,
		 sysdate, fnd_global.user_id,
		 sysdate, fnd_global.user_id,
		fnd_global.login_id, 1);