APPS.IBY_TUNNEL_CONFIG_UPG_PKG dependencies on IBY_FNDCPT_USER_CC_PF_B

Line 36: FROM iby_fndcpt_user_cc_pf_b p, iby_bepkeys k

32: UPDATE iby_transmit_configs_b
33: SET tunneling_trans_config_id=l_config_id
34: WHERE transmit_configuration_id IN
35: (SELECT online_auth_trans_config_id
36: FROM iby_fndcpt_user_cc_pf_b p, iby_bepkeys k
37: WHERE (p.bep_account_id = k.bep_account_id)
38: AND (k.bepid = bep_rec.bepid)
39: )
40: AND (tunneling_trans_config_id IS NULL);

Line 46: FROM iby_fndcpt_user_cc_pf_b p, iby_bepkeys k

42: UPDATE iby_transmit_configs_b
43: SET tunneling_trans_config_id=l_config_id
44: WHERE transmit_configuration_id IN
45: (SELECT settlement_trans_config_id
46: FROM iby_fndcpt_user_cc_pf_b p, iby_bepkeys k
47: WHERE (p.bep_account_id = k.bep_account_id)
48: AND (k.bepid = bep_rec.bepid)
49: )
50: AND (tunneling_trans_config_id IS NULL);

Line 56: FROM iby_fndcpt_user_cc_pf_b p, iby_bepkeys k

52: UPDATE iby_transmit_configs_b
53: SET tunneling_trans_config_id=l_config_id
54: WHERE transmit_configuration_id IN
55: (SELECT query_trans_config_id
56: FROM iby_fndcpt_user_cc_pf_b p, iby_bepkeys k
57: WHERE (p.bep_account_id = k.bep_account_id)
58: AND (k.bepid = bep_rec.bepid)
59: )
60: AND (tunneling_trans_config_id IS NULL);