APPS.PA_BUDGET_PUB dependencies on PA_BUDGET_PERIODS_V

Line 8122: FROM pa_budget_periods_v

8118: (p_period_name VARCHAR2
8119: ,p_time_phased_type_code VARCHAR2 )
8120: IS
8121: SELECT trunc(period_start_date)
8122: FROM pa_budget_periods_v
8123: WHERE period_name = p_period_name
8124: AND period_type_code = p_time_phased_type_code;
8125:
8126: --needed to validate to given start_date

Line 8132: FROM pa_budget_periods_v

8128: (p_start_date DATE
8129: ,p_time_phased_type_code VARCHAR2 )
8130: IS
8131: SELECT 1
8132: FROM pa_budget_periods_v
8133: WHERE trunc(period_start_date) = trunc(p_start_date)
8134: AND period_type_code = p_time_phased_type_code;
8135:
8136: --needed to lock the budget line row

Line 9282: FROM pa_budget_periods_v

9278: (p_period_name VARCHAR2
9279: ,p_period_type_code VARCHAR2 )
9280: IS
9281: SELECT trunc(period_start_date)
9282: FROM pa_budget_periods_v
9283: WHERE period_name = p_period_name
9284: AND period_type_code = p_period_type_code;
9285:
9286: -- the uncategorized resource list

Line 14616: FROM pa_budget_periods_v

14612: (p_period_name VARCHAR2
14613: ,p_period_type_code VARCHAR2 )
14614: IS
14615: SELECT PERIOD_YEAR
14616: FROM pa_budget_periods_v
14617: WHERE period_name = p_period_name
14618: AND period_type_code = p_period_type_code;
14619:
14620: -- End Bug 4588279, 27-SEP-05, jwhite ------------------