APPS.IBY_FNDCPT_PROFILE_PVT dependencies on IBY_FNDCPT_USER_DC_PF_B

Line 92: FROM iby_fndcpt_user_dc_pf_b prof, iby_bepkeys key

88: ELSIF (p_instr_type = 'PINLESSDEBITCARD') THEN
89:
90: SELECT user_dc_profile_code
91: INTO x_profile_code
92: FROM iby_fndcpt_user_dc_pf_b prof, iby_bepkeys key
93: WHERE (prof.bep_account_id = key.bep_account_id)
94: AND (key.bepid = p_bepid)
95: AND (key.ownertype = 'PAYEE')
96: AND (key.ownerid = p_payeeid)

Line 341: (ci_profile_code iby_fndcpt_user_dc_pf_b.user_dc_profile_code%TYPE)

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)
342: IS
343: SELECT online_deb_trans_config_id, settlement_trans_config_id,
344: query_trans_config_id
345: FROM iby_fndcpt_user_dc_pf_b

Line 345: FROM iby_fndcpt_user_dc_pf_b

341: (ci_profile_code iby_fndcpt_user_dc_pf_b.user_dc_profile_code%TYPE)
342: IS
343: SELECT online_deb_trans_config_id, settlement_trans_config_id,
344: query_trans_config_id
345: FROM iby_fndcpt_user_dc_pf_b
346: WHERE (user_dc_profile_code=ci_profile_code);
347:
348: BEGIN
349:

Line 397: FROM iby_fndcpt_user_dc_pf_b

393: Delete_Trans_Config(l_settle_cfg_id);
394: Delete_Trans_Config(l_query_cfg_id);
395:
396: DELETE
397: FROM iby_fndcpt_user_dc_pf_b
398: WHERE (user_dc_profile_code=p_dc_profile_code);
399: END IF;
400: CLOSE c_dc_user_prof;
401: