APPS.CE_BANK_PUB dependencies on HZ_CODE_ASSIGNMENTS

Line 105: hz_code_assignments hz_bankCA,

101: FROM hz_parties hz_bank,
102: hz_organization_profiles hz_bankorg,
103: hz_parties hz_branch,
104: hz_relationships hz_rel,
105: hz_code_assignments hz_bankCA,
106: hz_code_assignments hz_branchCA
107: WHERE hz_branchCA.owner_table_name = 'HZ_PARTIES'
108: AND hz_branchCA.owner_table_id = hz_branch.party_id
109: AND hz_branchCA.class_category = 'BANK_INSTITUTION_TYPE'

Line 106: hz_code_assignments hz_branchCA

102: hz_organization_profiles hz_bankorg,
103: hz_parties hz_branch,
104: hz_relationships hz_rel,
105: hz_code_assignments hz_bankCA,
106: hz_code_assignments hz_branchCA
107: WHERE hz_branchCA.owner_table_name = 'HZ_PARTIES'
108: AND hz_branchCA.owner_table_id = hz_branch.party_id
109: AND hz_branchCA.class_category = 'BANK_INSTITUTION_TYPE'
110: AND hz_branchCA.class_code = 'BANK_BRANCH'

Line 547: FROM hz_code_assignments

543:
544: -- find the object_version_number of the code_assignment for the 'BANK' institution type
545: SELECT object_version_number
546: INTO l_ca_object_version_number
547: FROM hz_code_assignments
548: WHERE class_category= 'BANK_INSTITUTION_TYPE'
549: AND owner_table_name = 'HZ_PARTIES'
550: AND owner_table_id = p_bank_id
551: AND status = 'A';

Line 651: FROM hz_code_assignments

647: x_msg_data OUT NOCOPY VARCHAR2
648: ) IS
649: CURSOR c_bank IS
650: SELECT end_date_active
651: FROM hz_code_assignments
652: WHERE owner_table_name = 'HZ_PARTIES'
653: AND owner_table_id = p_bank_id
654: AND class_category = 'BANK_INSTITUTION_TYPE'
655: AND class_code = 'BANK';

Line 668: FROM hz_code_assignments

664: AND object_type = 'ORGANIZATION'
665: AND object_id = p_bank_id;
666: CURSOR c_branch (p_branch_id NUMBER) IS
667: SELECT end_date_active, object_version_number
668: FROM hz_code_assignments
669: WHERE owner_table_name = 'HZ_PARTIES'
670: AND owner_table_id = p_branch_id
671: AND class_category = 'BANK_INSTITUTION_TYPE'
672: AND class_code = 'BANK_BRANCH';

Line 855: hz_code_assignments hz_ca

851: SELECT hz_hp.party_id,
852: hz_ca.end_date_active
853: FROM hz_parties hz_hp,
854: hz_organization_profiles hz_org,
855: hz_code_assignments hz_ca
856: WHERE hz_ca.owner_table_id = hz_hp.party_id
857: AND hz_hp.party_type = 'ORGANIZATION' -- Bug 8333484
858: AND NVL(hz_hp.status, 'A') = 'A' -- Bug 8333484
859: AND hz_ca.owner_table_name = 'HZ_PARTIES'

Line 873: hz_code_assignments hz_ca

869: SELECT hz_hp.party_id,
870: hz_ca.end_date_active
871: FROM hz_parties hz_hp,
872: hz_organization_profiles hz_hop,
873: hz_code_assignments hz_ca
874: WHERE hz_hp.party_id = hz_hop.party_id
875: AND hz_hp.party_type = 'ORGANIZATION' -- Bug 8333484
876: AND NVL(hz_hp.status, 'A') = 'A' -- Bug 8333484
877: AND SYSDATE between TRUNC(hz_hop.effective_start_date)

Line 1611: FROM hz_code_assignments

1607: ) IS
1608:
1609: CURSOR c_bank (p_bank_id NUMBER) IS
1610: SELECT end_date_active, object_version_number
1611: FROM hz_code_assignments
1612: WHERE owner_table_name = 'HZ_PARTIES'
1613: AND owner_table_id = p_bank_id
1614: AND class_category = 'BANK_INSTITUTION_TYPE'
1615: AND class_code = 'BANK';

Line 1630: FROM hz_code_assignments

1626: AND subject_id = p_branch_id;
1627:
1628: CURSOR c_branch_end IS
1629: SELECT end_date_active
1630: FROM hz_code_assignments
1631: WHERE owner_table_name = 'HZ_PARTIES'
1632: AND owner_table_id = p_branch_id
1633: AND class_category = 'BANK_INSTITUTION_TYPE'
1634: AND class_code = 'BANK_BRANCH';

Line 1655: FROM hz_code_assignments

1651: WHERE branch_id = p_branch_id;
1652:
1653: CURSOR c_rfc_ovn IS
1654: SELECT object_version_number
1655: FROM hz_code_assignments
1656: WHERE owner_table_name = 'HZ_PARTIES'
1657: AND owner_table_id = p_branch_id
1658: AND class_category = 'RFC_IDENTIFIER';
1659:

Line 1935: hz_code_assignments hz_branchCA

1931: SELECT hz_branch.party_id,
1932: hz_branchCA.end_date_active
1933: FROM hz_parties hz_branch,
1934: hz_relationships hz_rel,
1935: hz_code_assignments hz_branchCA
1936: WHERE hz_branchCA.owner_table_name = 'HZ_PARTIES'
1937: AND hz_branchCA.owner_table_id = hz_branch.party_id
1938: AND hz_branchCA.class_category = 'BANK_INSTITUTION_TYPE'
1939: AND hz_branchCA.class_code = 'BANK_BRANCH'

Line 1958: hz_code_assignments hz_branchCA

1954: hz_branchCA.end_date_active
1955: FROM hz_parties hz_branch,
1956: hz_organization_profiles hz_branchProf,
1957: hz_relationships hz_rel,
1958: hz_code_assignments hz_branchCA
1959: WHERE hz_branchCA.owner_table_name = 'HZ_PARTIES'
1960: AND hz_branchCA.owner_table_id = hz_branch.party_id
1961: AND hz_branchCA.class_category = 'BANK_INSTITUTION_TYPE'
1962: AND hz_branchCA.class_code = 'BANK_BRANCH'