APPS.JL_JLCOARCR_XMLP_PKG dependencies on XLE_FIRSTPARTY_INFORMATION_V

Line 46: XLE_FIRSTPARTY_INFORMATION_V LE

42: LE.ADDRESS_LINE_3
43: INTO COMPANY_NAME,NIT_NUMBER,VADDRESS1,VADDRESS2,VADDRESS3
44: FROM
45: HR_LOCATIONS HR,
46: XLE_FIRSTPARTY_INFORMATION_V LE
47: WHERE HR.LOCATION_ID = LE.LOCATION_ID
48: AND LE.LEGAL_ENTITY_ID = P_LEGAL_ENTITY_ID;
49: EXCEPTION
50: WHEN OTHERS THEN

Line 64: XLE_FIRSTPARTY_INFORMATION_V LE

60: INTO VTOWN_CITY
61: FROM
62: HZ_GEOGRAPHIES GEO,
63: HR_LOCATIONS HL,
64: XLE_FIRSTPARTY_INFORMATION_V LE
65: WHERE GEO.GEOGRAPHY_NAME = HL.TOWN_OR_CITY
66: AND GEO.GEOGRAPHY_TYPE = 'CITY'
67: AND GEO.COUNTRY_CODE = HL.COUNTRY
68: AND GEO.GEOGRAPHY_ELEMENT2_CODE = HL.REGION_2

Line 82: XLE_FIRSTPARTY_INFORMATION_V LE

78: INTO VREGION
79: FROM
80: HZ_GEOGRAPHIES GEO,
81: HR_LOCATIONS HRL,
82: XLE_FIRSTPARTY_INFORMATION_V LE
83: WHERE LE.LEGAL_ENTITY_ID = P_LEGAL_ENTITY_ID
84: AND LE.LOCATION_ID = HRL.LOCATION_ID
85: AND GEO.GEOGRAPHY_CODE = HRL.REGION_2
86: AND GEO.GEOGRAPHY_TYPE = 'PROVINCE'