APPS.GMD_OPERATION_ACTIVITIES_PUB dependencies on GMD_OPERATIONS_B

Line 78: FROM gmd_operations_b

74: ins_oprn_actv_err EXCEPTION;
75:
76: CURSOR check_oprn_id (p_oprn_id gmd_operations.oprn_id%TYPE)IS
77: SELECT 1
78: FROM gmd_operations_b
79: WHERE oprn_id = p_oprn_id
80: AND delete_mark = 0;
81:
82: CURSOR check_oprn_no_vers(p_oprn_no gmd_operations.oprn_no%TYPE

Line 85: FROM gmd_operations_b

81:
82: CURSOR check_oprn_no_vers(p_oprn_no gmd_operations.oprn_no%TYPE
83: , p_oprn_vers gmd_operations.oprn_vers%TYPE ) IS
84: SELECT oprn_id
85: FROM gmd_operations_b
86: WHERE oprn_No = p_oprn_no
87: AND oprn_vers = p_oprn_vers
88: and delete_Mark = 0;
89: