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 568: hz_code_assignments hca

564: -- bank parties.
565: CURSOR c_uniqueptyedi IS
566: SELECT 1
567: FROM hz_contact_points hcp,
568: hz_code_assignments hca
569: WHERE hcp.edi_id_number = p_edi_rec.edi_id_number
570: AND NVL(hcp.edi_ece_tp_location_code,
571: p_edi_rec.edi_ece_tp_location_code) =
572: p_edi_rec.edi_ece_tp_location_code

Line 587: hz_code_assignments hca

583: CURSOR c_uniquepsedi IS
584: SELECT 1
585: FROM hz_contact_points hcp,
586: hz_party_sites hps,
587: hz_code_assignments hca
588: WHERE hcp.edi_id_number = p_edi_rec.edi_id_number
589: AND NVL(hcp.edi_ece_tp_location_code,
590: p_edi_rec.edi_ece_tp_location_code) =
591: p_edi_rec.edi_ece_tp_location_code

Line 2239: FROM hz_code_assignments hca

2235:
2236: CURSOR c_assignid IS
2237: SELECT hca.code_assignment_id,
2238: hca.object_version_number
2239: FROM hz_code_assignments hca
2240: WHERE hca.class_category = p_class_category
2241: AND hca.owner_table_name = 'HZ_PARTIES'
2242: AND hca.owner_table_id = p_party_id
2243: AND hca.primary_flag='Y'

Line 2250: FROM hz_code_assignments hca

2246:
2247: CURSOR c_assignid1 IS
2248: SELECT hca.code_assignment_id,
2249: hca.object_version_number
2250: FROM hz_code_assignments hca
2251: WHERE hca.class_category = p_class_category
2252: AND hca.owner_table_name = 'HZ_PARTIES'
2253: AND hca.owner_table_id = p_party_id
2254: AND hca.class_code = p_bank_organization_type;

Line 2259: FROM hz_code_assignments hca

2255:
2256: CURSOR c_assignid2 IS
2257: SELECT hca.code_assignment_id,
2258: hca.object_version_number
2259: FROM hz_code_assignments hca
2260: WHERE hca.class_category = p_class_category
2261: AND hca.owner_table_name = 'HZ_PARTIES'
2262: AND hca.owner_table_id = p_party_id
2263: AND hca.primary_flag='Y'

Line 2450: FROM hz_code_assignments hca

2446: l_assignment_id NUMBER;
2447:
2448: CURSOR c_party_usage_code IS
2449: SELECT hca.class_code
2450: FROM hz_code_assignments hca
2451: WHERE hca.class_category = 'BANK_INSTITUTION_TYPE'
2452: AND hca.owner_table_name = 'HZ_PARTIES'
2453: AND hca.owner_table_id = p_party_id
2454: AND hca.status = 'A';