DBA Data[Home] [Help]

APPS.HXT_TIME_GEN dependencies on DUAL

Line 1224: FROM DUAL;

1220: -- PUBLIC procedure to get next sequence number from HXT_SEQNO.
1221: CURSOR cur_id
1222: IS
1223: SELECT hxt_seqno.NEXTVAL
1224: FROM DUAL;
1225:
1226: l_nextval NUMBER;
1227: BEGIN
1228: -- Get next value

Line 1256: FROM DUAL; --SPR C166 BY BC

1252: g_sub_loc := 'OPEN cur_id';
1253:
1254: SELECT pay_batch_headers_s.NEXTVAL
1255: INTO l_nextval
1256: FROM DUAL; --SPR C166 BY BC
1257:
1258: RETURN (l_nextval);
1259: EXCEPTION
1260: WHEN OTHERS

Line 1616: FROM SYS.DUAL;

1612: -- together summary and detail rows on the timecard.
1613: --
1614: CURSOR C IS
1615: SELECT HXT_GROUP_ID_S.NEXTVAL
1616: FROM SYS.DUAL;
1617: BEGIN
1618: g_sub_loc := 'Get_Group_ID';
1619: OPEN C;
1620: FETCH C