APPS.PN_VARIABLE_AMOUNT_PKG dependencies on PN_VAR_LINES_ALL

Line 245: pn_var_lines_all lines

241: SELECT lines.line_item_num,
242: lines.period_id,
243: lines.line_item_id
244: FROM pn_var_periods_all per,
245: pn_var_lines_all lines
246: WHERE lines.period_id= per.period_id
247: AND per.var_rent_id = p_var_rent_id
248: AND per.period_id = p_period_id
249: AND lines.line_item_id = NVL(ip_line_item_id,lines.line_item_id);

Line 2000: FROM pn_var_lines_all lines,

1996: FROM pn_var_rent_summ_all summ,
1997: (SELECT gd.period_id,
1998: lines.line_item_id,
1999: gd.grp_date_id
2000: FROM pn_var_lines_all lines,
2001: pn_var_grp_dates_all gd
2002: WHERE gd.period_id = lines.period_id
2003: AND gd.period_id= p_period_id
2004: AND gd.invoice_date =p_invoice_date) itemp