46:
47: /*
48: Cursor C_get_party_id(c_reg_id NUMBER) IS
49: select fu.customer_id from
50: fnd_user fu, jtf_um_usertype_reg jureg
51: where jureg.usertype_reg_id=c_reg_id
52: and jureg.user_id=fu.user_id;
53: */
54:
53: */
54:
55: Cursor C_get_user_id(c_reg_id NUMBER) IS
56: select usr.user_id from
57: fnd_user usr, jtf_um_usertype_reg jureg
58: where jureg.usertype_reg_id=c_reg_id
59: and usr.user_id = jureg.user_id;
60:
61: CURSOR c_lkp(b_usertype_key VARCHAR)