DBA Data[Home] [Help]

APPS.JG_ZZ_SUMMARY_AP_PKG dependencies on HZ_LOCATIONS

Line 181: l_country hz_locations.country%TYPE;

177: l_legal_entity_id NUMBER;
178: l_taxpayer_id jg_zz_vat_trx_details.taxpayer_id%TYPE;
179: l_company_name xle_registrations.registered_name%TYPE;
180: l_registration_number xle_registrations.registration_number%TYPE;
181: l_country hz_locations.country%TYPE;
182: l_address1 hz_locations.address1%TYPE;
183: l_address2 hz_locations.address2%TYPE;
184: l_address3 hz_locations.address3%TYPE;
185: l_address4 hz_locations.address4%TYPE;

Line 182: l_address1 hz_locations.address1%TYPE;

178: l_taxpayer_id jg_zz_vat_trx_details.taxpayer_id%TYPE;
179: l_company_name xle_registrations.registered_name%TYPE;
180: l_registration_number xle_registrations.registration_number%TYPE;
181: l_country hz_locations.country%TYPE;
182: l_address1 hz_locations.address1%TYPE;
183: l_address2 hz_locations.address2%TYPE;
184: l_address3 hz_locations.address3%TYPE;
185: l_address4 hz_locations.address4%TYPE;
186: l_city hz_locations.city%TYPE;

Line 183: l_address2 hz_locations.address2%TYPE;

179: l_company_name xle_registrations.registered_name%TYPE;
180: l_registration_number xle_registrations.registration_number%TYPE;
181: l_country hz_locations.country%TYPE;
182: l_address1 hz_locations.address1%TYPE;
183: l_address2 hz_locations.address2%TYPE;
184: l_address3 hz_locations.address3%TYPE;
185: l_address4 hz_locations.address4%TYPE;
186: l_city hz_locations.city%TYPE;
187: l_postal_code hz_locations.postal_code%TYPE;

Line 184: l_address3 hz_locations.address3%TYPE;

180: l_registration_number xle_registrations.registration_number%TYPE;
181: l_country hz_locations.country%TYPE;
182: l_address1 hz_locations.address1%TYPE;
183: l_address2 hz_locations.address2%TYPE;
184: l_address3 hz_locations.address3%TYPE;
185: l_address4 hz_locations.address4%TYPE;
186: l_city hz_locations.city%TYPE;
187: l_postal_code hz_locations.postal_code%TYPE;
188: l_contact hz_parties.party_name%TYPE;

Line 185: l_address4 hz_locations.address4%TYPE;

181: l_country hz_locations.country%TYPE;
182: l_address1 hz_locations.address1%TYPE;
183: l_address2 hz_locations.address2%TYPE;
184: l_address3 hz_locations.address3%TYPE;
185: l_address4 hz_locations.address4%TYPE;
186: l_city hz_locations.city%TYPE;
187: l_postal_code hz_locations.postal_code%TYPE;
188: l_contact hz_parties.party_name%TYPE;
189: l_phone_number hz_contact_points.phone_number%TYPE;

Line 186: l_city hz_locations.city%TYPE;

182: l_address1 hz_locations.address1%TYPE;
183: l_address2 hz_locations.address2%TYPE;
184: l_address3 hz_locations.address3%TYPE;
185: l_address4 hz_locations.address4%TYPE;
186: l_city hz_locations.city%TYPE;
187: l_postal_code hz_locations.postal_code%TYPE;
188: l_contact hz_parties.party_name%TYPE;
189: l_phone_number hz_contact_points.phone_number%TYPE;
190: l_tax_registration_num VARCHAR2 (240);

Line 187: l_postal_code hz_locations.postal_code%TYPE;

183: l_address2 hz_locations.address2%TYPE;
184: l_address3 hz_locations.address3%TYPE;
185: l_address4 hz_locations.address4%TYPE;
186: l_city hz_locations.city%TYPE;
187: l_postal_code hz_locations.postal_code%TYPE;
188: l_contact hz_parties.party_name%TYPE;
189: l_phone_number hz_contact_points.phone_number%TYPE;
190: l_tax_registration_num VARCHAR2 (240);
191: l_period_end_date DATE;