DBA Data[Home] [Help]

APPS.CS_ASSIGN_RESOURCE_CON_PKG dependencies on HZ_CODE_ASSIGNMENTS

Line 706: FROM hz_code_assignments

702: WHERE cle_id = l_contract_service_id;
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:

Line 1070: FROM hz_code_assignments

1066: WHERE cle_id = l_contract_service_id;
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: