DBA Data[Home] [Help]

APPS.IBY_EXT_BANKACCT_PUB dependencies on HZ_CODE_ASSIGNMENTS

Line 757: FROM HZ_CODE_ASSIGNMENTS

753:
754: -- Picks up object version number of RFC identifier
755: CURSOR c_rfc_identifier_ovn(p_branch_id NUMBER) IS
756: SELECT object_version_number
757: FROM HZ_CODE_ASSIGNMENTS
758: WHERE class_category = 'RFC_IDENTIFIER'
759: AND owner_table_name = 'HZ_PARTIES'
760: AND owner_table_id = p_branch_id;
761:

Line 765: FROM HZ_CODE_ASSIGNMENTS

761:
762: -- Picks up object version number of EFT Record
763: CURSOR c_eft_record_ovn(p_branch_id NUMBER) IS
764: SELECT object_version_number
765: FROM HZ_CODE_ASSIGNMENTS
766: WHERE class_category = 'EFT'
767: AND owner_table_name = 'HZ_PARTIES'
768: AND owner_table_id = p_branch_id;
769:

Line 3932: hz_code_assignments hz_bankCA,

3928: FROM hz_parties hz_bank,
3929: hz_organization_profiles hz_bankorg,
3930: hz_parties hz_branch,
3931: hz_relationships hz_rel,
3932: hz_code_assignments hz_bankCA,
3933: hz_code_assignments hz_branchCA
3934: WHERE hz_branchCA.owner_table_name = 'HZ_PARTIES'
3935: AND hz_branchCA.owner_table_id = hz_branch.party_id
3936: AND hz_branchCA.class_category = 'BANK_INSTITUTION_TYPE'

Line 3933: hz_code_assignments hz_branchCA

3929: hz_organization_profiles hz_bankorg,
3930: hz_parties hz_branch,
3931: hz_relationships hz_rel,
3932: hz_code_assignments hz_bankCA,
3933: hz_code_assignments hz_branchCA
3934: WHERE hz_branchCA.owner_table_name = 'HZ_PARTIES'
3935: AND hz_branchCA.owner_table_id = hz_branch.party_id
3936: AND hz_branchCA.class_category = 'BANK_INSTITUTION_TYPE'
3937: AND hz_branchCA.class_code = 'BANK_BRANCH'