DBA Data[Home] [Help]

APPS.PAY_BATCH_BALANCEADJ_WRAPPER dependencies on DUAL

Line 154: from dual;

150: hr_utility.trace('exception: no data found');
151:
152: --select max(batch_id) into p_batch_id
153: select pay_batch_headers_s.nextval into p_batch_id
154: from dual;
155:
156: -- create batch header
157:
158: insert into pay_balance_batch_headers

Line 1476: from dual;

1472: if lv_batch_group_exists = 'N' then
1473:
1474: hr_utility.trace('No data found for pay_adjust_batch_groups ');
1475: select pay_adjust_batch_groups_s.nextval into l_batch_group_id
1476: from dual;
1477:
1478: insert into pay_adjust_batch_groups
1479: (batch_group_id,
1480: batch_id,