[Home] [Help]
1051: select answer,
1052: explanation
1053: into p_response1,
1054: p_response2
1055: from igw_prop_questions
1056: where proposal_id = p_proposal_id and
1057: question_number = p_question_no;
1058: elsif p_organization_id is not null then
1059: select answer,
1089: begin
1090: if p_person_id is null and p_organization_id is null then
1091: select answer
1092: into v_response
1093: from igw_prop_questions
1094: where proposal_id = p_proposal_id and
1095: question_number = p_question_no;
1096: elsif p_organization_id is not null then
1097: select answer
1122: begin
1123: if p_person_id is null and p_organization_id is null then
1124: select explanation
1125: into v_explanation
1126: from igw_prop_questions
1127: where proposal_id = p_proposal_id and
1128: question_number = p_question_no;
1129: elsif p_organization_id is not null then
1130: select explanation