APPS.GMD_STATUS_PUB dependencies on GMD_STATUS_NEXT

Line 116: l_target_status gmd_status_next.target_status%TYPE;

112: l_from_status_desc gmd_status.description%TYPE;
113: l_to_status_type gmd_status_b.status_type%TYPE;
114: l_to_status_desc gmd_status.description%TYPE;
115:
116: l_target_status gmd_status_next.target_status%TYPE;
117: l_rework_status gmd_status_next.rework_status%TYPE;
118: l_pending_status gmd_status_next.pending_status%TYPE;
119: l_mesg_text VARCHAR2(1000);
120:

Line 117: l_rework_status gmd_status_next.rework_status%TYPE;

113: l_to_status_type gmd_status_b.status_type%TYPE;
114: l_to_status_desc gmd_status.description%TYPE;
115:
116: l_target_status gmd_status_next.target_status%TYPE;
117: l_rework_status gmd_status_next.rework_status%TYPE;
118: l_pending_status gmd_status_next.pending_status%TYPE;
119: l_mesg_text VARCHAR2(1000);
120:
121: l_eSignature_status VARCHAR2(10);

Line 118: l_pending_status gmd_status_next.pending_status%TYPE;

114: l_to_status_desc gmd_status.description%TYPE;
115:
116: l_target_status gmd_status_next.target_status%TYPE;
117: l_rework_status gmd_status_next.rework_status%TYPE;
118: l_pending_status gmd_status_next.pending_status%TYPE;
119: l_mesg_text VARCHAR2(1000);
120:
121: l_eSignature_status VARCHAR2(10);
122: l_check_vr NUMBER;

Line 136: FROM gmd_status a, gmd_status_next b

132: -- Checks if there is a target status for current status */
133: CURSOR validate_To_status(vStatus_to VARCHAR2
134: ,vStatus_from VARCHAR2) IS
135: SELECT a.status_type, a.description, b.target_status
136: FROM gmd_status a, gmd_status_next b
137: WHERE a.status_code = vStatus_from
138: AND b.target_status = vStatus_to
139: AND a.status_code = b.current_status;
140: