APPS.PAY_JP_GENERIC_UPGRADE_PKG dependencies on DUAL

Line 102: from dual

98: --
99: cursor csr_exists is
100: /* Obsoleted for performance reasons
101: select 'TRUE'
102: from dual
103: where exists(
104: select null
105: from pay_jp_pre_tax ppt,
106: pay_assignment_actions paa

Line 154: from dual

150: --
151: cursor csr_ppt is
152: /*
153: select 'Y'
154: from dual
155: where exists(
156: select null
157: from pay_jp_pre_tax ppt,
158: pay_assignment_actions paa

Line 266: from dual

262: c_proc constant varchar2(61) := c_package || 'validate_prev_job';
263: --
264: cursor csr_exists is
265: select 'TRUE'
266: from dual
267: where exists(
268: select null
269: from pay_element_types_f pet,
270: pay_element_links_f pel,

Line 300: from dual

296: c_proc constant varchar2(61) := c_package || 'qualify_prev_job';
297: --
298: cursor csr_ee is
299: select 'Y'
300: from dual
301: where exists(
302: select null
303: from pay_element_types_f pet,
304: pay_element_links_f pel,

Line 590: from dual

586: -- Check whether either any element entries or run results exist.
587: --
588: cursor csr_exists is
589: select 'Y'
590: from dual
591: where exists(
592: select /*+ ORDERED
593: NO_MERGE(BG)
594: USE_NL(PEL PEE)

Line 647: from dual

643: -- Check whether either any element entries or run results exist.
644: --
645: cursor csr_exists is
646: select 'Y'
647: from dual
648: where exists(
649: select /*+ ORDERED
650: USE_NL(PEE)
651: INDEX(PEL PAY_ELEMENT_LINKS_F_N7)

Line 689: from dual

685: -- Check whether either any element entries or run results exist.
686: --
687: cursor csr_exists is
688: select 'Y'
689: from dual
690: where exists(
691: select null -- Removed the Hint Bug# 4674234
692: from pay_element_entries_f pee
693: where pee.assignment_id = p_assignment_id)

Line 729: from dual

725: -- Check whether either any element entries or run results exist.
726: --
727: cursor csr_exists is
728: select 'Y'
729: from dual
730: where exists(
731: select /*+ ORDERED
732: USE_NL(PEE)
733: INDEX(PEL PAY_ELEMENT_LINKS_F_N7)

Line 1796: from dual

1792: -- using PACT level archive data.
1793: --
1794: cursor csr_upgrade_required is
1795: select 'Y'
1796: from dual
1797: where exists(
1798: select null
1799: from pay_assignment_actions paa,
1800: pay_payroll_actions ppa