APPS.CE_BANK_AND_ACCOUNT_VALIDATION dependencies on HZ_CODE_ASSIGNMENTS

Line 104: hz_code_assignments BankCA

100: CURSOR c_bank_name_number_uk IS
101: SELECT 'Y'
102: FROM hz_parties BankParty,
103: hz_organization_profiles BankOrgProfile,
104: hz_code_assignments BankCA
105: WHERE BankParty.PARTY_TYPE = 'ORGANIZATION'
106: AND BankParty.status = 'A'
107: AND BankParty.PARTY_ID = BankOrgProfile.PARTY_ID
108: AND SYSDATE between TRUNC(BankOrgProfile.effective_start_date)

Line 129: hz_code_assignments BankCA,

125: */
126: /* CURSOR c_bank_name_uk IS
127: SELECT 'Y'
128: FROM hz_parties BankParty,
129: hz_code_assignments BankCA,
130: hz_organization_profiles BankOrgProfile
131: WHERE BankParty.PARTY_TYPE = 'ORGANIZATION'
132: AND BankParty.status = 'A'
133: AND BankParty.PARTY_ID = BankOrgProfile.PARTY_ID

Line 148: hz_code_assignments BankCA,

144: /*
145: CURSOR c_short_name_uk IS
146: SELECT 'Y'
147: FROM hz_parties BankParty,
148: hz_code_assignments BankCA,
149: hz_organization_profiles BankOrgProfile
150: WHERE BankParty.PARTY_TYPE = 'ORGANIZATION'
151: AND BankParty.status = 'A'
152: AND BankParty.PARTY_ID = BankOrgProfile.PARTY_ID

Line 168: hz_code_assignments BankCA

164: /* CURSOR c_bank_number_uk IS
165: SELECT 'Y'
166: FROM hz_parties BankParty,
167: hz_organization_profiles BankOrgProfile,
168: hz_code_assignments BankCA
169: WHERE BankParty.PARTY_TYPE = 'ORGANIZATION'
170: AND BankParty.status = 'A'
171: AND BankParty.PARTY_ID = BankOrgProfile.PARTY_ID
172: AND SYSDATE between TRUNC(BankOrgProfile.effective_start_date)