APPS.IES_SVY_DEPLOYMENT_PVT dependencies on IES_SVY_REMINDERS_V

Line 81: FROM IES_SVY_REMINDERS_V SVR

77: ,NVL(SVR.REMINDER_INTERVAL,0) reminder_interval
78: ,SVR.SURVEY_REMINDER_ID survey_reminder_id
79: ,SDP.RESPONSE_END_DATE response_end_date
80: ,SDP.REMINDER_TEMPLATE_ID reminder_template_id
81: FROM IES_SVY_REMINDERS_V SVR
82: ,IES_SVY_DEPLYMENTS_V SDP
83: WHERE SDP.SURVEY_DEPLOYMENT_ID = SVR.SURVEY_DEPLOYMENT_ID
84: AND SDP.SURVEY_DEPLOYMENT_ID = p_deployment_id;
85:

Line 820: FROM ies_svy_reminders_v

816:
817: if (p_reminder_type = 'REMINDER') then
818: SELECT REMINDER_EMAIL_SUBJECT
819: INTO l_subject
820: FROM ies_svy_reminders_v
821: WHERE survey_deployment_id = p_deployment_id;
822: else
823: OPEN CEMAILSUBJECTHEADING;
824: FETCH CEMAILSUBJECTHEADING into l_subject;