DBA Data[Home] [Help]

APPS.CE_BANK_AND_ACCOUNT_VALIDATION dependencies on HZ_CODE_ASSIGNMENTS

Line 112: hz_code_assignments BankCA

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'
115: AND BankParty.PARTY_ID = BankOrgProfile.PARTY_ID
116: AND SYSDATE between TRUNC(BankOrgProfile.effective_start_date)