APPS.PER_CANCEL_HIRE_OR_APL_PKG dependencies on PAY_PERSONAL_PAYMENT_METHODS

Line 37: from pay_personal_payment_methods ppm

33: -- payment cursor
34: --
35: cursor payment is
36: select rowid
37: from pay_personal_payment_methods ppm
38: where ppm.business_group_id = p_business_group_id
39: and exists (select 'exists'
40: from per_all_assignments_f paf
41: where paf.business_group_id +0= p_business_group_id

Line 389: from pay_personal_payment_methods ppm

385: -- payment cursor
386: --
387: cursor payment is
388: select rowid
389: from pay_personal_payment_methods ppm
390: where ppm.business_group_id = p_business_group_id
391: and exists (select 'exists'
392: from per_all_assignments_f paf
393: where paf.business_group_id +0= p_business_group_id

Line 753: from pay_personal_payment_methods ppm

749: -- payment cursor
750: --
751: cursor payment is
752: select rowid
753: from pay_personal_payment_methods ppm
754: where ppm.business_group_id = p_business_group_id
755: and exists (select 'exists'
756: from per_all_assignments_f paf
757: where paf.business_group_id +0= p_business_group_id

Line 1287: from pay_personal_payment_methods ppm

1283: -- payment cursor
1284: --
1285: cursor payment1 is
1286: select rowid
1287: from pay_personal_payment_methods ppm
1288: where ppm.business_group_id = p_business_group_id
1289: and exists (select 'exists'
1290: from per_all_assignments_f paf
1291: where paf.business_group_id +0= p_business_group_id

Line 1647: delete from pay_personal_payment_methods ppm

1643: loop
1644: hr_utility.set_location('cancel_hire_or_apl.do_cancel_hire',200);
1645: fetch payment1 into p_rowid;
1646: exit when payment1%NOTFOUND;
1647: delete from pay_personal_payment_methods ppm
1648: where ppm.rowid = p_rowid;
1649: if sql%notfound then
1650: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1651: hr_utility.set_message_token('PROCEDURE','do_cancel_hire');

Line 2936: FROM pay_personal_payment_methods ppm

2932: -- payment cursor
2933: --
2934: CURSOR csr_payment IS
2935: SELECT ROWID
2936: FROM pay_personal_payment_methods ppm
2937: WHERE ppm.business_group_id = p_business_group_id
2938: AND EXISTS (SELECT 'exists'
2939: FROM per_all_assignments_f paf
2940: WHERE paf.business_group_id +0= p_business_group_id

Line 3334: FROM pay_personal_payment_methods ppm

3330: -- payment cursor
3331: --
3332: CURSOR csr_payment IS
3333: SELECT ROWID
3334: FROM pay_personal_payment_methods ppm
3335: WHERE ppm.business_group_id = p_business_group_id
3336: AND EXISTS (SELECT 'exists'
3337: FROM per_all_assignments_f paf
3338: WHERE paf.business_group_id +0= p_business_group_id

Line 3690: DELETE FROM pay_personal_payment_methods ppm

3686: FOR payment_rec IN csr_payment LOOP
3687: --
3688: hr_utility.set_location(l_proc,220);
3689: --
3690: DELETE FROM pay_personal_payment_methods ppm
3691: WHERE ppm.rowid = payment_rec.rowid;
3692: --
3693: IF SQL%NOTFOUND THEN
3694: --