437: IS
438: l_payeeid iby_payee.payeeid%TYPE;
439:
440: CURSOR c_payeeid
441: (ci_org_type IN iby_fndcpt_payee_appl.org_type%TYPE,
442: ci_org_id IN iby_fndcpt_payee_appl.org_id%TYPE
443: )
444: IS
445: SELECT p.payeeid
438: l_payeeid iby_payee.payeeid%TYPE;
439:
440: CURSOR c_payeeid
441: (ci_org_type IN iby_fndcpt_payee_appl.org_type%TYPE,
442: ci_org_id IN iby_fndcpt_payee_appl.org_id%TYPE
443: )
444: IS
445: SELECT p.payeeid
446: FROM iby_payee p, iby_fndcpt_payee_appl a
442: ci_org_id IN iby_fndcpt_payee_appl.org_id%TYPE
443: )
444: IS
445: SELECT p.payeeid
446: FROM iby_payee p, iby_fndcpt_payee_appl a
447: WHERE (p.mpayeeid = a.mpayeeid)
448: AND ((a.org_type = ci_org_type) AND (a.org_id = ci_org_id));
449:
450: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.Get_Internal_Payee';