eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PN_VAR_NATURAL_BP_PKG dependencies on PN_VAR_BKDT_DEFAULTS_ALL

Line 74: FROM pn_var_bkdt_defaults_all

70: p_bkhd_def_end_date IN DATE,
71: p_bkhd_def_rate IN NUMBER)
72: IS
73: SELECT NVL(bkpt_rate,p_bkhd_def_rate) bkpt_rate
74: FROM pn_var_bkdt_defaults_all
75: WHERE bkhd_default_id = p_bkhd_def_id
76: AND p_bkhd_def_st_date <= bkdt_end_date
77: AND p_bkhd_def_end_date >= bkdt_start_date;
78:

Line 165: DELETE FROM PN_VAR_BKDT_DEFAULTS_ALL

161: AND bkpt_header_id IN (SELECT bkpt_header_id
162: FROM pn_var_bkpts_head_all
163: WHERE bkhd_default_id = l_head_dflt_id);
164:
165: DELETE FROM PN_VAR_BKDT_DEFAULTS_ALL
166: WHERE bkhd_default_id = l_head_dflt_id;
167:
168: DELETE FROM pn_var_bkpts_head_all
169: WHERE bkhd_default_id = l_head_dflt_id;

Line 374: FROM pn_var_bkdt_defaults_all

370: SELECT p_bkhd_start_date start_date
371: FROM DUAL
372: UNION
373: SELECT distinct bkdt_start_date start_date
374: FROM pn_var_bkdt_defaults_all
375: WHERE bkhd_default_id = p_bkhd_def_id
376: AND bkpt_rate <> p_bkpt_rate
377: UNION
378: SELECT distinct (bkdt_end_date +1) start_date

Line 379: FROM pn_var_bkdt_defaults_all

375: WHERE bkhd_default_id = p_bkhd_def_id
376: AND bkpt_rate <> p_bkpt_rate
377: UNION
378: SELECT distinct (bkdt_end_date +1) start_date
379: FROM pn_var_bkdt_defaults_all
380: WHERE bkhd_default_id = p_bkhd_def_id
381: AND bkpt_rate <> p_bkpt_rate
382: )
383: WHERE start_date <= p_bkhd_end_date