APPS.BEN_ASG_BUDGET_VALUES dependencies on PER_ASSIGNMENT_BUDGET_VALUES_F

Line 24: from per_assignment_budget_values_f

20: assignment_id,
21: unit,
22: value,
23: rowid
24: from per_assignment_budget_values_f
25: where
26: assignment_id = p_assignment_id and
27: p_effective_date between effective_start_date and effective_end_date and
28: business_group_id = p_business_group_id and

Line 95: update per_assignment_budget_values_f

91: P_ASSIGNMENT_ID IN NUMBER,
92: P_VALUE IN NUMBER
93: ) is
94: BEGIN
95: update per_assignment_budget_values_f
96: set
97: effective_end_date = p_effective_end_date,
98: value = p_value
99: where assignment_budget_value_id = p_assignment_budget_value_id

Line 117: select effective_start_date, rowid from per_assignment_budget_values_f

113: p_rowid in varchar2,
114: p_assignment_budget_value_id in number) is
115:
116: cursor c2 is
117: select effective_start_date, rowid from per_assignment_budget_values_f
118: where
119: assignment_id = p_assignment_id and
120: business_group_id = p_business_group_id
121: order by effective_start_date;

Line 126: l_assignment_budget_value_id per_assignment_budget_values_f.ASSIGNMENT_BUDGET_VALUE_ID%TYPE;

122:
123: l2_rec c2%ROWTYPE;
124: l_parent_effective_end_date date;
125:
126: l_assignment_budget_value_id per_assignment_budget_values_f.ASSIGNMENT_BUDGET_VALUE_ID%TYPE;
127: --
128: begin
129:
130: -- Date track coding,get the maximum effective end date from the assignment

Line 196: insert into per_assignment_budget_values_f

192: P_UNIT IN VARCHAR2,
193: P_VALUE IN NUMBER
194: ) IS
195: BEGIN
196: insert into per_assignment_budget_values_f
197: (ASSIGNMENT_BUDGET_VALUE_ID,
198: EFFECTIVE_START_DATE,
199: EFFECTIVE_END_DATE,
200: BUSINESS_GROUP_ID,