APPS.CS_ASSIGN_RESOURCE_PKG dependencies on HZ_PARTIES

Line 531: WHERE owner_table_name = 'HZ_PARTIES'

527: -- VIP Customer Code
528: CURSOR C_CLASS_CODE(l_party_id number,l_cust_category varchar2) is
529: SELECT class_code
530: FROM hz_code_assignments
531: WHERE owner_table_name = 'HZ_PARTIES'
532: AND owner_table_id = l_party_id
533: AND class_category = l_cust_category;
534: */
535: --Bug 5255184 Modified the c_area_code query

Line 543: FROM hz_parties

539: WHERE hzp.contact_point_id = c_customer_phone_id;
540:
541: CURSOR c_cust_det(p_customer_id NUMBER) IS
542: SELECT employees_total, party_name
543: FROM hz_parties
544: WHERE party_id = p_customer_id;
545:
546:
547:

Line 953: WHERE owner_table_name = 'HZ_PARTIES'

949: -- VIP Customer Code
950: CURSOR c_class_code(l_party_id NUMBER,l_cust_category VARCHAR2) IS
951: SELECT class_code
952: FROM hz_code_assignments
953: WHERE owner_table_name = 'HZ_PARTIES'
954: AND owner_table_id = l_party_id
955: AND class_category = l_cust_category;
956: */
957: --Bug 5255184 Modified the c_area_code query

Line 972: FROM hz_parties

968: AND NVL(delete_flag, 'N') <> 'Y';
969:
970: CURSOR c_cust_det(p_customer_id NUMBER) IS
971: SELECT employees_total, party_name
972: FROM hz_parties
973: WHERE party_id = p_customer_id;
974:
975: BEGIN
976: