APPS.IBY_TUNNEL_CONFIG_UPG_PKG dependencies on IBY_FNDCPT_USER_DC_PF_B

Line 68: FROM iby_fndcpt_user_dc_pf_b p, iby_bepkeys k

64: UPDATE iby_transmit_configs_b
65: SET tunneling_trans_config_id=l_config_id
66: WHERE transmit_configuration_id IN
67: (SELECT online_deb_trans_config_id
68: FROM iby_fndcpt_user_dc_pf_b p, iby_bepkeys k
69: WHERE (p.bep_account_id = k.bep_account_id)
70: AND (k.bepid = bep_rec.bepid)
71: )
72: AND (tunneling_trans_config_id IS NULL);

Line 78: FROM iby_fndcpt_user_dc_pf_b p, iby_bepkeys k

74: UPDATE iby_transmit_configs_b
75: SET tunneling_trans_config_id=l_config_id
76: WHERE transmit_configuration_id IN
77: (SELECT settlement_trans_config_id
78: FROM iby_fndcpt_user_dc_pf_b p, iby_bepkeys k
79: WHERE (p.bep_account_id = k.bep_account_id)
80: AND (k.bepid = bep_rec.bepid)
81: )
82: AND (tunneling_trans_config_id IS NULL);

Line 88: FROM iby_fndcpt_user_dc_pf_b p, iby_bepkeys k

84: UPDATE iby_transmit_configs_b
85: SET tunneling_trans_config_id=l_config_id
86: WHERE transmit_configuration_id IN
87: (SELECT query_trans_config_id
88: FROM iby_fndcpt_user_dc_pf_b p, iby_bepkeys k
89: WHERE (p.bep_account_id = k.bep_account_id)
90: AND (k.bepid = bep_rec.bepid)
91: )
92: AND (tunneling_trans_config_id IS NULL);