APPS.PAY_BATCH_LINK_PROCESS_PKG dependencies on DUAL

Line 95: from dual;

91: return false;
92: end if;
93: --
94: select sysdate into l_current_time
95: from dual;
96: --
97: if p_start_time is null then
98: --
99: p_start_time := l_current_time;

Line 910: l_sql := 'select nvl(1,:payroll_action_id) from dual where 1 = 0';

906: --
907: if g_standard_links.count = 0 and
908: g_pg_links.count = 0 then
909:
910: l_sql := 'select nvl(1,:payroll_action_id) from dual where 1 = 0';
911:
912: elsif g_pg_links.count > 0 then
913: -- include non-emp assignments for ALUs.
914: l_sql :=

Line 1035: from dual;

1031: )
1032: loop
1033: --
1034: select pay_assignment_actions_s.nextval into l_asgact_id
1035: from dual;
1036: --
1037: -- Create assignment action.
1038: --
1039: hr_nonrun_asact.insact

Line 1201: from dual

1197: --
1198: cursor csr_action_status
1199: is
1200: select 'I'
1201: from dual
1202: where exists
1203: (select null
1204: from pay_assignment_actions paa
1205: where paa.payroll_action_id = p_payroll_action_id