APPS.PAY_NL_ANNUAL_SI_FILE dependencies on DUAL

Line 660: (select hr_nl_org_info.get_tax_org_id(p_org_struct_version_id,paa.organization_id) from dual)

656: and asg.effective_start_date <= p_Tax_Year_End_Date
657: and nvl(asg.effective_end_date, p_Tax_Year_End_Date) >= p_Tax_Year_Start_Date
658: )
659: and p_employer_id in
660: (select hr_nl_org_info.get_tax_org_id(p_org_struct_version_id,paa.organization_id) from dual)
661: and not exists
662: (select 1
663: from
664: pay_action_information ee_ats

Line 760: FROM dual;

756: and Lock the Latest Payroll Run Assignment Action for the Assignment
757: */
758: SELECT pay_assignment_actions_s.NEXTVAL
759: INTO l_asg_act_id
760: FROM dual;
761: --
762: -- Create the archive assignment action
763: --
764: hr_nonrun_asact.insact(l_asg_act_id,l_Assignment_ID, p_payroll_action_id,p_chunk,NULL);