DBA Data[Home] [Help]

APPS.CE_VALIDATE_BANKINFO dependencies on HZ_RELATIONSHIPS

Line 596: HZ_RELATIONSHIPS BRRel,

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'
600: AND BankParty.status = 'A'

Line 674: HZ_RELATIONSHIPS BRRel,

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'
678: AND BankParty.status = 'A'

Line 750: HZ_RELATIONSHIPS BRRel,

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'
754: AND BankParty.status = 'A'

Line 6490: HZ_RELATIONSHIPS BRRel,

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'
6494: AND BankParty.status = 'A'