APPS.IBY_PMTSCHEMES_PKG SQL Statements

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

Line: 21

SELECT lookup_code
FROM fnd_lookups
WHERE lookup_type = 'IBY_PMTSCHEMES'
AND meaning = ci_pmtschemename;

Line: 87

SELECT pmtschemename
FROM iby_pmtschemes
WHERE bepid = i_bepid;

Line: 142

	DELETE FROM iby_pmtschemes
	WHERE bepid = i_bepid;

Line: 149

		-- insertion
		INSERT INTO iby_pmtschemes
			(bepid, pmtschemeid, pmtschemename,
			last_update_date, last_updated_by, creation_date,
			created_by, last_update_login, object_version_number)
		VALUES (i_bepid, l_pmtschemeid, i_pmtschemename(l_count),
			 sysdate, fnd_global.user_id,  sysdate,
			fnd_global.user_id, fnd_global.login_id, 1);