APPS.IBY_UPGRADE_PARAM_PVT dependencies on IBY_BEP_ACCT_OPT_VALS

Line 55: CURSOR c_acct_opt_exists(ci_bepid IBY_BEP_ACCT_OPT_VALS.BEPID%TYPE,

51: QUERY_TRANS_CONFIG_ID
52: FROM IBY_FNDCPT_USER_CC_PF_B
53: WHERE BEP_ACCOUNT_ID=ci_bep_account_id;
54:
55: CURSOR c_acct_opt_exists(ci_bepid IBY_BEP_ACCT_OPT_VALS.BEPID%TYPE,
56: ci_bep_account_id IBY_BEP_ACCT_OPT_VALS.BEP_ACCOUNT_ID%TYPE)
57: IS SELECT 1
58: FROM IBY_BEP_ACCT_OPT_VALS
59: WHERE BEPID=ci_bepid

Line 56: ci_bep_account_id IBY_BEP_ACCT_OPT_VALS.BEP_ACCOUNT_ID%TYPE)

52: FROM IBY_FNDCPT_USER_CC_PF_B
53: WHERE BEP_ACCOUNT_ID=ci_bep_account_id;
54:
55: CURSOR c_acct_opt_exists(ci_bepid IBY_BEP_ACCT_OPT_VALS.BEPID%TYPE,
56: ci_bep_account_id IBY_BEP_ACCT_OPT_VALS.BEP_ACCOUNT_ID%TYPE)
57: IS SELECT 1
58: FROM IBY_BEP_ACCT_OPT_VALS
59: WHERE BEPID=ci_bepid
60: AND BEP_ACCOUNT_ID=ci_bep_account_id;

Line 58: FROM IBY_BEP_ACCT_OPT_VALS

54:
55: CURSOR c_acct_opt_exists(ci_bepid IBY_BEP_ACCT_OPT_VALS.BEPID%TYPE,
56: ci_bep_account_id IBY_BEP_ACCT_OPT_VALS.BEP_ACCOUNT_ID%TYPE)
57: IS SELECT 1
58: FROM IBY_BEP_ACCT_OPT_VALS
59: WHERE BEPID=ci_bepid
60: AND BEP_ACCOUNT_ID=ci_bep_account_id;
61:
62: CURSOR c_trans_config_exists(

Line 106: INSERT INTO IBY_BEP_ACCT_OPT_VALS(

102:
103:
104: IF ((NOT (TRIM(p_merchant_account_names(i)) is null))) THEN
105:
106: INSERT INTO IBY_BEP_ACCT_OPT_VALS(
107: BEP_ACCOUNT_ID,
108: BEPID,
109: ACCOUNT_OPTION_CODE,
110: ACCOUNT_OPTION_VALUE,