DBA Data[Home] [Help]

APPS.PAY_US_YEPP_ADD_ACTIONS_PKG dependencies on DUAL

Line 383: select 1 from dual

379: cursor c_w2_magtape_run_exists(cp_effective_date date,
380: cp_business_group_id number,
381: cp_gre_type varchar2)
382: is
383: select 1 from dual
384: where exists (
385: select 1
386: from pay_payroll_actions ppa
387: where ppa.business_group_id = cp_business_group_id

Line 729: from dual;

725: hr_utility.set_location(gv_package_name || '.get_eligible_assignments', 110);
726:
727: select pay_assignment_actions_s.nextval
728: into lockingactid
729: from dual;
730:
731: open c_get_asg_id(l_person_id);
732: fetch c_get_asg_id into l_assignment_id;
733: if c_get_asg_id%NOTFOUND then