APPS.HR_LOC_ABSENCE dependencies on DUAL

Line 249: SELECT REPLACE(l_plsql_block, '', l_entry_package) INTO l_plsql_block FROM dual;

245: l_plsql_block := 'BEGIN (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14
246: ,:15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26
247: ,:27, :28, :29, :30, :31, :32, :33, :34, :36); END;';
248:
249: SELECT REPLACE(l_plsql_block, '', l_entry_package) INTO l_plsql_block FROM dual;
250: --
251: EXECUTE IMMEDIATE l_plsql_block
252: USING l_abs_rec.person_id
253: ,p_absence_attendance_id

Line 296: SELECT REPLACE(l_plsql_block, '', l_entry_package) INTO l_plsql_block FROM dual;

292: :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36); END;';
293:
294: hr_utility.set_location(' b4 execute imm of function ', 25);
295:
296: SELECT REPLACE(l_plsql_block, '', l_entry_package) INTO l_plsql_block FROM dual;
297: --
298: EXECUTE IMMEDIATE l_plsql_block
299: USING out l_return
300: ,p_assignment_id