[Home] [Help]
88: l_explanation_for_no_flag,
89: l_date_for_yes_flag,
90: l_date_for_no_flag
91: FROM
92: igw_questions
93: WHERE
94: question_number = p_question_number;
95:
96: IF p_explanation IS NULL THEN
168: Fnd_Global.User_Id,
169: Fnd_Global.Login_Id,
170: 1
171: FROM
172: igw_questions
173: WHERE
174: applies_to = 'P' AND
175: SYSDATE >= start_date_active AND
176: (SYSDATE <= end_date_active OR end_date_active IS NULL) AND