APPS.PN_VAREN_PVT dependencies on PN_VAR_BKDT_DEFAULTS_ALL

Line 421: FROM pn_var_bkdt_defaults_all pvbd

417: CURSOR c_brkpt_dtl_created
418: IS
419: SELECT COUNT (*)
420: -- ,bkdt_default_id
421: FROM pn_var_bkdt_defaults_all pvbd
422: WHERE pvbd.var_rent_id = p_var_rent_id;
423: -- AND ( pvbd.bkdt_default_id = p_bkdt_default_id
424: -- OR pvbd.bkdt_detail_num = bkdt_detail_num
425: -- )

Line 5337: FROM pn_var_bkdt_defaults_all

5333: l_date_range_bkdt_count :=0;
5334: BEGIN
5335: SELECT COUNT(1)
5336: INTO l_date_range_bkdt_count
5337: FROM pn_var_bkdt_defaults_all
5338: WHERE var_rent_id = p_variable_rent_lines_tbl (i).var_rent_id
5339: AND bkhd_default_id = p_breakpoint_header_tbl (j).bkhd_default_id
5340: AND (bkdt_start_date <= p_breakpoint_details_tbl (k).bkdt_end_date AND bkdt_end_date >= p_breakpoint_details_tbl (k).bkdt_start_date);
5341: EXCEPTION

Line 10271: DELETE FROM pn_var_bkdt_defaults_all

10267:
10268: DELETE FROM pn_var_abat_defaults_all
10269: WHERE var_rent_id = l_varentid;
10270:
10271: DELETE FROM pn_var_bkdt_defaults_all
10272: WHERE var_rent_id = l_varentid;
10273:
10274: DELETE pn_var_bkhd_defaults_all
10275: WHERE var_rent_id = l_varentid;

Line 10756: FROM pn_var_bkdt_defaults_all

10752: , attribute13
10753: , attribute14
10754: , attribute15
10755: , org_id
10756: FROM pn_var_bkdt_defaults_all
10757: WHERE bkdt_default_id = p_bkdt_default_id
10758: AND var_rent_id = p_var_rent_id;
10759:
10760: CURSOR c_pn_var_constraints (

Line 15070: FROM pn_var_bkdt_defaults_all

15066: l_date_range_bkdt_count :=0;
15067: BEGIN
15068: SELECT COUNT(1)
15069: INTO l_date_range_bkdt_count
15070: FROM pn_var_bkdt_defaults_all
15071: WHERE var_rent_id = p_breakpoint_details_tbl (ubd).var_rent_id
15072: AND bkdt_default_id<>p_breakpoint_details_tbl (ubd).bkdt_default_id
15073: AND bkhd_default_id =p_breakpoint_details_tbl (ubd).bkhd_default_id
15074: AND (bkdt_start_date <=p_breakpoint_details_tbl (ubd).bkdt_end_date AND bkdt_end_date >= p_breakpoint_details_tbl (ubd).bkdt_start_date);