APPS.HR_PAYMENTS dependencies on DUAL

Line 374: from dual

370: hr_utility.set_location('HR_PAYMENTS.CHECK_PREPAY',1);
371: --
372: select 1
373: into dummy
374: from dual
375: where not exists(
376: select 1
377: from pay_pre_payments pp
378: where pp.org_payment_method_id = opm_id

Line 431: from dual

427: hr_utility.set_location('HR_PAYMENTS.CHECK_PPM',1);
428: --
429: select 1
430: into dummy
431: from dual
432: where not exists(
433: select 1
434: from pay_personal_payment_methods_f ppm
435: where ppm.org_payment_method_id = opm_id

Line 477: from dual

473: hr_utility.set_location('HR_PAYMENTS.CHECK_DEFAULT',1);
474: --
475: select 'Y'
476: into valid_del
477: from dual
478: where not exists(
479: select 1
480: from pay_payrolls_f pp
481: where pp.default_payment_method_id = opm_id

Line 650: from sys.dual

646: hr_utility.set_location('HR_PAYMENTS.UNIQUE_PRIORITY',1);
647: --
648: select 'N'
649: into duplicate
650: from sys.dual
651: where not exists(
652: select 1
653: from pay_personal_payment_methods_f ppm
654: where ppm.assignment_id = assignment

Line 701: from sys.dual

697: -- aren't any after the date.
698: --
699: select 'Y'
700: into status
701: from sys.dual
702: where not exists(
703: select 1
704: from pay_payroll_actions pa,
705: pay_assignment_actions aa,