APPS.PAY_JP_SPR_EFILE_PKG dependencies on DUAL

Line 1618: from dual

1614: --
1615: cursor csr_arch_pact_exist
1616: is
1617: select 'Y'
1618: from dual
1619: where not exists(
1620: select null
1621: from hr_organization_information hoi,
1622: hr_all_organization_units hou

Line 1913: -- from dual

1909: -- end if;
1910: ----
1911: -- p_sqlstr :=
1912: -- 'select 1
1913: -- from dual
1914: -- where :payroll_action_id < 0';
1915: ----
1916: --else
1917: --

Line 2300: from dual;

2296: if l_ass_valid then
2297: --
2298: select pay_assignment_actions_s.nextval
2299: into l_spr_assignment_action_id
2300: from dual;
2301: --
2302: hr_nonrun_asact.insact(
2303: lockingactid => l_spr_assignment_action_id,
2304: assignid => g_ass_ind_tbl(l_ass_id_tbl(t)).assignment_id,