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 3732: FROM GMO_INSTR_SET_INSTANCE_T

3728: X_LAST_UPDATE_LOGIN => L_LAST_UPDATE_LOGIN
3729: );
3730:
3731: SELECT INSTRUCTION_SET_ID INTO L_INSTRUCTION_SET_ID
3732: FROM GMO_INSTR_SET_INSTANCE_T
3733: WHERE INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID;
3734:
3735: SELECT ENTITY_KEY INTO L_ENTITY_KEY
3736: FROM GMO_INSTR_SET_INSTANCE_VL

Line 4331: FROM GMO_INSTR_SET_INSTANCE_T

4327: X_LAST_UPDATE_LOGIN => L_LAST_UPDATE_LOGIN
4328: );
4329:
4330: SELECT INSTRUCTION_SET_ID INTO L_INSTRUCTION_SET_ID
4331: FROM GMO_INSTR_SET_INSTANCE_T
4332: WHERE INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID;
4333:
4334: -- This must complete optional instructions in temp table for
4335: -- particular session

Line 4786: INSERT INTO GMO_INSTR_SET_INSTANCE_T

4782: LOOP
4783: FETCH L_INSTR_SET_CSR INTO L_INSTR_SET_REC;
4784: EXIT WHEN L_INSTR_SET_CSR%NOTFOUND;
4785:
4786: INSERT INTO GMO_INSTR_SET_INSTANCE_T
4787: (
4788: INSTRUCTION_PROCESS_ID,
4789: INSTRUCTION_SET_ID,
4790: ACKN_STATUS,

Line 6304: FROM GMO_INSTR_SET_INSTANCE_T INSTR_SET,

6300: )
6301: )
6302: )
6303: INTO L_INSTR_XML
6304: FROM GMO_INSTR_SET_INSTANCE_T INSTR_SET,
6305: GMO_INSTR_SET_INSTANCE_VL INSTR_SETVL
6306: WHERE INSTR_SET.INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID
6307: AND INSTR_SETVL.INSTRUCTION_SET_ID = INSTR_SET.INSTRUCTION_SET_ID;
6308: