APPS.GMO_INSTRUCTION_PVT dependencies on GMO_INSTR_DEFN_VL

Line 149: GMO_INSTR_DEFN_VL

145: SELECT INSTRUCTION_ID, INSTRUCTION_SET_ID, INSTRUCTION_TEXT,
146: TASK_ID, TASK_ATTRIBUTE, TASK_ATTRIBUTE_ID, TASK_LABEL, INSTR_SEQ,
147: INSTR_ACKN_TYPE, INSTR_NUMBER
148: FROM
149: GMO_INSTR_DEFN_VL
150: WHERE INSTRUCTION_SET_ID = L_INSTRUCTION_SET_ID;
151:
152: CURSOR L_GMO_INSTR_APPR_CSR IS
153: SELECT INSTRUCTION_ID, APPROVER_SEQ,

Line 1027: FROM GMO_INSTR_DEFN_VL

1023: SELECT INSTRUCTION_ID, INSTRUCTION_SET_ID,
1024: INSTR_SEQ, TASK_ID, TASK_ATTRIBUTE_ID,
1025: TASK_ATTRIBUTE, INSTR_ACKN_TYPE, INSTR_NUMBER,
1026: INSTRUCTION_TEXT, TASK_LABEL
1027: FROM GMO_INSTR_DEFN_VL
1028: WHERE
1029: INSTRUCTION_SET_ID = L_INSTRUCTION_SET_ID;
1030:
1031: CURSOR L_INSTR_APPR_DEFN_CSR IS

Line 1202: INSERT INTO GMO_INSTR_DEFN_VL

1198: P_TASK_ATTRIBUTE_ID => L_INSTR_DEFN_REC.TASK_ATTRIBUTE_ID
1199: );
1200: end if;
1201:
1202: INSERT INTO GMO_INSTR_DEFN_VL
1203: (
1204: INSTRUCTION_ID,
1205: INSTRUCTION_SET_ID,
1206: INSTR_SEQ,

Line 1901: INSERT INTO GMO_INSTR_DEFN_VL

1897: --Bug 5224619: end
1898:
1899: ELSE
1900:
1901: INSERT INTO GMO_INSTR_DEFN_VL
1902: (
1903: INSTRUCTION_ID,
1904: INSTRUCTION_SET_ID,
1905: INSTR_SEQ,

Line 2308: FROM GMO_INSTR_DEFN_VL

2304: CURSOR L_INSTR_DEFN_CSR IS
2305: SELECT INSTRUCTION_ID, INSTRUCTION_SET_ID, INSTRUCTION_TEXT,
2306: INSTR_SEQ, INSTR_NUMBER, INSTR_ACKN_TYPE,
2307: TASK_LABEL, TASK_ATTRIBUTE, TASK_ATTRIBUTE_ID, TASK_ID
2308: FROM GMO_INSTR_DEFN_VL
2309: WHERE
2310: INSTRUCTION_SET_ID = L_INSTRUCTION_SET_ID;
2311:
2312: CURSOR L_INSTR_APPR_DEFN_CSR IS

Line 3223: FROM GMO_INSTR_DEFN_VL INSTR_DEFN, GMO_INSTR_TASK_DEFN_VL TSK

3219: CURSOR L_INSTR_CSR IS
3220: SELECT INSTR_DEFN.INSTRUCTION_ID, INSTR_DEFN.INSTRUCTION_SET_ID,
3221: INSTR_DEFN.INSTRUCTION_TEXT,
3222: INSTR_DEFN.TASK_ATTRIBUTE, TSK.TASK_NAME, TSK.DISPLAY_NAME
3223: FROM GMO_INSTR_DEFN_VL INSTR_DEFN, GMO_INSTR_TASK_DEFN_VL TSK
3224: WHERE INSTR_DEFN.INSTRUCTION_SET_ID = L_INSTRUCTION_SET_ID
3225: AND INSTR_DEFN.TASK_ID = TSK.TASK_ID;
3226:
3227: L_INSTR_REC L_INSTR_CSR%ROWTYPE;

Line 6021: from gmo_instr_defn_vl

6017: cursor get_instr_detail is
6018: select instruction_id, task_id, task_attribute_id,
6019: task_attribute, instr_ackn_type,
6020: instruction_text, task_label
6021: from gmo_instr_defn_vl
6022: where instruction_id = l_instruction_id;
6023:
6024: cursor get_instr_appr_detail is
6025: select approver_seq, role_name, role_count