DBA Data[Home] [Help]

APPS.IGW_REPORT_PROCESSING dependencies on IGW_ORG_QUESTIONS

Line 342: from igw_org_questions

338: cursor c_org_questions is
339: select organization_id
340: , question_number
341: , explanation
342: from igw_org_questions
343: where explanation is not null;
344: BEGIN
345: fnd_msg_pub.initialize;
346:

Line 1063: from igw_org_questions

1059: select answer,
1060: explanation
1061: into p_response1,
1062: p_response2
1063: from igw_org_questions
1064: where organization_id = p_organization_id
1065: and question_number = p_question_no;
1066: else
1067: select answer,

Line 1099: from igw_org_questions

1095: question_number = p_question_no;
1096: elsif p_organization_id is not null then
1097: select answer
1098: into v_response
1099: from igw_org_questions
1100: where organization_id = p_organization_id
1101: and question_number = p_question_no;
1102: else
1103: select answer

Line 1132: from igw_org_questions

1128: question_number = p_question_no;
1129: elsif p_organization_id is not null then
1130: select explanation
1131: into v_explanation
1132: from igw_org_questions
1133: where organization_id = p_organization_id
1134: and question_number = p_question_no;
1135: else
1136: select explanation