DBA Data[Home] [Help]

APPS.PA_PROJECT_WF dependencies on DUAL

Line 574: FROM dual;

570: itemkey => itemkey,
571: aname => 'NOTE' );
572:
573: SELECT pa_obj_status_changes_s.NEXTVAL INTO l_obj_status_change_id
574: FROM dual;
575:
576: OPEN cur_get_system_status(l_success_status_code);
577: FETCH cur_get_system_status INTO l_new_sys_status;
578: CLOSE cur_get_system_status;

Line 716: FROM dual;

712: itemkey => itemkey,
713: aname => 'PROJECT_STATUS_CODE' );
714:
715: SELECT pa_obj_status_changes_s.NEXTVAL INTO l_obj_status_change_id
716: FROM dual;
717:
718: OPEN cur_get_system_status(l_failure_status_code);
719: FETCH cur_get_system_status INTO l_new_sys_status;
720: CLOSE cur_get_system_status;