APPS.JE_ES_MODELO_EXT_PKG dependencies on HZ_PARTIES

Line 558: ,hz_parties HP

554: FROM jg_zz_vat_trx_details JZVTD
555: ,jg_zz_vat_rep_status JZVRS
556: ,ap_invoice_distributions AID
557: ,ap_invoice_distributions PRE
558: ,hz_parties HP
559: WHERE JZVRS.reporting_status_id = JZVTD.reporting_status_id
560: AND JZVTD.billing_trading_partner_id = p_vendor_id
561: AND JZVTD.trx_type_mng = 'PREPAYMENT'
562: --AND JZVTD.posted_flag IN ('P','Y') /** author:brathod; Removed posted_flag checking as it is not relevent in R12 */

Line 963: lc_contact hz_parties.party_name%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);
967: l_comm_num VARCHAR2(30);