APPS.JE_ES_MODELO_EXT_PKG dependencies on HR_LOCATIONS

Line 69: , hr_locations HL

65: LPAD(SUBSTR(HL.address_line_3,1,length(HL.address_line_3) -
66: NVL(LENGTH(LTRIM(TRANSLATE(HL.address_line_3, '123456789','000000000'),'0')),0)),5,'0') address_detail
67: FROM hz_cust_acct_sites_all HCAS
68: , hz_party_sites HPS
69: , hr_locations HL
70: , fnd_territories FT
71: , hz_cust_site_uses_all HCSU
72: WHERE HCAS.cust_acct_site_id = p_customer_address_id
73: AND HPS.party_site_id = HCAS.party_site_id

Line 163: , hr_locations HL

159: FROM jg_zz_vat_rep_status JZVRS
160: , jg_zz_vat_trx_details JZVTD
161: , hz_cust_acct_sites_all HCAS
162: , hz_party_sites HPS
163: , hr_locations HL
164: , fnd_territories FT
165: , hz_cust_site_uses_all HCSU
166: WHERE JZVRS.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID
167: AND JZVRS.reporting_status_id = JZVTD.reporting_status_id

Line 956: lc_country hr_locations.country%TYPE;

952: --
953: lc_taxpayer_id jg_zz_vat_trx_details.billing_tp_taxpayer_id%TYPE;
954: lc_company_name xle_registrations.registered_name%TYPE;
955: lc_registration_number xle_registrations.registration_number%TYPE;
956: lc_country hr_locations.country%TYPE;
957: lc_address1 hr_locations.address_line_1%TYPE;
958: lc_address2 hr_locations.address_line_2%TYPE;
959: lc_address3 hr_locations.address_line_3%TYPE;
960: lc_address4 hz_locations.address4%TYPE;

Line 957: lc_address1 hr_locations.address_line_1%TYPE;

953: lc_taxpayer_id jg_zz_vat_trx_details.billing_tp_taxpayer_id%TYPE;
954: lc_company_name xle_registrations.registered_name%TYPE;
955: lc_registration_number xle_registrations.registration_number%TYPE;
956: lc_country hr_locations.country%TYPE;
957: lc_address1 hr_locations.address_line_1%TYPE;
958: lc_address2 hr_locations.address_line_2%TYPE;
959: lc_address3 hr_locations.address_line_3%TYPE;
960: lc_address4 hz_locations.address4%TYPE;
961: lc_city hr_locations.town_or_city%TYPE;

Line 958: lc_address2 hr_locations.address_line_2%TYPE;

954: lc_company_name xle_registrations.registered_name%TYPE;
955: lc_registration_number xle_registrations.registration_number%TYPE;
956: lc_country hr_locations.country%TYPE;
957: lc_address1 hr_locations.address_line_1%TYPE;
958: lc_address2 hr_locations.address_line_2%TYPE;
959: lc_address3 hr_locations.address_line_3%TYPE;
960: lc_address4 hz_locations.address4%TYPE;
961: lc_city hr_locations.town_or_city%TYPE;
962: lc_postal_code hr_locations.postal_code%TYPE;

Line 959: lc_address3 hr_locations.address_line_3%TYPE;

955: lc_registration_number xle_registrations.registration_number%TYPE;
956: lc_country hr_locations.country%TYPE;
957: lc_address1 hr_locations.address_line_1%TYPE;
958: lc_address2 hr_locations.address_line_2%TYPE;
959: lc_address3 hr_locations.address_line_3%TYPE;
960: lc_address4 hz_locations.address4%TYPE;
961: lc_city hr_locations.town_or_city%TYPE;
962: lc_postal_code hr_locations.postal_code%TYPE;
963: lc_contact hz_parties.party_name%TYPE;

Line 961: lc_city hr_locations.town_or_city%TYPE;

957: lc_address1 hr_locations.address_line_1%TYPE;
958: lc_address2 hr_locations.address_line_2%TYPE;
959: lc_address3 hr_locations.address_line_3%TYPE;
960: lc_address4 hz_locations.address4%TYPE;
961: lc_city hr_locations.town_or_city%TYPE;
962: lc_postal_code hr_locations.postal_code%TYPE;
963: lc_contact hz_parties.party_name%TYPE;
964: lc_phone_number hz_contact_points.phone_number%TYPE;
965: -- Added for Glob-006 ER

Line 962: lc_postal_code hr_locations.postal_code%TYPE;

958: lc_address2 hr_locations.address_line_2%TYPE;
959: lc_address3 hr_locations.address_line_3%TYPE;
960: lc_address4 hz_locations.address4%TYPE;
961: lc_city hr_locations.town_or_city%TYPE;
962: lc_postal_code hr_locations.postal_code%TYPE;
963: lc_contact hz_parties.party_name%TYPE;
964: lc_phone_number hz_contact_points.phone_number%TYPE;
965: -- Added for Glob-006 ER
966: l_province VARCHAR2(120);