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 17: HZ_ORGANIZATION_PROFILES OrgProfileBank,

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

Line 163: HZ_ORGANIZATION_PROFILES OrgProfileBank,

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

Line 671: HZ_ORGANIZATION_PROFILES BankOrgProfile,

667:
668: select count(*) into temp_name
669: From HZ_PARTIES BankParty,
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

Line 672: HZ_ORGANIZATION_PROFILES BranchOrgProfile,

668: select count(*) into temp_name
669: From HZ_PARTIES BankParty,
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'

Line 754: HZ_ORGANIZATION_PROFILES BankOrgProfile,

750:
751: select count(*) into temp_number
752: From HZ_PARTIES BankParty,
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

Line 755: HZ_ORGANIZATION_PROFILES BranchOrgProfile,

751: select count(*) into temp_number
752: From HZ_PARTIES BankParty,
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'

Line 839: HZ_ORGANIZATION_PROFILES BankOrgProfile,

835:
836: select count(*) into temp_name_alt
837: From HZ_PARTIES BankParty,
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

Line 840: HZ_ORGANIZATION_PROFILES BranchOrgProfile,

836: select count(*) into temp_name_alt
837: From HZ_PARTIES BankParty,
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'

Line 7581: HZ_ORGANIZATION_PROFILES HzOrgProfileBankEO,

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