APPS.JE_ES_WHTAX dependencies on XLE_FIRSTPARTY_INFORMATION_V

Line 27: from XLE_FIRSTPARTY_INFORMATION_V

23: end if;
24: if p_legal_entity_name is NOT NULL then
25: select legal_entity_id
26: into current_legal_entity_id
27: from XLE_FIRSTPARTY_INFORMATION_V
28: where upper(name) = upper(p_legal_entity_name);
29: If (SQL%NOTFOUND) then
30: RAISE bad_legal_entity;
31: else

Line 143: from XLE_FIRSTPARTY_INFORMATION_V

139: end if;
140: if (p_legal_entity_name is NOT NULL) then
141: select legal_entity_id
142: into current_legal_entity_id
143: from XLE_FIRSTPARTY_INFORMATION_V
144: where upper(name) = upper(p_legal_entity_name);
145: If (SQL%NOTFOUND) then
146: RAISE bad_legal_name;
147: end if;

Line 306: from XLE_FIRSTPARTY_INFORMATION_V

302: end if;
303: if (p_legal_entity_name is NOT NULL) then
304: select legal_entity_id
305: into current_legal_entity_id
306: from XLE_FIRSTPARTY_INFORMATION_V
307: where upper(name) = upper(p_legal_entity_name);
308: If (SQL%NOTFOUND) then
309: RAISE bad_legal_name;
310: end if;