APPS.PA_BUDGET_CHECK_PVT dependencies on DUAL

Line 804: FROM dual

800: IF p_time_phased_type_code = 'G' THEN
801: BEGIN
802: SELECT 'Y'
803: INTO valid_gl_start_date
804: FROM dual
805: WHERE EXISTS (SELECT 'X'
806: FROM pa_budget_periods_v
807: WHERE period_type_code = 'G'
808: AND period_start_date = l_budget_start_date_in);

Line 817: FROM dual

813:
814: BEGIN
815: SELECT 'Y'
816: INTO valid_gl_end_date
817: FROM dual
818: WHERE EXISTS (SELECT 'X'
819: FROM pa_budget_periods_v
820: WHERE period_type_code = 'G'
821: AND period_end_date = l_budget_end_date_in);

Line 849: FROM dual

845: ELSIF p_time_phased_type_code = 'P' THEN
846: BEGIN
847: SELECT 'Y'
848: INTO valid_pa_start_date
849: FROM dual
850: WHERE EXISTS (SELECT 'X'
851: FROM pa_budget_periods_v
852: WHERE period_type_code = 'P'
853: AND period_start_date = l_budget_start_date_in);

Line 862: FROM dual

858:
859: BEGIN
860: SELECT 'Y'
861: INTO valid_pa_end_date
862: FROM dual
863: WHERE EXISTS (SELECT 'X'
864: FROM pa_budget_periods_v
865: WHERE period_type_code = 'P'
866: AND period_end_date = l_budget_end_date_in);