DBA Data[Home] [Help]

APPS.PA_PROJECT_WF dependencies on DUAL

Line 552: FROM dual;

548: itemkey => itemkey,
549: aname => 'NOTE' );
550:
551: SELECT pa_obj_status_changes_s.NEXTVAL INTO l_obj_status_change_id
552: FROM dual;
553:
554: OPEN cur_get_system_status(l_success_status_code);
555: FETCH cur_get_system_status INTO l_new_sys_status;
556: CLOSE cur_get_system_status;

Line 694: FROM dual;

690: itemkey => itemkey,
691: aname => 'PROJECT_STATUS_CODE' );
692:
693: SELECT pa_obj_status_changes_s.NEXTVAL INTO l_obj_status_change_id
694: FROM dual;
695:
696: OPEN cur_get_system_status(l_failure_status_code);
697: FETCH cur_get_system_status INTO l_new_sys_status;
698: CLOSE cur_get_system_status;