DBA Data[Home] [Help]

APPS.IGW_VIEW_PARAMETERS dependencies on IGW_PROPOSALS

Line 59: from igw_proposals

55: prop_start_date date;
56: Begin
57: select proposal_start_date
58: into prop_start_date
59: from igw_proposals
60: where proposal_id = i_proposal_id;
61:
62: o_pi_id := 0;
63:

Line 98: from igw_proposals

94: o_pi_name per_all_people_f.FULL_NAME%TYPE;
95: Begin
96: select proposal_start_date
97: into prop_start_date
98: from igw_proposals
99: where proposal_id = i_proposal_id;
100:
101: o_pi_id := 0;
102: o_pi_name := 'pi';

Line 160: from igw_proposals

156: o_direct_cost number;
157: Begin
158: select proposal_start_date
159: into prop_start_date
160: from igw_proposals
161: where proposal_id = i_proposal_id;
162:
163: select sum(direct_cost)
164: into o_direct_cost

Line 186: from igw_proposals

182: o_total_cost number;
183: Begin
184: select proposal_start_date
185: into prop_start_date
186: from igw_proposals
187: where proposal_id = i_proposal_id;
188:
189: select sum(direct_cost + indirect_cost)
190: into o_total_cost