APPS.CE_BANK_AND_ACCOUNT_VALIDATION dependencies on HZ_PARTIES

Line 110: FROM hz_parties BankParty,

106:
107: -- Cursor to check for duplicate of combination of name-number-country.
108: CURSOR c_bank_name_number_uk IS
109: SELECT 'Y'
110: FROM hz_parties BankParty,
111: hz_organization_profiles BankOrgProfile,
112: hz_code_assignments BankCA
113: WHERE BankParty.PARTY_TYPE = 'ORGANIZATION'
114: AND BankParty.status = 'A'

Line 120: AND BankCA.OWNER_TABLE_NAME = 'HZ_PARTIES'

116: AND SYSDATE between TRUNC(BankOrgProfile.effective_start_date)
117: and NVL(TRUNC(BankOrgProfile.effective_end_date), SYSDATE+1)
118: AND BankCA.CLASS_CATEGORY = 'BANK_INSTITUTION_TYPE'
119: AND BankCA.CLASS_CODE = 'BANK'
120: AND BankCA.OWNER_TABLE_NAME = 'HZ_PARTIES'
121: AND NVL(BankCA.STATUS, 'A') = 'A'
122: AND BankCA.OWNER_TABLE_ID = BankParty.PARTY_ID
123: AND BankOrgProfile.home_country = l_country
124: AND nvl(BankOrgProfile.bank_or_branch_number,'--NULL--') = nvl(l_bank_number,'--NULL--')