APPS.JTF_UM_USERTYPE_CREDENTIALS dependencies on HZ_ACCOUNT_NUM_S

Line 62: SELECT hz_account_num_s.nextval into p_account_number FROM DUAL;

58: l_gen_cust_no := 'Y';
59: end;
60:
61: IF l_gen_cust_no <> 'Y' THEN
62: SELECT hz_account_num_s.nextval into p_account_number FROM DUAL;
63: END IF;
64:
65: -- SELECT hz_account_num_s.nextval into p_account_number FROM DUAL;
66:

Line 65: -- SELECT hz_account_num_s.nextval into p_account_number FROM DUAL;

61: IF l_gen_cust_no <> 'Y' THEN
62: SELECT hz_account_num_s.nextval into p_account_number FROM DUAL;
63: END IF;
64:
65: -- SELECT hz_account_num_s.nextval into p_account_number FROM DUAL;
66:
67:
68: if l_party_type = 'PERSON' then
69:

Line 843: SELECT hz_account_num_s.nextval into p_account_number FROM DUAL;

839: p_message =>'l_party_type:' || l_party_type
840: );
841: end if;
842:
843: SELECT hz_account_num_s.nextval into p_account_number FROM DUAL;
844: if(p_approval_id is null or p_approval_id = -1 OR l_party_type='PARTY_RELATIONSHIP')
845: then
846:
847: --if P_USERTYPE_KEY = 'INDIVIDUALUSER' then