APPS.WSH_SUPPLIER_PARTY dependencies on HZ_CODE_ASSIGNMENTS

Line 418: FROM hz_code_assignments

414:
415: --Cursor to check if code assignment is already exist for party.
416: CURSOR get_code_assignments(p_party_id NUMBER) IS
417: SELECT 'X'
418: FROM hz_code_assignments
419: WHERE owner_table_name = 'HZ_PARTIES'
420: AND owner_table_id = p_party_id
421: AND class_category = 'POS_CLASSIFICATION'
422: AND class_code = 'PROCUREMENT_ORGANIZATION'

Line 1052: from hz_code_assignments

1048: and hp.party_name = p_supplier_name
1049: and fu.user_id = p_user_id
1050: and h2.subject_id IN
1051: (select owner_table_id
1052: from hz_code_assignments
1053: where owner_table_name='HZ_PARTIES'
1054: and status = 'A'
1055: and class_category ='POS_PARTICIPANT_TYPE'
1056: and class_code='VENDOR');