APPS.PER_CHECKLIST_EVENTS dependencies on DUAL

Line 1308: INTO l_target_end_date FROM DUAL;

1304: ELSIF lr_tasks.target_duration_uom = 'W' THEN
1305: l_target_end_date := SYSDATE + (7 * lr_tasks.target_duration);
1306: ELSIF lr_tasks.target_duration_uom = 'M' THEN
1307: SELECT ADD_MONTHS(SYSDATE,lr_tasks.target_duration)
1308: INTO l_target_end_date FROM DUAL;
1309: END IF;
1310: ELSE
1311: l_target_end_date := NULL;
1312: END IF;

Line 1394: INTO l_person_id FROM dual;

1390: IS
1391: l_person_id per_people_f.person_id%type;
1392: BEGIN
1393: select substr(p_transaction_id,instr(p_transaction_id,'-')+1,length(p_transaction_id))
1394: INTO l_person_id FROM dual;
1395:
1396: RETURN l_person_id ;
1397: END get_person_id ;
1398: --

Line 1406: INTO l_person_id FROM dual;

1402: l_supervisor_id per_assignments_f.supervisor_id%type;
1403: l_effective_date per_ben_identified_events.effective_date%type;
1404: BEGIN
1405: select substr(p_transaction_id,instr(p_transaction_id,'-')+1,length(p_transaction_id))
1406: INTO l_person_id FROM dual;
1407: -- first get the effective_date from per_ben_identified_events table. we expect that there would be only one event with status 'PENDING'
1408: SELECT effective_date
1409: INTO l_effective_date
1410: FROM per_ben_identified_events