eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CE_VALIDATE_BANKINFO dependencies on HZ_CODE_ASSIGNMENTS

Line 18: HZ_CODE_ASSIGNMENTS CABank

14: cursor get_bank_num ( Xi_BANK_ID NUMBER) IS
15: select OrgProfileBank.BANK_OR_BRANCH_NUMBER
16: From HZ_PARTIES PartyBank,
17: HZ_ORGANIZATION_PROFILES OrgProfileBank,
18: HZ_CODE_ASSIGNMENTS CABank
19: Where
20: PartyBank.party_id = Xi_BANK_ID
21: and PartyBank.PARTY_TYPE = 'ORGANIZATION'
22: and PartyBank.status = 'A'

Line 164: HZ_CODE_ASSIGNMENTS CABank

160: -- Bank ID is being used. Check if Bank exists and fetch Bank Number --
161: SELECT count(*) INTO bank_count
162: FROM HZ_PARTIES PartyBank,
163: HZ_ORGANIZATION_PROFILES OrgProfileBank,
164: HZ_CODE_ASSIGNMENTS CABank
165: WHERE
166: PartyBank.party_id = Xi_BANK_ID
167: AND PartyBank.PARTY_TYPE = 'ORGANIZATION'
168: AND PartyBank.status = 'A'

Line 674: HZ_CODE_ASSIGNMENTS BankCA,

670: HZ_PARTIES BranchParty,
671: HZ_ORGANIZATION_PROFILES BankOrgProfile,
672: HZ_ORGANIZATION_PROFILES BranchOrgProfile,
673: HZ_RELATIONSHIPS BRRel,
674: HZ_CODE_ASSIGNMENTS BankCA,
675: HZ_CODE_ASSIGNMENTS BranchCA
676: Where BankParty.PARTY_TYPE = 'ORGANIZATION'
677: And BankParty.status = 'A'
678: And BankParty.PARTY_ID = BankOrgProfile.PARTY_ID

Line 675: HZ_CODE_ASSIGNMENTS BranchCA

671: HZ_ORGANIZATION_PROFILES BankOrgProfile,
672: HZ_ORGANIZATION_PROFILES BranchOrgProfile,
673: HZ_RELATIONSHIPS BRRel,
674: HZ_CODE_ASSIGNMENTS BankCA,
675: HZ_CODE_ASSIGNMENTS BranchCA
676: Where BankParty.PARTY_TYPE = 'ORGANIZATION'
677: And BankParty.status = 'A'
678: And BankParty.PARTY_ID = BankOrgProfile.PARTY_ID
679: And SYSDATE between TRUNC(BankOrgProfile.effective_start_date)

Line 757: HZ_CODE_ASSIGNMENTS BankCA,

753: HZ_PARTIES BranchParty,
754: HZ_ORGANIZATION_PROFILES BankOrgProfile,
755: HZ_ORGANIZATION_PROFILES BranchOrgProfile,
756: HZ_RELATIONSHIPS BRRel,
757: HZ_CODE_ASSIGNMENTS BankCA,
758: HZ_CODE_ASSIGNMENTS BranchCA
759: Where BankParty.PARTY_TYPE = 'ORGANIZATION'
760: And BankParty.status = 'A'
761: And BankParty.PARTY_ID = BankOrgProfile.PARTY_ID

Line 758: HZ_CODE_ASSIGNMENTS BranchCA

754: HZ_ORGANIZATION_PROFILES BankOrgProfile,
755: HZ_ORGANIZATION_PROFILES BranchOrgProfile,
756: HZ_RELATIONSHIPS BRRel,
757: HZ_CODE_ASSIGNMENTS BankCA,
758: HZ_CODE_ASSIGNMENTS BranchCA
759: Where BankParty.PARTY_TYPE = 'ORGANIZATION'
760: And BankParty.status = 'A'
761: And BankParty.PARTY_ID = BankOrgProfile.PARTY_ID
762: And SYSDATE between TRUNC(BankOrgProfile.effective_start_date)

Line 842: HZ_CODE_ASSIGNMENTS BankCA,

838: HZ_PARTIES BranchParty,
839: HZ_ORGANIZATION_PROFILES BankOrgProfile,
840: HZ_ORGANIZATION_PROFILES BranchOrgProfile,
841: HZ_RELATIONSHIPS BRRel,
842: HZ_CODE_ASSIGNMENTS BankCA,
843: HZ_CODE_ASSIGNMENTS BranchCA
844: Where BankParty.PARTY_TYPE = 'ORGANIZATION'
845: And BankParty.status = 'A'
846: And BankParty.PARTY_ID = BankOrgProfile.PARTY_ID

Line 843: HZ_CODE_ASSIGNMENTS BranchCA

839: HZ_ORGANIZATION_PROFILES BankOrgProfile,
840: HZ_ORGANIZATION_PROFILES BranchOrgProfile,
841: HZ_RELATIONSHIPS BRRel,
842: HZ_CODE_ASSIGNMENTS BankCA,
843: HZ_CODE_ASSIGNMENTS BranchCA
844: Where BankParty.PARTY_TYPE = 'ORGANIZATION'
845: And BankParty.status = 'A'
846: And BankParty.PARTY_ID = BankOrgProfile.PARTY_ID
847: And SYSDATE between TRUNC(BankOrgProfile.effective_start_date)

Line 7582: HZ_CODE_ASSIGNMENTS HzCodeAssignmentBankEO

7578:
7579: select count(*) into temp_name_alt
7580: From HZ_PARTIES HzPartyBankEO,
7581: HZ_ORGANIZATION_PROFILES HzOrgProfileBankEO,
7582: HZ_CODE_ASSIGNMENTS HzCodeAssignmentBankEO
7583: Where
7584: HzPartyBankEO.ORGANIZATION_NAME_PHONETIC = Xi_BANK_NAME_ALT
7585: and HzPartyBankEO.country = Xi_COUNTRY_NAME
7586: and HzPartyBankEO.PARTY_TYPE = 'ORGANIZATION'