1030: SELECT MIN(start_date)
1031: FROM per_time_periods tp,
1032: pqh_budget_periods bpr,
1033: pqh_budget_details bdt,
1034: pqh_budget_versions bvr
1035: WHERE time_period_id = bpr.start_time_period_id
1036: and bpr.budget_detail_id = bdt.budget_detail_id
1037: AND bdt.budget_version_id = bvr.budget_version_id
1038: and bvr.budget_id = p_budget_id;
1208: SELECT MIN(start_date)
1209: FROM per_time_periods tp,
1210: pqh_budget_periods bpr,
1211: pqh_budget_details bdt,
1212: pqh_budget_versions bvr
1213: WHERE time_period_id = bpr.start_time_period_id
1214: and bpr.budget_detail_id = bdt.budget_detail_id
1215: AND bdt.budget_version_id = bvr.budget_version_id
1216: and bvr.budget_id = p_budget_id;