APPS.PN_VAR_UPG_TRX_PKG dependencies on PN_VAR_RENT_SUMM_ALL

Line 164: FROM pn_var_trx_headers_all trx, pn_var_rent_summ_all summ

160: /* Fetch the summary id and transaction id from respective tables */
161: CURSOR summ_id_cur (p_var_rent_id NUMBER) IS
162: SELECT /*+ leading(trx) */
163: summ.var_rent_summ_id, trx.trx_header_id
164: FROM pn_var_trx_headers_all trx, pn_var_rent_summ_all summ
165: WHERE trx.grp_date_id = summ.grp_date_id
166: AND trx.var_rent_id = p_var_rent_id;
167:
168: TYPE summ_id_tab_type IS TABLE OF pn_var_trx_headers_all.var_rent_summ_id%TYPE