DBA Data[Home] [Help]

APPS.PN_VAR_NATURAL_BP_PKG dependencies on PN_VAR_BKHD_DEFAULTS_ALL

Line 64: FROM pn_var_bkhd_defaults_all

60:
61: CURSOR process_all_defaults_cur
62: IS
63: SELECT bkhd_default_id, natural_break_rate
64: FROM pn_var_bkhd_defaults_all
65: WHERE var_rent_id = p_var_rent_id
66: AND break_type = 'NATURAL';
67:
68: CURSOR detail_rate_cur (p_bkhd_def_id IN NUMBER,

Line 91: from pn_var_bkhd_defaults_all

87: CURSOR line_cur(p_bkhd_default_id IN NUMBER) IS
88: select line_item_id
89: from pn_var_lines_all
90: where line_default_id IN (select line_default_id
91: from pn_var_bkhd_defaults_all
92: where bkhd_default_id = p_bkhd_default_id);
93:
94:
95: BEGIN

Line 318: FROM pn_var_bkhd_defaults_all

314: SELECT bkhd_start_date,
315: bkhd_end_date,
316: bkhd_default_id,
317: natural_break_rate
318: FROM pn_var_bkhd_defaults_all
319: WHERE bkhd_default_id = p_head_dflt_id
320: AND break_type = 'NATURAL'
321: ORDER BY bkhd_start_date;
322: