APPS.IGW_BUDGET_PERIODS_PVT dependencies on IGW_BUDGET_DETAILS

Line 53: from igw_budget_details pbd

49:
50: cursor c_budget_line is
51: select min(pbpd.start_date)
52: , max(pbpd.end_date)
53: from igw_budget_details pbd
54: , igw_budget_personnel_details pbpd
55: where pbd.proposal_id = p_proposal_id
56: and pbd.version_id = p_version_id
57: and pbd.budget_period_id = p_budget_period_id

Line 488: update igw_budget_details

484: x_return_status := l_return_status;
485:
486: --also update the corresponding detail records to reflect new budget period id
487: if l_orig_budget_period_id <> p_budget_period_id then
488: update igw_budget_details
489: set budget_period_id = p_budget_period_id
490: where proposal_id = p_proposal_id
491: and version_id = p_version_id
492: and budget_period_id = l_orig_budget_period_id;

Line 494: update igw_budget_details_cal_amts

490: where proposal_id = p_proposal_id
491: and version_id = p_version_id
492: and budget_period_id = l_orig_budget_period_id;
493:
494: update igw_budget_details_cal_amts
495: set budget_period_id = p_budget_period_id
496: where proposal_id = p_proposal_id
497: and version_id = p_version_id
498: and budget_period_id = l_orig_budget_period_id;