DBA Data[Home] [Help]

APPS.PN_VAR_TRX_PKG dependencies on PN_VAR_BKPTS_HEAD_ALL

Line 2225: FROM pn_var_bkpts_head_all

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
2228: line_item_id;*/
2229:

Line 2236: pn_var_bkpts_head_all bph

2232: line.line_item_id
2233: ,line.line_default_id
2234: FROM
2235: pn_var_lines_all line,
2236: pn_var_bkpts_head_all bph
2237: WHERE
2238: line.period_id = p_prd_id AND
2239: line.bkpt_update_flag = 'Y' AND
2240: bph.period_id = line.period_id AND

Line 2259: pn_var_bkpts_head_all head

2255: ,bkpt.period_bkpt_vol_start
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