APPS.JG_ZZ_SUMMARY_ALL_PKG dependencies on XLE_LEGALAUTH_V

Line 132: , xle_legalauth_v xle_auth

128: SELECT xle_auth.city tax_office_location
129: ,xle_auth.address3 tax_office_code
130: FROM XLE_FIRSTPARTY_INFORMATION_V xfpiv
131: , xle_registrations xle_reg
132: , xle_legalauth_v xle_auth
133: WHERE xle_reg.source_id = xfpiv.legal_entity_id
134: AND xle_reg.source_table = 'XLE_ENTITY_PROFILES'
135: AND xle_auth.legalauth_id (+) = xle_reg.issuing_authority_id
136: AND xle_reg.identifying_flag = 'Y'

Line 162: l_tax_office_location xle_legalauth_v.city%TYPE;

158: l_tax_registration_num VARCHAR2 (240);
159: l_tax_regime VARCHAR2(240);
160: l_activity_code VARCHAR2(240);
161: l_vat_register_name VARCHAR2(500);
162: l_tax_office_location xle_legalauth_v.city%TYPE;
163: l_tax_office_code xle_legalauth_v.address3%TYPE;
164: l_precision NUMBER;
165: -- Added for Glob-006 ER
166: l_province VARCHAR2(120);

Line 163: l_tax_office_code xle_legalauth_v.address3%TYPE;

159: l_tax_regime VARCHAR2(240);
160: l_activity_code VARCHAR2(240);
161: l_vat_register_name VARCHAR2(500);
162: l_tax_office_location xle_legalauth_v.city%TYPE;
163: l_tax_office_code xle_legalauth_v.address3%TYPE;
164: l_precision NUMBER;
165: -- Added for Glob-006 ER
166: l_province VARCHAR2(120);
167: l_comm_num VARCHAR2(30);