APPS.HXT_UTIL dependencies on DUAL

Line 69: FROM dual;

65: BEGIN
66: --
67: SELECT hxt_seqno.nextval
68: INTO l_EXCEP_seqno
69: FROM dual;
70: l_CREATED_BY := FND_GLOBAL.user_id;
71:
72: l_person_id := GetPersonID(p_TIM_ID);
73: l_payroll_id := GetPayrollID(p_PTP_ID);

Line 169: FROM dual;

165: --
166: --
167: SELECT hxt_seqno.nextval
168: INTO l_EXCEP_seqno
169: FROM dual;
170: l_CREATED_BY := FND_GLOBAL.user_id;
171:
172: l_person_id := GetPersonID(p_TIM_ID);
173: l_payroll_id := GetPayrollID(p_PTP_ID);

Line 1270: -- FROM sys.dual;

1266: /* Cursor to generate a new Cost Allocation Keyflex Id */
1267:
1268: --CURSOR flex_id_cur IS
1269: -- SELECT pay_cost_allocation_keyflex_s.nextval
1270: -- FROM sys.dual;
1271:
1272: l_return_code NUMBER;
1273:
1274: --l_concatenated_segments pay_cost_allocation_keyflex.concatenated_segments%TYPE DEFAULT NULL;

Line 2162: FROM dual;

2158: p_valid := 'N';
2159:
2160: SELECT hxt_seqno.nextval
2161: INTO l_EXCEP_seqno
2162: FROM dual;
2163: l_CREATED_BY := FND_GLOBAL.user_id;
2164: l_person_id := GetPersonID(p_TIM_ID); -- ER230
2165: l_payroll_id := GetPayrollID(p_PTP_ID); -- ER230
2166:

Line 2384: from dual;

2380: 4,'WED',
2381: 5,'THU',
2382: 6,'FRI'
2383: )
2384: from dual;
2385:
2386:
2387:
2388: l_week_day varchar2(80) := NULL;