DBA Data[Home] [Help]

APPS.PSB_GL_INTERFACE_PVT dependencies on PSB_BUDGET_PERIODS

Line 2130: FROM psb_budget_periods

2126:
2127: CURSOR c_type
2128: IS
2129: SELECT budget_year_type_id
2130: FROM psb_budget_periods
2131: WHERE budget_period_id = p_year_id;
2132:
2133: BEGIN
2134:

Line 2711: FROM psb_budget_periods

2707: IS
2708: SELECT start_date,
2709: end_date,
2710: budget_year_type_id
2711: FROM psb_budget_periods
2712: WHERE budget_period_id = p_budget_year_id;
2713:
2714: CURSOR c_stage
2715: IS

Line 2725: FROM psb_budget_periods

2721: IS
2722: SELECT budget_period_id,
2723: start_date,
2724: end_date
2725: FROM psb_budget_periods
2726: WHERE budget_period_type = 'P'
2727: AND parent_budget_period_id = p_budget_year_id
2728: ORDER BY start_date;
2729:

Line 4288: FROM psb_budget_periods

4284: IS
4285: SELECT start_date,
4286: end_date,
4287: budget_year_type_id
4288: FROM psb_budget_periods
4289: WHERE budget_period_id = p_budget_year_id;
4290:
4291: CURSOR c_stage
4292: IS

Line 4302: FROM psb_budget_periods

4298: IS
4299: SELECT budget_period_id,
4300: start_date,
4301: end_date
4302: FROM psb_budget_periods
4303: WHERE budget_period_type = 'P'
4304: AND parent_budget_period_id = p_budget_year_id
4305: ORDER BY start_date;
4306: