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 788: SELECT hz_account_num_s.nextval into p_account_number FROM DUAL;

784: p_message =>'l_party_type:' || l_party_type
785: );
786: end if;
787:
788: SELECT hz_account_num_s.nextval into p_account_number FROM DUAL;
789: if(p_approval_id is null or p_approval_id = -1 OR l_party_type='PARTY_RELATIONSHIP')
790: then
791:
792: --if P_USERTYPE_KEY = 'INDIVIDUALUSER' then