APPS.CS_ASSIGN_RESOURCE_CON_PKG dependencies on HZ_PARTIES

Line 707: WHERE owner_table_name = 'HZ_PARTIES'

703:
704: CURSOR C_CLASS_CODE(l_party_id NUMBER,l_cust_category VARCHAR2) IS
705: SELECT class_code
706: FROM hz_code_assignments
707: WHERE owner_table_name = 'HZ_PARTIES'
708: AND owner_table_id = l_party_id
709: AND class_category = l_cust_category;
710:
711: --Bug 5255184 Modified the c_area_code query

Line 719: FROM hz_parties

715: WHERE hzp.contact_point_id = c_customer_phone_id;
716:
717: CURSOR c_cust_det(p_customer_id NUMBER) IS
718: SELECT employees_total, party_name
719: FROM hz_parties
720: WHERE party_id = p_customer_id;
721:
722: BEGIN
723: -- Initialize API return status to success

Line 1071: WHERE owner_table_name = 'HZ_PARTIES'

1067:
1068: CURSOR c_class_code(l_party_id NUMBER,l_cust_category VARCHAR2) is
1069: SELECT class_code
1070: FROM hz_code_assignments
1071: WHERE owner_table_name = 'HZ_PARTIES'
1072: AND owner_table_id = l_party_id
1073: AND class_category = l_cust_category;
1074:
1075: --Added in 11.5.9

Line 1100: FROM hz_parties

1096: AND NVL(delete_flag, 'N') <> 'Y';
1097:
1098: CURSOR c_cust_det(p_customer_id NUMBER) IS
1099: SELECT employees_total, party_name
1100: FROM hz_parties
1101: WHERE party_id = p_customer_id;
1102:
1103: BEGIN
1104: -- Initialize API return status to success