APPS.CE_BANK_PUB dependencies on HZ_CODE_ASSIGNMENTS

Line 75: hz_code_assignments hz_bankCA,

71: FROM hz_parties hz_bank,
72: hz_organization_profiles hz_bankorg,
73: hz_parties hz_branch,
74: hz_relationships hz_rel,
75: hz_code_assignments hz_bankCA,
76: hz_code_assignments hz_branchCA
77: WHERE hz_branchCA.owner_table_name = 'HZ_PARTIES'
78: AND hz_branchCA.owner_table_id = hz_branch.party_id
79: AND hz_branchCA.class_category = 'BANK_INSTITUTION_TYPE'

Line 76: hz_code_assignments hz_branchCA

72: hz_organization_profiles hz_bankorg,
73: hz_parties hz_branch,
74: hz_relationships hz_rel,
75: hz_code_assignments hz_bankCA,
76: hz_code_assignments hz_branchCA
77: WHERE hz_branchCA.owner_table_name = 'HZ_PARTIES'
78: AND hz_branchCA.owner_table_id = hz_branch.party_id
79: AND hz_branchCA.class_category = 'BANK_INSTITUTION_TYPE'
80: AND hz_branchCA.class_code = 'BANK_BRANCH'

Line 519: FROM hz_code_assignments

515:
516: -- find the object_version_number of the code_assignment for the 'BANK' institution type
517: SELECT object_version_number
518: INTO l_ca_object_version_number
519: FROM hz_code_assignments
520: WHERE class_category= 'BANK_INSTITUTION_TYPE'
521: AND owner_table_name = 'HZ_PARTIES'
522: AND owner_table_id = p_bank_id
523: AND status = 'A';

Line 623: FROM hz_code_assignments

619: x_msg_data OUT NOCOPY VARCHAR2
620: ) IS
621: CURSOR c_bank IS
622: SELECT end_date_active
623: FROM hz_code_assignments
624: WHERE owner_table_name = 'HZ_PARTIES'
625: AND owner_table_id = p_bank_id
626: AND class_category = 'BANK_INSTITUTION_TYPE'
627: AND class_code = 'BANK';

Line 640: FROM hz_code_assignments

636: AND object_type = 'ORGANIZATION'
637: AND object_id = p_bank_id;
638: CURSOR c_branch (p_branch_id NUMBER) IS
639: SELECT end_date_active, object_version_number
640: FROM hz_code_assignments
641: WHERE owner_table_name = 'HZ_PARTIES'
642: AND owner_table_id = p_branch_id
643: AND class_category = 'BANK_INSTITUTION_TYPE'
644: AND class_code = 'BANK_BRANCH';

Line 831: hz_code_assignments hz_ca

827: SELECT hz_hp.party_id,
828: hz_ca.end_date_active
829: FROM hz_parties hz_hp,
830: hz_organization_profiles hz_org,
831: hz_code_assignments hz_ca
832: WHERE hz_ca.owner_table_id = hz_hp.party_id
833: AND hz_ca.owner_table_name = 'HZ_PARTIES'
834: AND hz_ca.class_category = 'BANK_INSTITUTION_TYPE'
835: AND hz_ca.class_code = 'BANK'

Line 847: hz_code_assignments hz_ca

843: SELECT hz_hp.party_id,
844: hz_ca.end_date_active
845: FROM hz_parties hz_hp,
846: hz_organization_profiles hz_hop,
847: hz_code_assignments hz_ca
848: WHERE hz_hp.party_id = hz_hop.party_id
849: AND SYSDATE between TRUNC(hz_hop.effective_start_date)
850: and NVL(TRUNC(hz_hop.effective_end_date), SYSDATE+1)
851: AND hz_ca.owner_table_id = hz_hp.party_id

Line 1525: FROM hz_code_assignments

1521: x_msg_data OUT NOCOPY VARCHAR2
1522: ) IS
1523: CURSOR c_bank (p_bank_id NUMBER) IS
1524: SELECT end_date_active, object_version_number
1525: FROM hz_code_assignments
1526: WHERE owner_table_name = 'HZ_PARTIES'
1527: AND owner_table_id = p_bank_id
1528: AND class_category = 'BANK_INSTITUTION_TYPE'
1529: AND class_code = 'BANK';

Line 1542: FROM hz_code_assignments

1538: AND object_type = 'ORGANIZATION'
1539: AND subject_id = p_branch_id;
1540: CURSOR c_branch_end IS
1541: SELECT end_date_active
1542: FROM hz_code_assignments
1543: WHERE owner_table_name = 'HZ_PARTIES'
1544: AND owner_table_id = p_branch_id
1545: AND class_category = 'BANK_INSTITUTION_TYPE'
1546: AND class_code = 'BANK_BRANCH';

Line 1557: FROM hz_code_assignments

1553: FROM ce_bank_accounts
1554: WHERE bank_branch_id = p_branch_id;
1555: CURSOR c_rfc_ovn IS
1556: SELECT object_version_number
1557: FROM hz_code_assignments
1558: WHERE owner_table_name = 'HZ_PARTIES'
1559: AND owner_table_id = p_branch_id
1560: AND class_category = 'RFC_IDENTIFIER';
1561:

Line 1796: hz_code_assignments hz_branchCA

1792: SELECT hz_branch.party_id,
1793: hz_branchCA.end_date_active
1794: FROM hz_parties hz_branch,
1795: hz_relationships hz_rel,
1796: hz_code_assignments hz_branchCA
1797: WHERE hz_branchCA.owner_table_name = 'HZ_PARTIES'
1798: AND hz_branchCA.owner_table_id = hz_branch.party_id
1799: AND hz_branchCA.class_category = 'BANK_INSTITUTION_TYPE'
1800: AND hz_branchCA.class_code = 'BANK_BRANCH'

Line 1819: hz_code_assignments hz_branchCA

1815: hz_branchCA.end_date_active
1816: FROM hz_parties hz_branch,
1817: hz_organization_profiles hz_branchProf,
1818: hz_relationships hz_rel,
1819: hz_code_assignments hz_branchCA
1820: WHERE hz_branchCA.owner_table_name = 'HZ_PARTIES'
1821: AND hz_branchCA.owner_table_id = hz_branch.party_id
1822: AND hz_branchCA.class_category = 'BANK_INSTITUTION_TYPE'
1823: AND hz_branchCA.class_code = 'BANK_BRANCH'