APPS.PER_CANCEL_HIRE_OR_APL_PKG dependencies on PER_ASSIGNMENT_BUDGET_VALUES_F

Line 223: from per_assignment_budget_values_f pab

219: -- Budget values cursor
220: --
221: cursor budget_values is
222: select pab.rowid
223: from per_assignment_budget_values_f pab
224: , per_assignments_f paf
225: where pab.business_group_id + 0 = paf.business_group_id + 0
226: and paf.business_group_id + 0 = p_business_group_id
227: and pab.assignment_id = paf.assignment_id

Line 576: from per_assignment_budget_values_f pab

572: -- Budget values cursor
573: --
574: cursor budget_values is
575: select pab.rowid
576: from per_assignment_budget_values_f pab
577: , per_assignments_f paf
578: where pab.business_group_id + 0 = paf.business_group_id + 0
579: and paf.business_group_id + 0 = p_business_group_id
580: and pab.assignment_id = paf.assignment_id

Line 917: from per_assignment_budget_values_f pab

913: -- budget_values cursor
914: --
915: cursor budget_values is
916: select rowid
917: from per_assignment_budget_values_f pab
918: where pab.business_group_id = p_business_group_id and
919: exists (select 'budget_values exist'
920: from per_all_assignments_f paf
921: where pab.business_group_id +0= paf.business_group_id + 0

Line 1407: from per_assignment_budget_values_f pab

1403: l_dummy varchar2(10);
1404:
1405: cursor budget_values1 is
1406: select rowid
1407: from per_assignment_budget_values_f pab
1408: where pab.business_group_id = p_business_group_id and
1409:
1410: exists (select 'budget_values exist'
1411: from per_all_assignments_f paf

Line 2178: from per_assignment_budget_values_f pab

2174: -- budget_values cursor
2175: --
2176: cursor budget_values1 is
2177: select rowid
2178: from per_assignment_budget_values_f pab
2179: where pab.business_group_id = p_business_group_id and
2180: exists (select 'budget_values exist'
2181: from per_all_assignments_f paf
2182: where pab.business_group_id +0= paf.business_group_id + 0

Line 2549: delete from per_assignment_budget_values_f pab

2545: <>
2546: loop
2547: fetch budget_values1 into p_rowid;
2548: exit when budget_values1%NOTFOUND;
2549: delete from per_assignment_budget_values_f pab
2550: where pab.rowid = p_rowid;
2551: if sql%notfound then
2552: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
2553: hr_utility.set_message_token('PROCEDURE','do_cancel_hire');

Line 3168: from per_assignment_budget_values_f pab

3164: -- Budget values cursor
3165: --
3166: cursor budget_values2(p_assignment_id NUMBER) is
3167: select pab.rowid
3168: from per_assignment_budget_values_f pab
3169: where pab.assignment_id = p_assignment_id;
3170: --
3171: -- letters cursor
3172: --

Line 3447: delete from per_assignment_budget_values_f pab

3443: <>
3444: loop
3445: fetch budget_values2 into l_rowid;
3446: exit when budget_values2%NOTFOUND;
3447: delete from per_assignment_budget_values_f pab
3448: where pab.rowid = l_rowid;
3449: if sql%notfound then
3450: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
3451: hr_utility.set_message_token('PROCEDURE','do_cancel_appl');

Line 4093: FROM per_assignment_budget_values_f pab

4089: -- budget_values cursor
4090: --
4091: CURSOR csr_budget_values IS
4092: SELECT ROWID
4093: FROM per_assignment_budget_values_f pab
4094: WHERE pab.business_group_id = p_business_group_id and
4095: EXISTS (SELECT 'budget_values exist'
4096: FROM per_all_assignments_f paf
4097: WHERE pab.business_group_id +0= paf.business_group_id + 0

Line 4529: FROM per_assignment_budget_values_f pab

4525: -- budget_values cursor
4526: --
4527: CURSOR csr_budget_values IS
4528: SELECT ROWID
4529: FROM per_assignment_budget_values_f pab
4530: WHERE pab.business_group_id = p_business_group_id and
4531: EXISTS (SELECT 'budget_values exist'
4532: FROM per_all_assignments_f paf
4533: WHERE pab.business_group_id +0= paf.business_group_id + 0

Line 4944: DELETE FROM per_assignment_budget_values_f pab

4940: FOR budget_rec IN csr_budget_values LOOP
4941: --
4942: hr_utility.set_location(l_proc,200);
4943: --
4944: DELETE FROM per_assignment_budget_values_f pab
4945: WHERE pab.rowid = budget_rec.rowid;
4946: --
4947: IF SQL%NOTFOUND THEN
4948: --