APPS.PER_APPLICATIONS_PKG dependencies on PER_ASSIGNMENT_BUDGET_VALUES_F

Line 87: per_assignment_budget_values_f abv1

83: --
84: cursor c1 is
85: select abv1.*
86: from PER_ALL_ASSIGNMENTS_F paa,
87: per_assignment_budget_values_f abv1
88: where paa.APPLICATION_ID = p_application_id
89: and paa.PERSON_ID = p_person_id
90: and paa.business_group_id = p_business_group_id
91: and paa.ASSIGNMENT_TYPE = 'A'

Line 116: from PER_ALL_ASSIGNMENTS_F paa, per_assignment_budget_values_f abv

112: into p_del_flag
113: from sys.dual
114: where exists (
115: Select null
116: from PER_ALL_ASSIGNMENTS_F paa, per_assignment_budget_values_f abv
117: where paa.APPLICATION_ID = p_application_id
118: and paa.PERSON_ID = p_person_id
119: and paa.business_group_id + 0 = p_business_group_id
120: and paa.ASSIGNMENT_TYPE = 'A'

Line 133: delete from per_assignment_budget_values_f abv

129: IF p_del_flag = 'Y' THEN
130: --
131: hr_utility.set_location('PER_APPLICATIONS_PKG.term_update_ass_bud_val',10);
132: --
133: delete from per_assignment_budget_values_f abv
134: where exists (
135: Select null
136: from PER_ALL_ASSIGNMENTS_F paa, per_assignment_budget_values_f abv1
137: where paa.APPLICATION_ID = p_application_id

Line 136: from PER_ALL_ASSIGNMENTS_F paa, per_assignment_budget_values_f abv1

132: --
133: delete from per_assignment_budget_values_f abv
134: where exists (
135: Select null
136: from PER_ALL_ASSIGNMENTS_F paa, per_assignment_budget_values_f abv1
137: where paa.APPLICATION_ID = p_application_id
138: and paa.PERSON_ID = p_person_id
139: and paa.business_group_id + 0 = p_business_group_id
140: and paa.ASSIGNMENT_TYPE = 'A'

Line 164: from PER_ALL_ASSIGNMENTS_F paa, per_assignment_budget_values_f abv

160: into p_del_flag
161: from sys.dual
162: where exists (
163: Select null
164: from PER_ALL_ASSIGNMENTS_F paa, per_assignment_budget_values_f abv
165: where paa.APPLICATION_ID = p_application_id
166: and paa.PERSON_ID = p_person_id
167: and paa.business_group_id + 0 = p_business_group_id
168: and paa.ASSIGNMENT_TYPE = 'A'

Line 191: update per_assignment_budget_values_f abv

187: --
188: fetch c1 into l_c1;
189: exit when c1%notfound;
190: --
191: update per_assignment_budget_values_f abv
192: set abv.effective_end_date = p_date_end,
193: abv.last_updated_by = P_LAST_UPDATED_BY,
194: abv.last_update_login = P_LAST_UPDATE_LOGIN,
195: abv.last_update_date = sysdate

Line 264: per_assignment_budget_values_f abv1

260: --
261: cursor c1 is
262: select abv1.*
263: from PER_ALL_ASSIGNMENTS_F paa,
264: per_assignment_budget_values_f abv1
265: where paa.APPLICATION_ID = p_application_id
266: and paa.PERSON_ID = p_person_id
267: and paa.business_group_id = p_business_group_id
268: and paa.ASSIGNMENT_TYPE = 'A'

Line 297: from per_assignment_budget_values_f abv

293: and paa.PERSON_ID = p_person_id
294: and paa.business_group_id + 0 = p_business_group_id
295: and paa.ASSIGNMENT_TYPE = 'A'
296: and exists (Select abv.assignment_id
297: from per_assignment_budget_values_f abv
298: where abv.assignment_id = paa.assignment_id
299: and abv.effective_end_date = p_date_end));
300:
301: EXCEPTION

Line 319: update per_assignment_budget_values_f abv

315: --
316: fetch c1 into l_c1;
317: exit when c1%notfound;
318: --
319: update per_assignment_budget_values_f abv
320: set abv.effective_end_date = p_end_of_time,
321: abv.last_updated_by = P_LAST_UPDATED_BY,
322: abv.last_update_login = P_LAST_UPDATE_LOGIN,
323: abv.last_update_date = sysdate