APPS.PAY_YREND_REPORTS_PKG dependencies on DUAL

Line 283: from dual;

279: -- for each assignment/pre-payment/reversal).
280:
281: select pay_assignment_actions_s.nextval
282: into lockingactid
283: from dual;
284:
285: hr_utility.set_location(l_procedure_name, 30);
286: -- insert the action record.
287: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);

Line 352: ' AND exists ( select 1 from dual

348: close c_state_ueid;
349:
350: hr_utility.set_location(l_procedure_name, 70);
351: c_actions_with_state_sql := c_actions_with_state_sql ||
352: ' AND exists ( select 1 from dual
353: where 1 =
354: --bug 7392315
355: -- (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
356: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,1,1)

Line 388: ' AND exists ( select 1 from dual

384: close c_state_ueid;
385:
386: hr_utility.set_location(l_procedure_name, 90);
387: c_actions_with_state_sql := c_actions_with_state_sql ||
388: ' AND exists ( select 1 from dual
389: where 1 =
390: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
391: from ff_archive_items fai,
392: ff_archive_item_contexts fic1,

Line 422: ' AND exists ( select 1 from dual

418: hr_utility.trace('l_subj_whable='||l_subj_whable);
419: hr_utility.trace('l_subj_nwhable='||l_subj_nwhable);
420:
421: c_actions_with_state_sql := c_actions_with_state_sql ||
422: ' AND exists ( select 1 from dual
423: where 1 =
424: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
425: from ff_archive_items fai,
426: ff_archive_item_contexts fic1,

Line 453: ' AND exists ( select 1 from dual

449: fetch c_state_ueid into l_subj_nwhable;
450: close c_state_ueid;
451:
452: c_actions_with_state_sql := c_actions_with_state_sql ||
453: ' AND exists ( select 1 from dual
454: where 1 =
455: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)
456: from ff_archive_items fai,
457: ff_archive_item_contexts fic1,

Line 487: from dual;

483:
484: hr_utility.set_location(l_procedure_name, 160);
485: select pay_assignment_actions_s.nextval
486: into lockingactid
487: from dual;
488:
489: -- insert the action record.
490: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
491:

Line 521: from dual;

517:
518: hr_utility.set_location(l_procedure_name, 180);
519: select pay_assignment_actions_s.nextval
520: into lockingactid
521: from dual;
522:
523: -- insert the action record.
524: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
525:

Line 706: from dual

702: --
703: cursor csr_inv_act
704: is
705: select 'Y'
706: from dual
707: where exists(
708: select /*+ ORDERED */
709: null
710: from pay_payroll_actions ppa,