APPS.HR_ASSIGNMENT_INTERNAL dependencies on PER_PAY_PROPOSALS

Line 173: from per_pay_proposals pyp

169: for update nowait;
170: --
171: cursor csr_lock_pyp is
172: select null
173: from per_pay_proposals pyp
174: where pyp.assignment_id = p_assignment_id
175: for update nowait;
176: --
177: cursor csr_lock_asa is

Line 186: from per_pay_proposals pyp

182: --
183: -- Start of fix 3202260
184: cursor csr_pay_proposal is
185: select pyp.pay_proposal_id, pyp.object_version_number
186: from per_pay_proposals pyp
187: where pyp.assignment_id = p_assignment_id
188: and pyp.change_date > p_actual_termination_date
189: order by pyp.change_date desc;
190:

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

395: --
396: -- Delete any pay proposals for this assignment that occur after the
397: -- actual termination date.
398: --
399: -- After the delete from per_pay_proposals a warning out parameter is set.
400: --
401: -- Start of fix 3202260
402: for rec_pay_prop in csr_pay_proposal loop
403: --

Line 425: from per_pay_proposals pyp

421: --
422: hr_utility.set_location(l_proc, 234);
423: --
424: delete
425: from per_pay_proposals pyp
426: where pyp.pay_proposal_id = rec_pay_prop.pay_proposal_id;
427: --
428: -- Setting the Warning Out variable
429: if sql%notfound then

Line 584: from per_pay_proposals pyp

580: for update nowait;
581: --
582: cursor csr_lock_pyp is
583: select null
584: from per_pay_proposals pyp
585: where pyp.assignment_id = p_assignment_id
586: for update nowait;
587: --
588: -- Start of fix for Bug 2796523

Line 1059: from per_pay_proposals pyp

1055: for update nowait;
1056: --
1057: cursor csr_lock_pyp is
1058: select null
1059: from per_pay_proposals pyp
1060: where pyp.assignment_id = p_assignment_id
1061: for update nowait;
1062: --
1063: -- Start of fix 3202260

Line 1066: from per_pay_proposals pyp

1062: --
1063: -- Start of fix 3202260
1064: cursor csr_pay_proposal is
1065: select pyp.pay_proposal_id, pyp.object_version_number, pyp.business_group_id
1066: from per_pay_proposals pyp
1067: where pyp.assignment_id = p_assignment_id
1068: and pyp.change_date > p_actual_termination_date
1069: order by pyp.change_date desc;
1070: --Added business_group_id for bug 4689950

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

1337: --
1338: -- Delete any pay proposals for this assignment that occur after the
1339: -- actual termination date.
1340: --
1341: -- After the delete from per_pay_proposals a warning out parameter is set.
1342: --
1343: -- Start of fix 3202260
1344: for rec_pay_prop in csr_pay_proposal loop
1345: --

Line 1368: from per_pay_proposals pyp

1364: --
1365: hr_utility.set_location(l_proc, 234);
1366: --
1367: delete
1368: from per_pay_proposals pyp
1369: where pyp.pay_proposal_id = rec_pay_prop.pay_proposal_id;
1370: --
1371: -- Setting the Warning Out variable
1372: if sql%notfound then

Line 2268: from per_pay_proposals pyp

2264: for update nowait;
2265: --
2266: cursor csr_lock_pyp is
2267: select null
2268: from per_pay_proposals pyp
2269: where pyp.assignment_id = p_assignment_id
2270: for update nowait;
2271: --
2272: -- Start of fix for Bug 2796523