APPS.PN_VAR_TRX_PKG dependencies on PN_VAR_BKPTS_DET_ALL

Line 2223: FROM pn_var_bkpts_det_all

2219: WHERE
2220: line.period_id = p_prd_id AND
2221: line.bkpt_update_flag = 'Y' AND
2222: EXISTS (SELECT null
2223: FROM pn_var_bkpts_det_all
2224: WHERE bkpt_header_id IN ( SELECT bkpt_header_id
2225: FROM pn_var_bkpts_head_all
2226: WHERE line_item_id = line.line_item_id))
2227: ORDER BY

Line 2242: FROM pn_var_bkpts_det_all bpd

2238: line.period_id = p_prd_id AND
2239: line.bkpt_update_flag = 'Y' AND
2240: bph.period_id = line.period_id AND
2241: EXISTS (SELECT null
2242: FROM pn_var_bkpts_det_all bpd
2243: WHERE bpd.bkpt_header_id = bph.bkpt_header_id
2244: AND rownum = 1)
2245: order BY line_item_id;
2246:

Line 2260: ,pn_var_bkpts_det_all bkpt

2256: ,bkpt.period_bkpt_vol_end
2257: ,bkpt.bkpt_rate
2258: FROM
2259: pn_var_bkpts_head_all head
2260: ,pn_var_bkpts_det_all bkpt
2261: WHERE
2262: head.line_item_id = p_line_item_id AND
2263: bkpt.bkpt_header_id = head.bkpt_header_id
2264: ORDER BY