APPS.HR_ASSIGNMENT_INTERNAL dependencies on PER_PAY_PROPOSALS

Line 193: from per_pay_proposals pyp

189: -- Fix for bug 5841180 ends here
190:
191: cursor csr_lock_pyp is
192: select null
193: from per_pay_proposals pyp
194: where pyp.assignment_id = p_assignment_id
195: for update nowait;
196: --
197: cursor csr_lock_asa is

Line 206: from per_pay_proposals pyp

202: --
203: -- Start of fix 3202260
204: cursor csr_pay_proposal is
205: select pyp.pay_proposal_id, pyp.object_version_number
206: from per_pay_proposals pyp
207: where pyp.assignment_id = p_assignment_id
208: and pyp.change_date > p_actual_termination_date
209: order by pyp.change_date desc;
210:

Line 434: -- After the delete from per_pay_proposals a warning out parameter is set.

430: --
431: -- Delete any pay proposals for this assignment that occur after the
432: -- actual termination date.
433: --
434: -- After the delete from per_pay_proposals a warning out parameter is set.
435: --
436: -- Start of fix 3202260
437: for rec_pay_prop in csr_pay_proposal loop
438: --

Line 460: from per_pay_proposals pyp

456: --
457: hr_utility.set_location(l_proc, 234);
458: --
459: delete
460: from per_pay_proposals pyp
461: where pyp.pay_proposal_id = rec_pay_prop.pay_proposal_id;
462: --
463: -- Setting the Warning Out variable
464: if sql%notfound then

Line 638: from per_pay_proposals pyp

634: for update nowait;
635: --
636: cursor csr_lock_pyp is
637: select null
638: from per_pay_proposals pyp
639: where pyp.assignment_id = p_assignment_id
640: for update nowait;
641: --
642: -- Start of fix for Bug 2796523

Line 1145: from per_pay_proposals pyp

1141: for update nowait;
1142: --
1143: cursor csr_lock_pyp is
1144: select null
1145: from per_pay_proposals pyp
1146: where pyp.assignment_id = p_assignment_id
1147: for update nowait;
1148: --
1149: -- Start of fix 3202260

Line 1152: from per_pay_proposals pyp

1148: --
1149: -- Start of fix 3202260
1150: cursor csr_pay_proposal is
1151: select pyp.pay_proposal_id, pyp.object_version_number, pyp.business_group_id
1152: from per_pay_proposals pyp
1153: where pyp.assignment_id = p_assignment_id
1154: and pyp.change_date > p_actual_termination_date
1155: order by pyp.change_date desc;
1156: --Added business_group_id for bug 4689950

Line 1440: -- After the delete from per_pay_proposals a warning out parameter is set.

1436: --
1437: -- Delete any pay proposals for this assignment that occur after the
1438: -- actual termination date.
1439: --
1440: -- After the delete from per_pay_proposals a warning out parameter is set.
1441: --
1442: -- Start of fix 3202260
1443: for rec_pay_prop in csr_pay_proposal loop
1444: --

Line 1467: from per_pay_proposals pyp

1463: --
1464: hr_utility.set_location(l_proc, 234);
1465: --
1466: delete
1467: from per_pay_proposals pyp
1468: where pyp.pay_proposal_id = rec_pay_prop.pay_proposal_id;
1469: --
1470: -- Setting the Warning Out variable
1471: if sql%notfound then

Line 2390: from per_pay_proposals pyp

2386: for update nowait;
2387: --
2388: cursor csr_lock_pyp is
2389: select null
2390: from per_pay_proposals pyp
2391: where pyp.assignment_id = p_assignment_id
2392: for update nowait;
2393: --
2394: -- Start of fix for Bug 2796523