APPS.HZ_BANK_PUB dependencies on HZ_CODE_ASSIGNMENTS

Line 17: FROM hz_code_assignments hca

13: -- declaration of private cursors
14: --
15: CURSOR c_codeassign (p_party_id IN NUMBER) IS
16: SELECT hca.class_code
17: FROM hz_code_assignments hca
18: WHERE hca.owner_table_id = p_party_id
19: AND hca.owner_table_name = 'HZ_PARTIES'
20: AND hca.class_category = 'BANK_INSTITUTION_TYPE'
21: AND hca.primary_flag = 'Y'

Line 580: hz_code_assignments hca

576: -- bank parties.
577: CURSOR c_uniqueptyedi IS
578: SELECT 1
579: FROM hz_contact_points hcp,
580: hz_code_assignments hca
581: WHERE hcp.edi_id_number = p_edi_rec.edi_id_number
582: AND NVL(hcp.edi_ece_tp_location_code,
583: p_edi_rec.edi_ece_tp_location_code) =
584: p_edi_rec.edi_ece_tp_location_code

Line 599: hz_code_assignments hca

595: CURSOR c_uniquepsedi IS
596: SELECT 1
597: FROM hz_contact_points hcp,
598: hz_party_sites hps,
599: hz_code_assignments hca
600: WHERE hcp.edi_id_number = p_edi_rec.edi_id_number
601: AND NVL(hcp.edi_ece_tp_location_code,
602: p_edi_rec.edi_ece_tp_location_code) =
603: p_edi_rec.edi_ece_tp_location_code

Line 2254: FROM hz_code_assignments hca

2250:
2251: CURSOR c_assignid IS
2252: SELECT hca.code_assignment_id,
2253: hca.object_version_number
2254: FROM hz_code_assignments hca
2255: WHERE hca.class_category = p_class_category
2256: AND hca.owner_table_name = 'HZ_PARTIES'
2257: AND hca.owner_table_id = p_party_id
2258: AND hca.primary_flag='Y'

Line 2265: FROM hz_code_assignments hca

2261:
2262: CURSOR c_assignid1 IS
2263: SELECT hca.code_assignment_id,
2264: hca.object_version_number
2265: FROM hz_code_assignments hca
2266: WHERE hca.class_category = p_class_category
2267: AND hca.owner_table_name = 'HZ_PARTIES'
2268: AND hca.owner_table_id = p_party_id
2269: AND hca.class_code = p_bank_organization_type;

Line 2274: FROM hz_code_assignments hca

2270:
2271: CURSOR c_assignid2 IS
2272: SELECT hca.code_assignment_id,
2273: hca.object_version_number
2274: FROM hz_code_assignments hca
2275: WHERE hca.class_category = p_class_category
2276: AND hca.owner_table_name = 'HZ_PARTIES'
2277: AND hca.owner_table_id = p_party_id
2278: AND hca.primary_flag='Y'

Line 2465: FROM hz_code_assignments hca

2461: l_assignment_id NUMBER;
2462:
2463: CURSOR c_party_usage_code IS
2464: SELECT hca.class_code
2465: FROM hz_code_assignments hca
2466: WHERE hca.class_category = 'BANK_INSTITUTION_TYPE'
2467: AND hca.owner_table_name = 'HZ_PARTIES'
2468: AND hca.owner_table_id = p_party_id
2469: AND hca.status = 'A';