APPS.IGW_BUDGETS_PVT dependencies on IGW_BUDGET_PERSONNEL_DETAILS

Line 23: from igw_budget_personnel_details pb

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);
26:
27:

Line 28: delete from igw_budget_personnel_details

24: where pb.proposal_id = p_proposal_id
25: and pb.version_id = p_version_id);
26:
27:
28: delete from igw_budget_personnel_details
29: where proposal_id = p_proposal_id
30: and version_id = p_version_id;
31:
32: delete from igw_budget_details_cal_amts

Line 52: from igw_budget_personnel_details pb

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
55: and pb.budget_period_id = p_budget_period_id);
56:

Line 57: delete from igw_budget_personnel_details

53: where pb.proposal_id = p_proposal_id
54: and pb.version_id = p_version_id
55: and pb.budget_period_id = p_budget_period_id);
56:
57: delete from igw_budget_personnel_details
58: where proposal_id = p_proposal_id
59: and version_id = p_version_id
60: and budget_period_id = p_budget_period_id;
61:

Line 76: from igw_budget_personnel_details pb

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:
79: delete from igw_budget_personnel_details
80: where line_item_id = p_line_item_id;

Line 79: delete from igw_budget_personnel_details

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:
79: delete from igw_budget_personnel_details
80: where line_item_id = p_line_item_id;
81:
82: delete from igw_budget_details_cal_amts
83: where line_item_id = p_line_item_id;