DBA Data[Home] [Help]

APPS.PAY_NL_TAXOFFICE_ARCHIVE dependencies on DUAL

Line 554: FROM dual;

550: /* Creating the archive assignment action */
551:
552: SELECT pay_assignment_actions_s.NEXTVAL
553: INTO l_asg_act_id
554: FROM dual;
555: --
556: -- Create the archive assignment action
557: --
558: if g_debug then

Line 2725: select 1 from dual

2721: ,p_tax_year_end_date date) return varchar2 is
2722:
2723: CURSOR csr_si_insured_flag(lp_element_name varchar2) is
2724: /* 14934414 */
2725: select 1 from dual
2726: where exists
2727: (select /*+ USE_NL(paa, ppa, pet,prr) */ prr.run_result_id,ppa.date_earned from pay_payroll_actions ppa
2728: ,pay_assignment_actions paa
2729: ,pay_run_results prr