DBA Data[Home] [Help]

APPS.PAY_RUN_BALANCE_BUILD dependencies on DUAL

Line 1305: from sys.dual;

1301: --
1302: /* Have we timed out */
1303: select sysdate
1304: into current_date
1305: from sys.dual;
1306: --
1307: if (current_date > g_timeout) then
1308: /* Error, timed out process */
1309: hr_utility.set_message(801,'PAY_289014_PUR_TIMEOUT');

Line 1469: from dual;

1465: l_attribute_name := 'GEN_BAL_'||p_payroll_action_id;
1466: --
1467: select pay_bal_attribute_definition_s.nextval
1468: into l_attribute_id
1469: from dual;
1470: --
1471: insert into pay_bal_attribute_definitions
1472: (attribute_id,
1473: attribute_name,

Line 1593: from dual

1589: set_run_bal_status(p_payroll_action_id, 'P');
1590: --
1591: lv_sql_string :=
1592: 'select 1
1593: from dual
1594: where 1 = 0
1595: and 1 = :payroll_action_id';
1596: --
1597: /* Only do something meaningful if the legislation rule is set */

Line 1721: from dual;

1717: ) loop
1718: --
1719: select pay_assignment_actions_s.nextval
1720: into ln_lockingactid
1721: from dual;
1722: --
1723: -- insert into pay_assignment_actions.
1724: hr_nonrun_asact.insact(ln_lockingactid,
1725: -1,