APPS.PN_VAREN_PVT dependencies on DUAL

Line 530: FROM DUAL

526:
527: CURSOR exists_hd_def_cur_1
528: IS
529: SELECT 'x'
530: FROM DUAL
531: WHERE EXISTS (SELECT bkhd_default_id
532: FROM pn_var_bkhd_defaults_all
533: WHERE var_rent_id = p_var_rent_id);
534: BEGIN

Line 2203: FROM dual

2199:
2200: BEGIN
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

Line 2689: -- BEGIN -- to capture exceptions related to individual validations

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:'
2692: || p_constraints_tbl_type.COUNT
2693: , 3