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 12: HZ_CODE_ASSIGNMENTS CABank

8: CURSOR get_bank_num (Xi_BANK_ID NUMBER) IS
9: SELECT OrgProfileBank.BANK_OR_BRANCH_NUMBER
10: FROM HZ_PARTIES PartyBank,
11: HZ_ORGANIZATION_PROFILES OrgProfileBank,
12: HZ_CODE_ASSIGNMENTS CABank
13: WHERE
14: PartyBank.party_id = Xi_BANK_ID
15: AND PartyBank.PARTY_TYPE = 'ORGANIZATION'
16: AND PartyBank.status = 'A'

Line 191: HZ_CODE_ASSIGNMENTS CABank

187: -- Bank ID is being used. Check if Bank exists and fetch Bank Number --
188: SELECT count(*) INTO bank_count
189: FROM HZ_PARTIES PartyBank,
190: HZ_ORGANIZATION_PROFILES OrgProfileBank,
191: HZ_CODE_ASSIGNMENTS CABank
192: WHERE
193: PartyBank.party_id = Xi_BANK_ID
194: AND PartyBank.PARTY_TYPE = 'ORGANIZATION'
195: AND PartyBank.status = 'A'

Line 597: HZ_CODE_ASSIGNMENTS BankCA,

593: HZ_PARTIES BranchParty,
594: HZ_ORGANIZATION_PROFILES BankOrgProfile,
595: HZ_ORGANIZATION_PROFILES BranchOrgProfile,
596: HZ_RELATIONSHIPS BRRel,
597: HZ_CODE_ASSIGNMENTS BankCA,
598: HZ_CODE_ASSIGNMENTS BranchCA
599: WHERE BankParty.PARTY_TYPE = 'ORGANIZATION'
600: AND BankParty.status = 'A'
601: AND BankParty.PARTY_ID = BankOrgProfile.PARTY_ID

Line 598: HZ_CODE_ASSIGNMENTS BranchCA

594: HZ_ORGANIZATION_PROFILES BankOrgProfile,
595: HZ_ORGANIZATION_PROFILES BranchOrgProfile,
596: HZ_RELATIONSHIPS BRRel,
597: HZ_CODE_ASSIGNMENTS BankCA,
598: HZ_CODE_ASSIGNMENTS BranchCA
599: WHERE BankParty.PARTY_TYPE = 'ORGANIZATION'
600: AND BankParty.status = 'A'
601: AND BankParty.PARTY_ID = BankOrgProfile.PARTY_ID
602: AND SYSDATE between TRUNC(BankOrgProfile.effective_start_date)

Line 675: HZ_CODE_ASSIGNMENTS BankCA,

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

Line 676: HZ_CODE_ASSIGNMENTS BranchCA

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

Line 751: HZ_CODE_ASSIGNMENTS BankCA,

747: HZ_PARTIES BranchParty,
748: HZ_ORGANIZATION_PROFILES BankOrgProfile,
749: HZ_ORGANIZATION_PROFILES BranchOrgProfile,
750: HZ_RELATIONSHIPS BRRel,
751: HZ_CODE_ASSIGNMENTS BankCA,
752: HZ_CODE_ASSIGNMENTS BranchCA
753: WHERE BankParty.PARTY_TYPE = 'ORGANIZATION'
754: AND BankParty.status = 'A'
755: AND BankParty.PARTY_ID = BankOrgProfile.PARTY_ID

Line 752: HZ_CODE_ASSIGNMENTS BranchCA

748: HZ_ORGANIZATION_PROFILES BankOrgProfile,
749: HZ_ORGANIZATION_PROFILES BranchOrgProfile,
750: HZ_RELATIONSHIPS BRRel,
751: HZ_CODE_ASSIGNMENTS BankCA,
752: HZ_CODE_ASSIGNMENTS BranchCA
753: WHERE BankParty.PARTY_TYPE = 'ORGANIZATION'
754: AND BankParty.status = 'A'
755: AND BankParty.PARTY_ID = BankOrgProfile.PARTY_ID
756: AND SYSDATE between TRUNC(BankOrgProfile.effective_start_date)

Line 6491: HZ_CODE_ASSIGNMENTS BankCA,

6487: HZ_PARTIES BranchParty,
6488: HZ_ORGANIZATION_PROFILES BankOrgProfile,
6489: HZ_ORGANIZATION_PROFILES BranchOrgProfile,
6490: HZ_RELATIONSHIPS BRRel,
6491: HZ_CODE_ASSIGNMENTS BankCA,
6492: HZ_CODE_ASSIGNMENTS BranchCA
6493: WHERE BankParty.PARTY_TYPE = 'ORGANIZATION'
6494: AND BankParty.status = 'A'
6495: AND BankParty.PARTY_ID = BankOrgProfile.PARTY_ID

Line 6492: HZ_CODE_ASSIGNMENTS BranchCA

6488: HZ_ORGANIZATION_PROFILES BankOrgProfile,
6489: HZ_ORGANIZATION_PROFILES BranchOrgProfile,
6490: HZ_RELATIONSHIPS BRRel,
6491: HZ_CODE_ASSIGNMENTS BankCA,
6492: HZ_CODE_ASSIGNMENTS BranchCA
6493: WHERE BankParty.PARTY_TYPE = 'ORGANIZATION'
6494: AND BankParty.status = 'A'
6495: AND BankParty.PARTY_ID = BankOrgProfile.PARTY_ID
6496: AND SYSDATE between TRUNC(BankOrgProfile.effective_start_date)

Line 6610: HZ_CODE_ASSIGNMENTS HzCodeAssignmentBankEO

6606: SELECT COUNT(*)
6607: INTO temp_name_alt
6608: FROM HZ_PARTIES HzPartyBankEO,
6609: HZ_ORGANIZATION_PROFILES HzOrgProfileBankEO,
6610: HZ_CODE_ASSIGNMENTS HzCodeAssignmentBankEO
6611: WHERE HzPartyBankEO.ORGANIZATION_NAME_PHONETIC = Xi_BANK_NAME_ALT
6612: AND HzOrgProfileBankEO.home_country = Xi_COUNTRY_NAME -- 8552410: Changed HzPartyBankEO to HzOrgProfileBankEO
6613: AND HzPartyBankEO.PARTY_TYPE = 'ORGANIZATION'
6614: AND HzPartyBankEO.status = 'A'