APPS.GMO_INSTRUCTION_PVT dependencies on GMO_INSTR_INSTANCE_B

Line 3818: UPDATE GMO_INSTR_INSTANCE_B

3814: LAST_UPDATE_LOGIN = L_LAST_UPDATE_LOGIN
3815: WHERE
3816: INSTRUCTION_ID = L_INSTR_REC.INSTRUCTION_ID;
3817:
3818: UPDATE GMO_INSTR_INSTANCE_B
3819: SET
3820: OPERATOR_ACKN = L_INSTR_REC.OPERATOR_ACKN,
3821: TASK_ACKN_STATUS = L_INSTR_REC.TASK_ACKN_STATUS,
3822: TASK_ACKN_DATE = L_INSTR_REC.TASK_ACKN_DATE,

Line 3920: FROM GMO_INSTR_INSTANCE_B

3916: -- Bug 5231778 : update the Instructin Set Status before raising Event
3917: --Set the instruction set status to 'complete' if all the
3918: --instructions are complete in a given instruction set
3919: SELECT COUNT(*) INTO L_INSTRUCTION_COUNT
3920: FROM GMO_INSTR_INSTANCE_B
3921: WHERE INSTR_STATUS <> GMO_CONSTANTS_GRP.G_INSTR_STATUS_COMPLETE
3922: AND INSTRUCTION_SET_ID = L_INSTRUCTION_SET_ID;
3923:
3924: -- Set the Instruction set status to complete

Line 4346: SELECT INSTRUCTION_ID FROM GMO_INSTR_INSTANCE_B

4342: WHERE
4343: INSTR_STATUS = GMO_CONSTANTS_GRP.G_INSTR_STATUS_PENDING
4344: AND
4345: INSTRUCTION_ID IN (
4346: SELECT INSTRUCTION_ID FROM GMO_INSTR_INSTANCE_B
4347: WHERE INSTRUCTION_SET_ID = L_INSTRUCTION_SET_ID
4348: AND INSTR_ACKN_TYPE = GMO_CONSTANTS_GRP.G_INSTR_OPTIONAL
4349: )
4350: AND INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID;