APPS.IBY_FNDCPT_PROFILE_PVT dependencies on IBY_FNDCPT_USER_EFT_PF_B

Line 81: FROM iby_fndcpt_user_eft_pf_b prof, iby_bepkeys key

77: ELSIF (p_instr_type = 'BANKACCOUNT') THEN
78:
79: SELECT user_eft_profile_code
80: INTO x_profile_code
81: FROM iby_fndcpt_user_eft_pf_b prof, iby_bepkeys key
82: WHERE (prof.bep_account_id = key.bep_account_id)
83: AND (key.bepid = p_bepid)
84: AND (key.ownertype = 'PAYEE')
85: AND (key.ownerid = p_payeeid)

Line 333: (ci_profile_code iby_fndcpt_user_eft_pf_b.user_eft_profile_code%TYPE)

329: FROM iby_fndcpt_user_cc_pf_b
330: WHERE (user_cc_profile_code=ci_profile_code);
331:
332: CURSOR c_eft_user_prof
333: (ci_profile_code iby_fndcpt_user_eft_pf_b.user_eft_profile_code%TYPE)
334: IS
335: SELECT verify_trans_config_id, funds_xfer_trans_config_id,
336: query_trans_config_id
337: FROM iby_fndcpt_user_eft_pf_b

Line 337: FROM iby_fndcpt_user_eft_pf_b

333: (ci_profile_code iby_fndcpt_user_eft_pf_b.user_eft_profile_code%TYPE)
334: IS
335: SELECT verify_trans_config_id, funds_xfer_trans_config_id,
336: query_trans_config_id
337: FROM iby_fndcpt_user_eft_pf_b
338: WHERE (user_eft_profile_code=ci_profile_code);
339:
340: CURSOR c_dc_user_prof
341: (ci_profile_code iby_fndcpt_user_dc_pf_b.user_dc_profile_code%TYPE)

Line 383: FROM iby_fndcpt_user_eft_pf_b

379: Delete_Trans_Config(l_settle_cfg_id);
380: Delete_Trans_Config(l_query_cfg_id);
381:
382: DELETE
383: FROM iby_fndcpt_user_eft_pf_b
384: WHERE (user_eft_profile_code=p_eft_profile_code);
385: END IF;
386: CLOSE c_eft_user_prof;
387: