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 167: FROM dual;

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

Line 1251: -- FROM sys.dual;

1247: /* Cursor to generate a new Cost Allocation Keyflex Id */
1248:
1249: --CURSOR flex_id_cur IS
1250: -- SELECT pay_cost_allocation_keyflex_s.nextval
1251: -- FROM sys.dual;
1252:
1253: l_return_code NUMBER;
1254:
1255: --l_concatenated_segments pay_cost_allocation_keyflex.concatenated_segments%TYPE DEFAULT NULL;

Line 2082: FROM dual;

2078: p_valid := 'N';
2079:
2080: SELECT hxt_seqno.nextval
2081: INTO l_EXCEP_seqno
2082: FROM dual;
2083: l_CREATED_BY := FND_GLOBAL.user_id;
2084: l_person_id := GetPersonID(p_TIM_ID); -- ER230
2085: l_payroll_id := GetPayrollID(p_PTP_ID); -- ER230
2086:

Line 2302: from dual;

2298: 4,'WED',
2299: 5,'THU',
2300: 6,'FRI'
2301: )
2302: from dual;
2303:
2304:
2305:
2306: l_week_day varchar2(80) := NULL;