DBA Data[Home] [Help]

APPS.JTF_UM_PASSWORD_PVT dependencies on JTF_UM_USERTYPES_B

Line 203: * select 'T' from jtf_um_usertypes_b

199: * Other Comments :
200: * DEFAULTING LOGIC
201: * For the default workflow (JTAUMPSW) that is called by this API the following are valid:
202: * 1. Whether or not approval is needed is determined by the usertype_id.
203: * select 'T' from jtf_um_usertypes_b
204: * where usertype_id = p_usertype_id
205: * and approval_id is not NULL;
206: * 2. If last name and first name are not passed then the last name is defaulted
207: * to the user name and this will be used in the messages within the workflow

Line 623: select 'T' from jtf_um_usertypes_b

619: l_merchant_name varchar2(1000);
620: l_application_id number;
621:
622: cursor approval_needed(user_type_id in number) is
623: select 'T' from jtf_um_usertypes_b
624: where usertype_id = user_type_id
625: and approval_id is not NULL;
626:
627: cursor appl_id(p_resp_id in number) is