DBA Data[Home] [Help]

APPS.CE_VALIDATE_BANKINFO dependencies on HZ_RELATIONSHIPS

Line 673: HZ_RELATIONSHIPS BRRel,

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'
677: And BankParty.status = 'A'

Line 756: HZ_RELATIONSHIPS BRRel,

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'
760: And BankParty.status = 'A'

Line 841: HZ_RELATIONSHIPS BRRel,

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'
845: And BankParty.status = 'A'