[Home] [Help]
290: and a.usertype_id=c.usertype_id;
291:
292: cursor getLUDFromUserReg(l_user_reg_id VARCHAR2) is
293: select to_char (last_update_date, 'mmddyyyyhh24miss')
294: from jtf_um_usertype_reg
295: where usertype_reg_id = to_number (l_user_reg_id);
296:
297: CURSOR CHECK_PARTNER(l_party_id VARCHAR2) IS
298: select partner_id, party_name from pv_partner_profiles,hz_parties where partner_party_id=l_party_id and party_id=partner_party_id;
1403: and a.usertype_id=c.usertype_id;
1404:
1405: cursor getLUDFromUserReg(l_user_reg_id VARCHAR2) is
1406: select to_char (last_update_date, 'mmddyyyyhh24miss')
1407: from jtf_um_usertype_reg
1408: where usertype_reg_id = to_number (l_user_reg_id);
1409:
1410: CURSOR CHECK_PARTNER(l_party_id VARCHAR2) IS
1411: select partner_id from pv_partner_profiles where partner_party_id=l_party_id;
1990: CURSOR user_type_id (user_type VARCHAR2) IS
1991: select usertype_id ,nvl(approval_id,-1) from JTF_UM_USERTYPES_B where usertype_key=user_type;
1992:
1993: CURSOR user_type_reg_id (USERNAME VARCHAR2 , USERTYPE VARCHAR2) IS
1994: select USERTYPE_REG_ID from jtf_um_usertype_reg reg, fnd_user fu, JTF_UM_USERTYPES_B type where
1995: fu.user_id=reg.user_id and fu.user_name=username and
1996: type.usertype_key=USERTYPE and
1997: reg.usertype_id=type.usertype_id and
1998: reg.user_id=fu.user_id;
2009: select SUBSCRIPTION_REG_ID from jtf_um_subscription_reg where user_id=userid and subscription_id=subscriptionid;
2010:
2011: cursor getLUDFromUserReg(l_user_reg_id VARCHAR2) is
2012: select to_char (last_update_date, 'mmddyyyyhh24miss')
2013: from jtf_um_usertype_reg
2014: where usertype_reg_id = to_number (l_user_reg_id);
2015:
2016: CURSOR CHECK_PARTNER(l_party_id VARCHAR2) IS
2017: select partner_id from pv_partner_profiles where partner_party_id=l_party_id;