692:
693: CURSOR C_CLASS_CODE(l_party_id NUMBER,l_cust_category VARCHAR2) IS
694: SELECT class_code
695: FROM hz_code_assignments
696: WHERE owner_table_name = 'HZ_PARTIES'
697: AND owner_table_id = l_party_id
698: AND class_category = l_cust_category;
699:
700: --Bug 5255184 Modified the c_area_code query
704: WHERE hzp.contact_point_id = c_customer_phone_id;
705:
706: CURSOR c_cust_det(p_customer_id NUMBER) IS
707: SELECT employees_total, party_name
708: FROM hz_parties
709: WHERE party_id = p_customer_id;
710:
711: BEGIN
712: -- Initialize API return status to success
1011:
1012: CURSOR c_class_code(l_party_id NUMBER,l_cust_category VARCHAR2) is
1013: SELECT class_code
1014: FROM hz_code_assignments
1015: WHERE owner_table_name = 'HZ_PARTIES'
1016: AND owner_table_id = l_party_id
1017: AND class_category = l_cust_category;
1018:
1019: --Added in 11.5.9
1040: AND NVL(delete_flag, 'N') <> 'Y';
1041:
1042: CURSOR c_cust_det(p_customer_id NUMBER) IS
1043: SELECT employees_total, party_name
1044: FROM hz_parties
1045: WHERE party_id = p_customer_id;
1046:
1047: BEGIN
1048: -- Initialize API return status to success