DBA Data[Home] [Help]

APPS.IBY_TUNNEL_CONFIG_UPG_PKG dependencies on IBY_FNDCPT_USER_EFT_PF_B

Line 100: FROM iby_fndcpt_user_eft_pf_b p, iby_bepkeys k

96: UPDATE iby_transmit_configs_b
97: SET tunneling_trans_config_id=l_config_id
98: WHERE transmit_configuration_id IN
99: (SELECT verify_trans_config_id
100: FROM iby_fndcpt_user_eft_pf_b p, iby_bepkeys k
101: WHERE (p.bep_account_id = k.bep_account_id)
102: AND (k.bepid = bep_rec.bepid)
103: )
104: AND (tunneling_trans_config_id IS NULL);

Line 110: FROM iby_fndcpt_user_eft_pf_b p, iby_bepkeys k

106: UPDATE iby_transmit_configs_b
107: SET tunneling_trans_config_id=l_config_id
108: WHERE transmit_configuration_id IN
109: (SELECT funds_xfer_trans_config_id
110: FROM iby_fndcpt_user_eft_pf_b p, iby_bepkeys k
111: WHERE (p.bep_account_id = k.bep_account_id)
112: AND (k.bepid = bep_rec.bepid)
113: )
114: AND (tunneling_trans_config_id IS NULL);

Line 120: FROM iby_fndcpt_user_eft_pf_b p, iby_bepkeys k

116: UPDATE iby_transmit_configs_b
117: SET tunneling_trans_config_id=l_config_id
118: WHERE transmit_configuration_id IN
119: (SELECT query_trans_config_id
120: FROM iby_fndcpt_user_eft_pf_b p, iby_bepkeys k
121: WHERE (p.bep_account_id = k.bep_account_id)
122: AND (k.bepid = bep_rec.bepid)
123: )
124: AND (tunneling_trans_config_id IS NULL);