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 806: FROM pa_budget_periods_v

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);
809: EXCEPTION
810: WHEN NO_DATA_FOUND THEN

Line 819: FROM pa_budget_periods_v

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);
822:
823: EXCEPTION

Line 851: FROM pa_budget_periods_v

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);
854: EXCEPTION
855: WHEN NO_DATA_FOUND THEN

Line 864: FROM pa_budget_periods_v

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);
867:
868: EXCEPTION