APPS.IES_SVY_DEPLOYMENT_PVT dependencies on IES_SVY_DEPLYMENTS_V

Line 82: ,IES_SVY_DEPLYMENTS_V SDP

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:
86: BEGIN

Line 197: FROM ies_svy_deplyments_v

193: -- FND_REQUEST.SUBMIT_REQUEST for each request
194:
195: SELECT response_end_date
196: INTO l_response_end_date
197: FROM ies_svy_deplyments_v
198: WHERE survey_deployment_id = p_deployment_id;
199:
200: l_reminder_type := 'REMINDER';
201: l_reminder_flag := FALSE;

Line 993: UPDATE ies_svy_deplyments_v

989: SET survey_sent_date = sysdate
990: WHERE survey_deployment_id = p_deployment_id;
991:
992: -- Update FM Request ID
993: UPDATE ies_svy_deplyments_v
994: SET fulfillment_req_id = l_request_id
995: WHERE survey_deployment_id = p_deployment_id;
996:
997: ELSIF(p_reminder_type = 'REMINDER') THEN

Line 1332: FROM IES_SVY_DEPLYMENTS_V

1328: IF (p_reminder_type is null) THEN
1329:
1330: SELECT DEPLOYMENT_STATUS_CODE, SURVEY_CYCLE_ID
1331: INTO l_deployment_status_code, l_survey_cycle_id
1332: FROM IES_SVY_DEPLYMENTS_V
1333: WHERE SURVEY_DEPLOYMENT_ID = p_dep_id;
1334:
1335: SELECT count(*)
1336: INTO l_dep_count_active

Line 1337: FROM IES_SVY_DEPLYMENTS_V

1333: WHERE SURVEY_DEPLOYMENT_ID = p_dep_id;
1334:
1335: SELECT count(*)
1336: INTO l_dep_count_active
1337: FROM IES_SVY_DEPLYMENTS_V
1338: WHERE SURVEY_CYCLE_ID = l_survey_cycle_id
1339: AND DEPLOYMENT_STATUS_CODE = 'ACTIVE';
1340:
1341: if (p_update_flag = 'Y') then

Line 1342: UPDATE IES_SVY_DEPLYMENTS_V

1338: WHERE SURVEY_CYCLE_ID = l_survey_cycle_id
1339: AND DEPLOYMENT_STATUS_CODE = 'ACTIVE';
1340:
1341: if (p_update_flag = 'Y') then
1342: UPDATE IES_SVY_DEPLYMENTS_V
1343: SET DEPLOYMENT_STATUS_CODE = p_status
1344: where survey_deployment_id = p_dep_id;
1345: end if;
1346: