APPS.CS_TP_QUESTIONS_PVT dependencies on CS_TP_QUESTIONS_B

Line 222: select last_update_date, LOOKUP_ID from CS_TP_QUESTIONS_B

218: l_login VARCHAR2(200) :=FND_API.G_MISS_CHAR;
219: l_last_updated_date DATE;
220: l_lookup_id NUMBER;
221: cursor c is
222: select last_update_date, LOOKUP_ID from CS_TP_QUESTIONS_B
223: where QUESTION_ID = P_One_Question.mQuestionID;
224:
225: begin
226: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 344: select lookup_id from CS_TP_QUESTIONS_B where question_id = p_Question_ID;

340: l_freetext_num NUMBER;
341: l_lookup_id Number;
342: i NUMBER;
343: Cursor lookup_c is
344: select lookup_id from CS_TP_QUESTIONS_B where question_id = p_Question_ID;
345:
346: Cursor
347: freetext_num_c (v_lookup_id NUMBER)
348: is select count (*) from CS_TP_FREETEXTS where LOOKUP_ID = v_lookup_id;