APPS.PN_VAREN_PVT dependencies on PN_VAR_GRP_DATES_ALL

Line 2205: FROM pn_var_grp_dates_all

2201: SELECT 'x'
2202: INTO l_exist
2203: FROM dual
2204: WHERE EXISTS (SELECT inv_end_date
2205: FROM pn_var_grp_dates_all
2206: WHERE var_rent_id = l_var_rent_id
2207: AND inv_end_date = p_allow_abat_tbl_type (b).abat_end_date
2208: );
2209: EXCEPTION

Line 2687: -- Comparing const_start_date is greater than const_end_date and also whether records exists in pn_var_grp_dates_all or not

2683: -- End
2684: ---------
2685: l_variable_rent_exists := NULL;
2686: ----------------------------------------------------------------------------------------------------------------------------
2687: -- Comparing const_start_date is greater than const_end_date and also whether records exists in pn_var_grp_dates_all or not
2688: ----------------------------------------------------------------------------------------------------------------------------
2689: -- BEGIN -- to capture exceptions related to individual validations
2690: --
2691: pn_varen_util.pvt_debug ( 'PN_VAREN_PVT: Val_Ins_Constraints: No of Constraints records:'

Line 9919: FROM pn_var_grp_dates_all a

9915: -- This sould be changed_var_rent_id
9916: CURSOR c_grp_dates_match
9917: IS
9918: SELECT COUNT (a.grp_date_id)
9919: FROM pn_var_grp_dates_all a
9920: , pn_var_grp_dates_all b
9921: WHERE a.var_rent_id = l_chg_cal_var_rent_id
9922: -- This sould be changed_var_rent_id
9923: AND b.var_rent_id = p_var_rent_id

Line 9920: , pn_var_grp_dates_all b

9916: CURSOR c_grp_dates_match
9917: IS
9918: SELECT COUNT (a.grp_date_id)
9919: FROM pn_var_grp_dates_all a
9920: , pn_var_grp_dates_all b
9921: WHERE a.var_rent_id = l_chg_cal_var_rent_id
9922: -- This sould be changed_var_rent_id
9923: AND b.var_rent_id = p_var_rent_id
9924: AND a.grp_start_date = b.grp_start_date