APPS.PER_CANCEL_HIRE_OR_APL_PKG dependencies on PER_ASSIGNMENT_BUDGET_VALUES_F

Line 55: from per_assignment_budget_values_f pab

51: -- Budget values cursor
52: --
53: cursor budget_values is
54: select pab.rowid
55: from per_assignment_budget_values_f pab
56: , per_assignments_f paf
57: where pab.business_group_id + 0 = paf.business_group_id + 0
58: and paf.business_group_id + 0 = p_business_group_id
59: and pab.assignment_id = paf.assignment_id

Line 408: from per_assignment_budget_values_f pab

404: -- Budget values cursor
405: --
406: cursor budget_values is
407: select pab.rowid
408: from per_assignment_budget_values_f pab
409: , per_assignments_f paf
410: where pab.business_group_id + 0 = paf.business_group_id + 0
411: and paf.business_group_id + 0 = p_business_group_id
412: and pab.assignment_id = paf.assignment_id

Line 733: from per_assignment_budget_values_f pab

729: -- budget_values cursor
730: --
731: cursor budget_values is
732: select rowid
733: from per_assignment_budget_values_f pab
734: where pab.business_group_id = p_business_group_id and
735: exists (select 'budget_values exist'
736: from per_all_assignments_f paf
737: where pab.business_group_id +0= paf.business_group_id + 0

Line 1267: from per_assignment_budget_values_f pab

1263: -- budget_values cursor
1264: --
1265: cursor budget_values1 is
1266: select rowid
1267: from per_assignment_budget_values_f pab
1268: where pab.business_group_id = p_business_group_id and
1269: exists (select 'budget_values exist'
1270: from per_all_assignments_f paf
1271: where pab.business_group_id +0= paf.business_group_id + 0

Line 1629: delete from per_assignment_budget_values_f pab

1625: <>
1626: loop
1627: fetch budget_values1 into p_rowid;
1628: exit when budget_values1%NOTFOUND;
1629: delete from per_assignment_budget_values_f pab
1630: where pab.rowid = p_rowid;
1631: if sql%notfound then
1632: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1633: hr_utility.set_message_token('PROCEDURE','do_cancel_hire');

Line 2168: from per_assignment_budget_values_f pab

2164: -- Budget values cursor
2165: --
2166: cursor budget_values2(p_assignment_id NUMBER) is
2167: select pab.rowid
2168: from per_assignment_budget_values_f pab
2169: where pab.assignment_id = p_assignment_id;
2170: --
2171: -- letters cursor
2172: --

Line 2383: delete from per_assignment_budget_values_f pab

2379: <>
2380: loop
2381: fetch budget_values2 into l_rowid;
2382: exit when budget_values2%NOTFOUND;
2383: delete from per_assignment_budget_values_f pab
2384: where pab.rowid = l_rowid;
2385: if sql%notfound then
2386: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
2387: hr_utility.set_message_token('PROCEDURE','do_cancel_appl');

Line 2915: FROM per_assignment_budget_values_f pab

2911: -- budget_values cursor
2912: --
2913: CURSOR csr_budget_values IS
2914: SELECT ROWID
2915: FROM per_assignment_budget_values_f pab
2916: WHERE pab.business_group_id = p_business_group_id and
2917: EXISTS (SELECT 'budget_values exist'
2918: FROM per_all_assignments_f paf
2919: WHERE pab.business_group_id +0= paf.business_group_id + 0

Line 3314: FROM per_assignment_budget_values_f pab

3310: -- budget_values cursor
3311: --
3312: CURSOR csr_budget_values IS
3313: SELECT ROWID
3314: FROM per_assignment_budget_values_f pab
3315: WHERE pab.business_group_id = p_business_group_id and
3316: EXISTS (SELECT 'budget_values exist'
3317: FROM per_all_assignments_f paf
3318: WHERE pab.business_group_id +0= paf.business_group_id + 0

Line 3670: DELETE FROM per_assignment_budget_values_f pab

3666: FOR budget_rec IN csr_budget_values LOOP
3667: --
3668: hr_utility.set_location(l_proc,200);
3669: --
3670: DELETE FROM per_assignment_budget_values_f pab
3671: WHERE pab.rowid = budget_rec.rowid;
3672: --
3673: IF SQL%NOTFOUND THEN
3674: --