APPS.PER_CANCEL_HIRE_OR_APL_PKG dependencies on PAY_PERSONAL_PAYMENT_METHODS

Line 205: from pay_personal_payment_methods ppm

201: -- payment cursor
202: --
203: cursor payment is
204: select rowid
205: from pay_personal_payment_methods ppm
206: where ppm.business_group_id = p_business_group_id
207: and exists (select 'exists'
208: from per_all_assignments_f paf
209: where paf.business_group_id +0= p_business_group_id

Line 557: from pay_personal_payment_methods ppm

553: -- payment cursor
554: --
555: cursor payment is
556: select rowid
557: from pay_personal_payment_methods ppm
558: where ppm.business_group_id = p_business_group_id
559: and exists (select 'exists'
560: from per_all_assignments_f paf
561: where paf.business_group_id +0= p_business_group_id

Line 937: from pay_personal_payment_methods ppm

933: -- payment cursor
934: --
935: cursor payment is
936: select rowid
937: from pay_personal_payment_methods ppm
938: where ppm.business_group_id = p_business_group_id
939: and exists (select 'exists'
940: from per_all_assignments_f paf
941: where paf.business_group_id +0= p_business_group_id

Line 1427: from pay_personal_payment_methods ppm

1423: -- payment cursor
1424: --
1425: cursor payment1 is
1426: select rowid
1427: from pay_personal_payment_methods ppm
1428: where ppm.business_group_id = p_business_group_id
1429: and exists (select 'exists'
1430: from per_all_assignments_f paf
1431: where paf.business_group_id +0= p_business_group_id

Line 2198: from pay_personal_payment_methods ppm

2194: -- payment cursor
2195: --
2196: cursor payment1 is
2197: select rowid
2198: from pay_personal_payment_methods ppm
2199: where ppm.business_group_id = p_business_group_id
2200: and exists (select 'exists'
2201: from per_all_assignments_f paf
2202: where paf.business_group_id +0= p_business_group_id

Line 2567: delete from pay_personal_payment_methods ppm

2563: loop
2564: hr_utility.set_location('cancel_hire_or_apl.do_cancel_hire',200);
2565: fetch payment1 into p_rowid;
2566: exit when payment1%NOTFOUND;
2567: delete from pay_personal_payment_methods ppm
2568: where ppm.rowid = p_rowid;
2569: if sql%notfound then
2570: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
2571: hr_utility.set_message_token('PROCEDURE','do_cancel_hire');

Line 4114: FROM pay_personal_payment_methods ppm

4110: -- payment cursor
4111: --
4112: CURSOR csr_payment IS
4113: SELECT ROWID
4114: FROM pay_personal_payment_methods ppm
4115: WHERE ppm.business_group_id = p_business_group_id
4116: AND EXISTS (SELECT 'exists'
4117: FROM per_all_assignments_f paf
4118: WHERE paf.business_group_id +0= p_business_group_id

Line 4549: FROM pay_personal_payment_methods ppm

4545: -- payment cursor
4546: --
4547: CURSOR csr_payment IS
4548: SELECT ROWID
4549: FROM pay_personal_payment_methods ppm
4550: WHERE ppm.business_group_id = p_business_group_id
4551: AND EXISTS (SELECT 'exists'
4552: FROM per_all_assignments_f paf
4553: WHERE paf.business_group_id +0= p_business_group_id

Line 4964: DELETE FROM pay_personal_payment_methods ppm

4960: FOR payment_rec IN csr_payment LOOP
4961: --
4962: hr_utility.set_location(l_proc,220);
4963: --
4964: DELETE FROM pay_personal_payment_methods ppm
4965: WHERE ppm.rowid = payment_rec.rowid;
4966: --
4967: IF SQL%NOTFOUND THEN
4968: --