APPS.CS_ASSIGN_RESOURCE_PKG dependencies on HZ_PARTIES

Line 519: WHERE owner_table_name = 'HZ_PARTIES'

515: -- VIP Customer Code
516: CURSOR C_CLASS_CODE(l_party_id number,l_cust_category varchar2) is
517: SELECT class_code
518: FROM hz_code_assignments
519: WHERE owner_table_name = 'HZ_PARTIES'
520: AND owner_table_id = l_party_id
521: AND class_category = l_cust_category;
522: */
523: --Bug 5255184 Modified the c_area_code query

Line 531: FROM hz_parties

527: WHERE hzp.contact_point_id = c_customer_phone_id;
528:
529: CURSOR c_cust_det(p_customer_id NUMBER) IS
530: SELECT employees_total, party_name
531: FROM hz_parties
532: WHERE party_id = p_customer_id;
533:
534: BEGIN
535: -- Initialize API return status to success

Line 846: WHERE owner_table_name = 'HZ_PARTIES'

842: -- VIP Customer Code
843: CURSOR c_class_code(l_party_id NUMBER,l_cust_category VARCHAR2) IS
844: SELECT class_code
845: FROM hz_code_assignments
846: WHERE owner_table_name = 'HZ_PARTIES'
847: AND owner_table_id = l_party_id
848: AND class_category = l_cust_category;
849: */
850: --Bug 5255184 Modified the c_area_code query

Line 865: FROM hz_parties

861: AND NVL(delete_flag, 'N') <> 'Y';
862:
863: CURSOR c_cust_det(p_customer_id NUMBER) IS
864: SELECT employees_total, party_name
865: FROM hz_parties
866: WHERE party_id = p_customer_id;
867:
868: BEGIN
869: