APPS.IBY_FNDCPT_PROFILE_PVT dependencies on IBY_FNDCPT_USER_CC_PF_B

Line 70: FROM iby_fndcpt_user_cc_pf_b prof, iby_bepkeys key

66: IF (p_instr_type in ( 'CREDITCARD', 'PURCHASECARD')) THEN
67:
68: SELECT user_cc_profile_code
69: INTO x_profile_code
70: FROM iby_fndcpt_user_cc_pf_b prof, iby_bepkeys key
71: WHERE (prof.bep_account_id = key.bep_account_id)
72: AND (key.bepid = p_bepid)
73: AND (key.ownertype = 'PAYEE')
74: AND (key.ownerid = p_payeeid)

Line 325: (ci_profile_code iby_fndcpt_user_cc_pf_b.user_cc_profile_code%TYPE)

321: l_settle_cfg_id iby_transmit_configs_b.transmit_configuration_id%TYPE;
322: l_query_cfg_id iby_transmit_configs_b.transmit_configuration_id%TYPE;
323:
324: CURSOR c_cc_user_prof
325: (ci_profile_code iby_fndcpt_user_cc_pf_b.user_cc_profile_code%TYPE)
326: IS
327: SELECT online_auth_trans_config_id, settlement_trans_config_id,
328: query_trans_config_id
329: FROM iby_fndcpt_user_cc_pf_b

Line 329: FROM iby_fndcpt_user_cc_pf_b

325: (ci_profile_code iby_fndcpt_user_cc_pf_b.user_cc_profile_code%TYPE)
326: IS
327: SELECT online_auth_trans_config_id, settlement_trans_config_id,
328: query_trans_config_id
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)

Line 369: FROM iby_fndcpt_user_cc_pf_b

365: Delete_Trans_Config(l_settle_cfg_id);
366: Delete_Trans_Config(l_query_cfg_id);
367:
368: DELETE
369: FROM iby_fndcpt_user_cc_pf_b
370: WHERE (user_cc_profile_code=p_cc_profile_code);
371: END IF;
372: CLOSE c_cc_user_prof;
373: