APPS.HR_PAYMENTS dependencies on DUAL

Line 379: from dual

375: hr_utility.set_location('HR_PAYMENTS.CHECK_PREPAY',1);
376: --
377: select 1
378: into dummy
379: from dual
380: where not exists(
381: select 1
382: from pay_pre_payments pp
383: where pp.org_payment_method_id = opm_id

Line 436: from dual

432: hr_utility.set_location('HR_PAYMENTS.CHECK_PPM',1);
433: --
434: select 1
435: into dummy
436: from dual
437: where not exists(
438: select 1
439: from pay_personal_payment_methods_f ppm
440: where ppm.org_payment_method_id = opm_id

Line 482: from dual

478: hr_utility.set_location('HR_PAYMENTS.CHECK_DEFAULT',1);
479: --
480: select 'Y'
481: into valid_del
482: from dual
483: where not exists(
484: select 1
485: from pay_payrolls_f pp
486: where pp.default_payment_method_id = opm_id

Line 655: from sys.dual

651: hr_utility.set_location('HR_PAYMENTS.UNIQUE_PRIORITY',1);
652: --
653: select 'N'
654: into duplicate
655: from sys.dual
656: where not exists(
657: select 1
658: from pay_personal_payment_methods_f ppm
659: where ppm.assignment_id = assignment

Line 706: from sys.dual

702: -- aren't any after the date.
703: --
704: select 'Y'
705: into status
706: from sys.dual
707: where not exists(
708: select 1
709: from pay_payroll_actions pa,
710: pay_assignment_actions aa,

Line 782: from sys.dual

778: hr_utility.set_location('HR_PAYMENTS.CHECK_PPM',2);
779:
780: select 'Y'
781: into status
782: from sys.dual
783: where not exists(
784: select 1
785: from pay_payroll_actions pa,
786: pay_assignment_actions aa,