APPS.PA_BUDGET_PUB dependencies on PA_BUDGET_PERIODS_V

Line 7962: FROM pa_budget_periods_v

7958: (p_period_name VARCHAR2
7959: ,p_time_phased_type_code VARCHAR2 )
7960: IS
7961: SELECT trunc(period_start_date)
7962: FROM pa_budget_periods_v
7963: WHERE period_name = p_period_name
7964: AND period_type_code = p_time_phased_type_code;
7965:
7966: --needed to validate to given start_date

Line 7972: FROM pa_budget_periods_v

7968: (p_start_date DATE
7969: ,p_time_phased_type_code VARCHAR2 )
7970: IS
7971: SELECT 1
7972: FROM pa_budget_periods_v
7973: WHERE trunc(period_start_date) = trunc(p_start_date)
7974: AND period_type_code = p_time_phased_type_code;
7975:
7976: --needed to lock the budget line row

Line 9101: FROM pa_budget_periods_v

9097: (p_period_name VARCHAR2
9098: ,p_period_type_code VARCHAR2 )
9099: IS
9100: SELECT trunc(period_start_date)
9101: FROM pa_budget_periods_v
9102: WHERE period_name = p_period_name
9103: AND period_type_code = p_period_type_code;
9104:
9105: -- the uncategorized resource list

Line 14370: FROM pa_budget_periods_v

14366: (p_period_name VARCHAR2
14367: ,p_period_type_code VARCHAR2 )
14368: IS
14369: SELECT PERIOD_YEAR
14370: FROM pa_budget_periods_v
14371: WHERE period_name = p_period_name
14372: AND period_type_code = p_period_type_code;
14373:
14374: -- End Bug 4588279, 27-SEP-05, jwhite ------------------