DBA Data[Home] [Help]

APPS.HR_BALANCES dependencies on DUAL

Line 1032: FROM sys.dual;

1028: hr_utility.set_location('INS_MANUAL_FEED', 4);
1029: --
1030: SELECT pay_balance_feeds_s.nextval
1031: INTO v_sequence
1032: FROM sys.dual;
1033: --
1034: INSERT INTO pay_balance_feeds_f
1035: (balance_feed_id,
1036: effective_start_date,

Line 1168: FROM sys.dual;

1164: bt_rec.a_last_updated_by,
1165: bt_rec.a_last_update_login,
1166: bt_rec.a_created_by,
1167: trunc(sysdate)
1168: FROM sys.dual;
1169: --
1170: IF p_mode <> 'USER' THEN
1171: ins_application_ownership(bt_rec.a_balance_feed_id,
1172: iv_rec.a_input_value_id,

Line 1233: FROM sys.dual;

1229: OR iv_rec.a_effective_end_date IS NULL;
1230: --
1231: SELECT pay_balance_feeds_s.nextval
1232: INTO v_sequence
1233: FROM sys.dual;
1234: --
1235: INSERT INTO pay_balance_feeds_f
1236: (balance_feed_id,
1237: effective_start_date,

Line 1264: FROM sys.dual;

1260: -1,
1261: -1,
1262: -1,
1263: trunc(sysdate)
1264: FROM sys.dual;
1265: --
1266: IF p_mode <> 'USER' THEN
1267: ins_application_ownership(v_sequence,
1268: NULL,

Line 1318: FROM sys.dual;

1314: FOR iv_rec IN cur_iv_sub_bal_class LOOP
1315: --
1316: SELECT pay_balance_feeds_s.nextval
1317: INTO v_sequence
1318: FROM sys.dual;
1319: --
1320: INSERT INTO pay_balance_feeds_f
1321: (balance_feed_id,
1322: effective_start_date,

Line 1350: FROM sys.dual;

1346: -1,
1347: -1,
1348: -1,
1349: trunc(sysdate)
1350: FROM sys.dual;
1351: --
1352: IF p_mode <> 'USER' THEN
1353: ins_application_ownership(v_sequence,
1354: NULL,

Line 1408: FROM sys.dual;

1404: hr_utility.set_location('INS_PRIMARY_BALANCE_FEED', 4);
1405: --
1406: SELECT pay_balance_feeds_s.nextval
1407: INTO v_sequence
1408: FROM sys.dual;
1409: --
1410: hr_utility.set_location('INS_PRIMARY_BALANCE_FEED', 5);
1411: --
1412: INSERT INTO pay_balance_feeds_f