DBA Data[Home] [Help]

APPS.PAY_NL_TAXOFFICE_ARCHIVE dependencies on DUAL

Line 555: FROM dual;

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

Line 2753: select 1 from dual

2749: ,p_tax_year_end_date date) return varchar2 is
2750:
2751: CURSOR csr_si_insured_flag(lp_element_name varchar2) is
2752: /* 14934414 */
2753: select 1 from dual
2754: where exists
2755: (select /*+ USE_NL(paa, ppa, pet,prr) */ prr.run_result_id,ppa.date_earned from
2756: pay_payrolls_f ppf
2757: ,pay_payroll_actions ppa