APPS.PAY_RUN_BALANCE_BUILD dependencies on DUAL

Line 1060: from sys.dual;

1056: --
1057: /* Have we timed out */
1058: select sysdate
1059: into current_date
1060: from sys.dual;
1061: --
1062: if (current_date > g_timeout) then
1063: /* Error, timed out process */
1064: hr_utility.set_message(801,'PAY_289014_PUR_TIMEOUT');

Line 1217: from dual;

1213: l_attribute_name := 'GEN_BAL_'||p_payroll_action_id;
1214: --
1215: select pay_bal_attribute_definition_s.nextval
1216: into l_attribute_id
1217: from dual;
1218: --
1219: insert into pay_bal_attribute_definitions
1220: (attribute_id,
1221: attribute_name,

Line 1298: from dual

1294: set_run_bal_status(p_payroll_action_id, 'P');
1295: --
1296: lv_sql_string :=
1297: 'select 1
1298: from dual
1299: where 1 = 0
1300: and 1 = :payroll_action_id';
1301: --
1302: /* Only do something meaningful if the legislation rule is set */

Line 1404: from dual;

1400: ) loop
1401: --
1402: select pay_assignment_actions_s.nextval
1403: into ln_lockingactid
1404: from dual;
1405: --
1406: -- insert into pay_assignment_actions.
1407: hr_nonrun_asact.insact(ln_lockingactid,
1408: -1,

Line 1427: from dual;

1423: ) loop
1424: --
1425: select pay_assignment_actions_s.nextval
1426: into ln_lockingactid
1427: from dual;
1428: --
1429: -- insert into pay_assignment_actions.
1430: hr_nonrun_asact.insact(ln_lockingactid,
1431: aarec.assignment_id,