APPS.GMO_INSTRUCTION_PVT dependencies on GMO_INSTR_SET_INSTANCE_T

Line 3673: FROM GMO_INSTR_SET_INSTANCE_T

3669: L_ENTITY_KEY VARCHAR2(500);
3670:
3671: CURSOR L_TEMP_INSTR_SET_CSR IS
3672: SELECT INSTRUCTION_SET_ID, INSTRUCTION_PROCESS_ID, ACKN_STATUS
3673: FROM GMO_INSTR_SET_INSTANCE_T
3674: WHERE INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID;
3675:
3676: CURSOR L_TEMP_INSTR_CSR IS
3677: SELECT TEMP.INSTRUCTION_PROCESS_ID, TEMP.INSTRUCTION_ID, PERM.INSTRUCTION_SET_ID,

Line 3738: FROM GMO_INSTR_SET_INSTANCE_T

3734: X_LAST_UPDATE_LOGIN => L_LAST_UPDATE_LOGIN
3735: );
3736:
3737: SELECT INSTRUCTION_SET_ID INTO L_INSTRUCTION_SET_ID
3738: FROM GMO_INSTR_SET_INSTANCE_T
3739: WHERE INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID;
3740:
3741: SELECT ENTITY_KEY INTO L_ENTITY_KEY
3742: FROM GMO_INSTR_SET_INSTANCE_VL

Line 4353: FROM GMO_INSTR_SET_INSTANCE_T

4349: X_LAST_UPDATE_LOGIN => L_LAST_UPDATE_LOGIN
4350: );
4351:
4352: SELECT INSTRUCTION_SET_ID INTO L_INSTRUCTION_SET_ID
4353: FROM GMO_INSTR_SET_INSTANCE_T
4354: WHERE INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID;
4355:
4356: -- This must complete optional instructions in temp table for
4357: -- particular session

Line 4808: INSERT INTO GMO_INSTR_SET_INSTANCE_T

4804: LOOP
4805: FETCH L_INSTR_SET_CSR INTO L_INSTR_SET_REC;
4806: EXIT WHEN L_INSTR_SET_CSR%NOTFOUND;
4807:
4808: INSERT INTO GMO_INSTR_SET_INSTANCE_T
4809: (
4810: INSTRUCTION_PROCESS_ID,
4811: INSTRUCTION_SET_ID,
4812: ACKN_STATUS,

Line 6327: FROM GMO_INSTR_SET_INSTANCE_T INSTR_SET,

6323: )
6324: )
6325: )
6326: INTO L_INSTR_XML
6327: FROM GMO_INSTR_SET_INSTANCE_T INSTR_SET,
6328: GMO_INSTR_SET_INSTANCE_VL INSTR_SETVL
6329: WHERE INSTR_SET.INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID
6330: AND INSTR_SETVL.INSTRUCTION_SET_ID = INSTR_SET.INSTRUCTION_SET_ID;
6331: