DBA Data[Home] [Help]

APPS.CS_ASSIGN_RESOURCE_CON_PKG dependencies on HZ_CODE_ASSIGNMENTS

Line 695: FROM hz_code_assignments

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

Line 1014: FROM hz_code_assignments

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