APPS.PA_BUDGET_CHECK_PVT dependencies on PA_BUDGET_PERIODS_V

Line 64: FROM pa_budget_periods_v

60: IS
61: SELECT period_start_date
62: , period_end_date
63: , PERIOD_YEAR /* bug 4588279: added PERIOD_YEAR */
64: FROM pa_budget_periods_v
65: WHERE period_name = p_period_name
66: AND period_type_code = p_period_type_code;
67:
68: CURSOR l_period_name_csr

Line 75: FROM pa_budget_periods_v

71: ,p_period_type_code VARCHAR2 )
72: IS
73: SELECT period_name
74: , PERIOD_YEAR /* bug 4588279: added PERIOD_YEAR */
75: FROM pa_budget_periods_v
76: WHERE period_type_code = p_period_type_code
77: AND period_start_date = p_start_date
78: AND period_end_date = p_end_date;
79:

Line 828: FROM pa_budget_periods_v

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);
831: EXCEPTION
832: WHEN NO_DATA_FOUND THEN

Line 841: FROM pa_budget_periods_v

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);
844:
845: EXCEPTION

Line 873: FROM pa_budget_periods_v

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);
876: EXCEPTION
877: WHEN NO_DATA_FOUND THEN

Line 886: FROM pa_budget_periods_v

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);
889:
890: EXCEPTION