APPS.PA_BUDGET_CHECK_PVT dependencies on DUAL

Line 826: FROM dual

822: IF p_time_phased_type_code = 'G' THEN
823: BEGIN
824: SELECT 'Y'
825: INTO valid_gl_start_date
826: FROM dual
827: WHERE EXISTS (SELECT 'X'
828: FROM pa_budget_periods_v
829: WHERE period_type_code = 'G'
830: AND period_start_date = l_budget_start_date_in);

Line 839: FROM dual

835:
836: BEGIN
837: SELECT 'Y'
838: INTO valid_gl_end_date
839: FROM dual
840: WHERE EXISTS (SELECT 'X'
841: FROM pa_budget_periods_v
842: WHERE period_type_code = 'G'
843: AND period_end_date = l_budget_end_date_in);

Line 871: FROM dual

867: ELSIF p_time_phased_type_code = 'P' THEN
868: BEGIN
869: SELECT 'Y'
870: INTO valid_pa_start_date
871: FROM dual
872: WHERE EXISTS (SELECT 'X'
873: FROM pa_budget_periods_v
874: WHERE period_type_code = 'P'
875: AND period_start_date = l_budget_start_date_in);

Line 884: FROM dual

880:
881: BEGIN
882: SELECT 'Y'
883: INTO valid_pa_end_date
884: FROM dual
885: WHERE EXISTS (SELECT 'X'
886: FROM pa_budget_periods_v
887: WHERE period_type_code = 'P'
888: AND period_end_date = l_budget_end_date_in);