APPS.CE_BANK_AND_ACCOUNT_VALIDATION dependencies on HZ_BANK_VAL_GT

Line 90: /* records in HZ_BANK_VAL_GT and hz_org_profile_val_gt share the same temp_id */

86: l_short_name VARCHAR2(240) := NULL;
87: l_short_name_null VARCHAR2(1) := 'N';
88: l_bank_number VARCHAR2(60) := NULL;
89:
90: /* records in HZ_BANK_VAL_GT and hz_org_profile_val_gt share the same temp_id */
91:
92: CURSOR c_country IS
93: SELECT country
94: FROM HZ_BANK_VAL_GT

Line 94: FROM HZ_BANK_VAL_GT

90: /* records in HZ_BANK_VAL_GT and hz_org_profile_val_gt share the same temp_id */
91:
92: CURSOR c_country IS
93: SELECT country
94: FROM HZ_BANK_VAL_GT
95: WHERE temp_id = p_temp_id;
96:
97: CURSOR c_bank_number IS
98: SELECT bank_or_branch_number

Line 99: FROM HZ_BANK_VAL_GT

95: WHERE temp_id = p_temp_id;
96:
97: CURSOR c_bank_number IS
98: SELECT bank_or_branch_number
99: FROM HZ_BANK_VAL_GT
100: WHERE temp_id = p_temp_id;
101:
102: CURSOR c_bank_name IS
103: SELECT organization_name

Line 137: -- found in the temp table HZ_BANK_VAL_GT.

133: FETCH c_country INTO l_country;
134:
135: IF c_country%NOTFOUND THEN
136: -- Close the cursor and raise an error if the country could not be
137: -- found in the temp table HZ_BANK_VAL_GT.
138: CLOSE c_country;
139:
140: fnd_message.set_name('CE', 'CE_TEMP_NOT_FOUND');
141: fnd_message.set_token('COLUMN', 'Country');

Line 142: fnd_message.set_token('TABLE', 'HZ_BANK_VAL_GT');

138: CLOSE c_country;
139:
140: fnd_message.set_name('CE', 'CE_TEMP_NOT_FOUND');
141: fnd_message.set_token('COLUMN', 'Country');
142: fnd_message.set_token('TABLE', 'HZ_BANK_VAL_GT');
143: fnd_msg_pub.add;
144: RAISE NO_DATA_FOUND;
145: END IF;
146: CLOSE c_country;