APPS.GMO_INSTRUCTION_PVT dependencies on GMO_INSTR_APPR_DEFN_S

Line 2002: UPDATE GMO_INSTR_APPR_DEFN SET

1998: WHERE INSTRUCTION_ID = L_INSTRUCTION_ID
1999: AND APPROVER_SEQ = L_TEMP_INSTR_APPR_DEFN_REC.APPROVER_SEQ;
2000:
2001: IF ( L_INSTR_APPR_COUNT > 0) THEN
2002: UPDATE GMO_INSTR_APPR_DEFN SET
2003: ROLE_COUNT = L_TEMP_INSTR_APPR_DEFN_REC.ROLE_COUNT,
2004: ROLE_NAME = L_TEMP_INSTR_APPR_DEFN_REC.ROLE_NAME,
2005: LAST_UPDATE_DATE = L_LAST_UPDATE_DATE,
2006: LAST_UPDATED_BY = L_LAST_UPDATED_BY,

Line 6196: select gmo_instr_appr_defn_s.nextval

6192: loop
6193: fetch get_instr_appr_detail into l_approver_seq,l_role_name, l_appr_count;
6194: exit when get_instr_appr_detail%notfound;
6195:
6196: select gmo_instr_appr_defn_s.nextval
6197: into l_approver_seq from dual;
6198:
6199: insert into
6200: gmo_instr_appr_defn_t