APPS.JG_ZZ_SUMMARY_ALL_PKG dependencies on XLE_LEGALAUTH_V

Line 160: , xle_legalauth_v xle_auth

156: SELECT xle_auth.city tax_office_location
157: ,xle_auth.address3 tax_office_code
158: FROM XLE_FIRSTPARTY_INFORMATION_V xfpiv
159: , xle_registrations xle_reg
160: , xle_legalauth_v xle_auth
161: WHERE xle_reg.source_id = xfpiv.legal_entity_id
162: AND xle_reg.source_table = 'XLE_ENTITY_PROFILES'
163: AND xle_auth.legalauth_id (+) = xle_reg.issuing_authority_id
164: AND xle_reg.identifying_flag = 'Y'

Line 216: l_tax_office_location xle_legalauth_v.city%TYPE;

212: l_tax_registration_num VARCHAR2 (240);
213: l_tax_regime VARCHAR2(240);
214: l_activity_code VARCHAR2(240);
215: l_vat_register_name VARCHAR2(500);
216: l_tax_office_location xle_legalauth_v.city%TYPE;
217: l_tax_office_code xle_legalauth_v.address3%TYPE;
218: l_precision NUMBER;
219: -- Added for Glob-006 ER
220: l_province VARCHAR2(120);

Line 217: l_tax_office_code xle_legalauth_v.address3%TYPE;

213: l_tax_regime VARCHAR2(240);
214: l_activity_code VARCHAR2(240);
215: l_vat_register_name VARCHAR2(500);
216: l_tax_office_location xle_legalauth_v.city%TYPE;
217: l_tax_office_code xle_legalauth_v.address3%TYPE;
218: l_precision NUMBER;
219: -- Added for Glob-006 ER
220: l_province VARCHAR2(120);
221: l_comm_num VARCHAR2(30);