APPS.EGO_PARTY_PUB dependencies on HZ_CODE_ASSIGNMENTS

Line 2341: FROM hz_code_assignments

2337:
2338:
2339: SELECT COUNT(*)
2340: INTO l_class_count
2341: FROM hz_code_assignments
2342: WHERE owner_table_name = 'HZ_PARTIES'
2343: AND owner_table_id = p_party_id
2344: AND class_category = p_category;
2345:

Line 2461: FROM hz_code_assignments

2457:
2458:
2459: SELECT code_assignment_id, object_version_number
2460: INTO l_assignment_id, l_version_number
2461: FROM hz_code_assignments
2462: WHERE owner_table_name = 'HZ_PARTIES'
2463: AND owner_table_id = p_party_id
2464: AND class_category = p_category;
2465:

Line 2521: FROM hz_code_assignments hca

2517: x_msg_count := 0;
2518: x_msg_data := NULL;
2519: SELECT hca.owner_table_id
2520: INTO l_party_id
2521: FROM hz_code_assignments hca
2522: WHERE hca.owner_table_id = p_company_id
2523: AND hca.owner_table_name = 'HZ_PARTIES'
2524: AND hca.class_category = 'POS_PARTICIPANT_TYPE'
2525: AND hca.class_code = 'ENTERPRISE';

Line 2652: FROM hz_parties hp, hz_code_assignments hca

2648: BEGIN
2649:
2650: SELECT hp.party_id
2651: INTO l_org_id
2652: FROM hz_parties hp, hz_code_assignments hca
2653: WHERE hca.owner_table_id = hp.party_id
2654: AND hca.owner_table_name = 'HZ_PARTIES'
2655: AND hca.class_category = 'POS_PARTICIPANT_TYPE'
2656: AND hca.class_code = 'ENTERPRISE'