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_ORGANIZATION_PROFILES

Line 11: HZ_ORGANIZATION_PROFILES OrgProfileBank,

7:
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'

Line 190: HZ_ORGANIZATION_PROFILES OrgProfileBank,

186: ELSE
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'

Line 594: HZ_ORGANIZATION_PROFILES BankOrgProfile,

590: -- unique combination -> bank_id, branch_name, country --confirmed sql 6/25/02
591: SELECT COUNT(*) INTO temp_name
592: FROM HZ_PARTIES BankParty,
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

Line 595: HZ_ORGANIZATION_PROFILES BranchOrgProfile,

591: SELECT COUNT(*) INTO temp_name
592: FROM HZ_PARTIES BankParty,
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'

Line 672: HZ_ORGANIZATION_PROFILES BankOrgProfile,

668:
669: SELECT COUNT(*) INTO temp_number
670: FROM HZ_PARTIES BankParty,
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

Line 673: HZ_ORGANIZATION_PROFILES BranchOrgProfile,

669: SELECT COUNT(*) INTO temp_number
670: FROM HZ_PARTIES BankParty,
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'

Line 748: HZ_ORGANIZATION_PROFILES BankOrgProfile,

744:
745: SELECT COUNT(*) INTO temp_name_alt
746: FROM HZ_PARTIES BankParty,
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

Line 749: HZ_ORGANIZATION_PROFILES BranchOrgProfile,

745: SELECT COUNT(*) INTO temp_name_alt
746: FROM HZ_PARTIES BankParty,
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'

Line 6488: HZ_ORGANIZATION_PROFILES BankOrgProfile,

6484: SELECT COUNT(*)
6485: INTO l_temp_number
6486: FROM HZ_PARTIES BankParty,
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

Line 6489: HZ_ORGANIZATION_PROFILES BranchOrgProfile,

6485: INTO l_temp_number
6486: FROM HZ_PARTIES BankParty,
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'

Line 6609: HZ_ORGANIZATION_PROFILES HzOrgProfileBankEO,

6605: -- unique combination -> bank_name_alt, country bug 2363959 --confirmed sql 6/28/02
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'