DBA Data[Home] [Help]

APPS.IBY_EXT_BANKACCT_PUB dependencies on HZ_CODE_ASSIGNMENTS

Line 831: FROM HZ_CODE_ASSIGNMENTS

827:
828: -- Picks up object version number of RFC identifier
829: CURSOR c_rfc_identifier_ovn(p_branch_id NUMBER) IS
830: SELECT object_version_number
831: FROM HZ_CODE_ASSIGNMENTS
832: WHERE class_category = 'RFC_IDENTIFIER'
833: AND owner_table_name = 'HZ_PARTIES'
834: AND owner_table_id = p_branch_id;
835:

Line 839: FROM HZ_CODE_ASSIGNMENTS

835:
836: -- Picks up object version number of EFT Record
837: CURSOR c_eft_record_ovn(p_branch_id NUMBER) IS
838: SELECT object_version_number
839: FROM HZ_CODE_ASSIGNMENTS
840: WHERE class_category = 'EFT'
841: AND owner_table_name = 'HZ_PARTIES'
842: AND owner_table_id = p_branch_id;
843:

Line 4754: hz_code_assignments hz_bankCA,

4750: FROM hz_parties hz_bank,
4751: hz_organization_profiles hz_bankorg,
4752: hz_parties hz_branch,
4753: hz_relationships hz_rel,
4754: hz_code_assignments hz_bankCA,
4755: hz_code_assignments hz_branchCA
4756: WHERE hz_branchCA.owner_table_name = 'HZ_PARTIES'
4757: AND hz_branchCA.owner_table_id = hz_branch.party_id
4758: AND hz_branchCA.class_category = 'BANK_INSTITUTION_TYPE'

Line 4755: hz_code_assignments hz_branchCA

4751: hz_organization_profiles hz_bankorg,
4752: hz_parties hz_branch,
4753: hz_relationships hz_rel,
4754: hz_code_assignments hz_bankCA,
4755: hz_code_assignments hz_branchCA
4756: WHERE hz_branchCA.owner_table_name = 'HZ_PARTIES'
4757: AND hz_branchCA.owner_table_id = hz_branch.party_id
4758: AND hz_branchCA.class_category = 'BANK_INSTITUTION_TYPE'
4759: AND hz_branchCA.class_code = 'BANK_BRANCH'