DBA Data[Home] [Help]

APPS.JE_JEITXLRG_XMLP_PKG dependencies on XLE_FIRSTPARTY_INFORMATION_V

Line 139: XLE_FIRSTPARTY_INFORMATION_V XFIV

135: XFIV.POSTAL_CODE || ' ' || XFIV.TOWN_OR_CITY CODE_CITY,
136: XFIV.COUNTRY COUNTRY
137: INTO P_ADDRESS1,P_ADDRESS2,P_ADDRESS3,P_CODE_CITY,P_COUNTRY
138: FROM
139: XLE_FIRSTPARTY_INFORMATION_V XFIV
140: WHERE XFIV.LEGAL_ENTITY_ID = P_LEGAL_ENTITY_ID;
141: C_ADDRESS1 := P_ADDRESS1 || ' ' || P_ADDRESS2 || ' ' || P_ADDRESS3;
142: C_POSTAL_CODE_CITY := P_CODE_CITY;
143: C_COUNTRY := P_COUNTRY;