APPS.CN_RATE_DIMENSIONS_PVT dependencies on DUAL

Line 22: FROM dual

18: l_dummy NUMBER;
19:
20: CURSOR exp_info(p_calc_sql_exp_id NUMBER) IS
21: SELECT 0
22: FROM dual
23: WHERE NOT exists (SELECT 1 FROM cn_calc_sql_exps WHERE calc_sql_exp_id = p_calc_sql_exp_id)
24: UNION ALL
25: SELECT 1
26: FROM cn_calc_sql_exps

Line 387: FROM dual

383: WHERE rate_dimension_id = p_rate_dimension_id;
384:
385: CURSOR formula_info IS
386: SELECT 1
387: FROM dual
388: WHERE exists (SELECT 1
389: FROM cn_rate_sch_dims rsd
390: WHERE rsd.rate_dimension_id = p_rate_dimension_id
391: AND exists (SELECT 1

Line 699: FROM dual

695: l_note_id NUMBER;
696:
697: CURSOR parent_table_exist IS
698: SELECT 1
699: FROM dual
700: WHERE exists (SELECT 1
701: FROM cn_rate_sch_dims
702: WHERE rate_dimension_id = p_rate_dimension_id);
703: BEGIN

Line 860: FROM dual

856: WHERE rate_dimension_id = l_rate_dimension_id;
857:
858: CURSOR last_tier IS
859: SELECT 1
860: FROM dual
861: WHERE NOT exists (SELECT 1
862: FROM cn_rate_dim_tiers
863: WHERE rate_dimension_id = l_rate_dimension_id
864: AND rate_dim_tier_id <> p_rate_dim_tier_id);