APPS.AHL_PRD_WORKORDER_PVT dependencies on DUAL

Line 75: FROM dual;

71: )
72: )
73: )
74: INTO l_file_dir
75: FROM dual;
76:
77: -- check if the dir is valid
78: BEGIN
79: fileHandler := UTL_FILE.FOPEN(l_file_dir , filename, 'w');

Line 2549: FROM DUAL;

2545: BEGIN
2546:
2547: SELECT AHL_WORKORDERS_S.NEXTVAL
2548: INTO p_x_prd_workorder_rec.WORKORDER_ID
2549: FROM DUAL;
2550:
2551: IF p_x_prd_workorder_rec.MASTER_WORKORDER_FLAG = 'Y' AND p_x_prd_workorder_rec.VISIT_TASK_ID IS NULL THEN
2552: -- As per ER 4460913
2553: -- Visit master workorder name will be -

Line 2573: FROM DUAL;

2569: WHERE ORGANIZATION_ID=p_x_prd_workorder_rec.ORGANIZATION_ID;
2570:
2571: SELECT p_x_prd_workorder_rec.JOB_NUMBER||TO_CHAR(AHL_WORKORDER_JOB_S.NEXTVAL)
2572: INTO p_x_prd_workorder_rec.JOB_NUMBER
2573: FROM DUAL;
2574:
2575: --Adithya added for Accounting class bug#
2576: IF p_x_prd_workorder_rec.CLASS_CODE is NULL and p_x_prd_workorder_rec.ROUTE_ID IS NOT NULL THEN
2577: OPEN get_route_acc_class_code(p_x_prd_workorder_rec.ROUTE_ID);