APPS.IGW_BUDGETS_PVT dependencies on IGW_BUDGET_PERSONNEL_CAL_AMTS

Line 21: delete from igw_budget_personnel_cal_amts pbp

17: delete from igw_budget_persons
18: where proposal_id = p_proposal_id
19: and version_id = p_version_id;
20:
21: delete from igw_budget_personnel_cal_amts pbp
22: where pbp.budget_personnel_detail_id IN (select pb.budget_personnel_detail_id
23: from igw_budget_personnel_details pb
24: where pb.proposal_id = p_proposal_id
25: and pb.version_id = p_version_id);

Line 50: delete from igw_budget_personnel_cal_amts pbp

46: and version_id = p_version_id;
47:
48: elsif p_delete_level = 'BUDGET_PERIOD' then
49:
50: delete from igw_budget_personnel_cal_amts pbp
51: where pbp.budget_personnel_detail_id IN (select pb.budget_personnel_detail_id
52: from igw_budget_personnel_details pb
53: where pb.proposal_id = p_proposal_id
54: and pb.version_id = p_version_id

Line 74: delete from igw_budget_personnel_cal_amts pbp

70: and budget_period_id = p_budget_period_id;
71:
72: elsif p_delete_level = 'BUDGET_LINE' then
73:
74: delete from igw_budget_personnel_cal_amts pbp
75: where pbp.budget_personnel_detail_id IN (select pb.budget_personnel_detail_id
76: from igw_budget_personnel_details pb
77: where pb.line_item_id = p_line_item_id);
78:

Line 87: delete from igw_budget_personnel_cal_amts pbp

83: where line_item_id = p_line_item_id;
84:
85: elsif p_delete_level = 'BUDGET_PERSONNEL' then
86:
87: delete from igw_budget_personnel_cal_amts pbp
88: where pbp.budget_personnel_detail_id = p_budget_personnel_detail_id;
89:
90: end if;
91: exception