APPS.IBY_FNDCPT_PROFILE_PVT dependencies on IBY_BEPKEYS

Line 55: p_payeeid IN iby_bepkeys.ownerid%TYPE,

51:
52: PROCEDURE Get_Profile_Code
53: (
54: p_bepid IN iby_bepinfo.bepid%TYPE,
55: p_payeeid IN iby_bepkeys.ownerid%TYPE,
56: p_bepkey IN iby_bepkeys.key%TYPE,
57: p_instr_type IN VARCHAR2,
58: x_profile_code OUT NOCOPY VARCHAR2
59: )

Line 56: p_bepkey IN iby_bepkeys.key%TYPE,

52: PROCEDURE Get_Profile_Code
53: (
54: p_bepid IN iby_bepinfo.bepid%TYPE,
55: p_payeeid IN iby_bepkeys.ownerid%TYPE,
56: p_bepkey IN iby_bepkeys.key%TYPE,
57: p_instr_type IN VARCHAR2,
58: x_profile_code OUT NOCOPY VARCHAR2
59: )
60: IS

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 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 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 109: p_bep_acct_id IN iby_bepkeys.bep_account_id%TYPE,

105:
106: PROCEDURE Create_User_Profiles
107: (
108: p_bepid IN iby_bepinfo.bepid%TYPE,
109: p_bep_acct_id IN iby_bepkeys.bep_account_id%TYPE,
110: p_cc_profile_code IN iby_fndcpt_user_cc_pf_vl.user_cc_profile_code%TYPE,
111: p_cc_profile_name IN iby_fndcpt_user_cc_pf_vl.user_cc_profile_name%TYPE,
112: p_eft_profile_code IN iby_fndcpt_user_eft_pf_vl.user_eft_profile_code%TYPE,
113: p_eft_profile_name IN iby_fndcpt_user_eft_pf_vl.user_eft_profile_name%TYPE,