APPS.IES_SVY_DPYLMENT_STATUS_PVT dependencies on IES_SVY_DEPLYMENTS_V

Line 28: FROM ies_svy_deplyments_v isdv, ies_svy_cycles_v iscv

24: l_err_buf VARCHAR2(80) := NULL ;
25:
26: CURSOR dep_c IS
27: SELECT survey_deployment_id, isdv.survey_cycle_id , survey_id
28: FROM ies_svy_deplyments_v isdv, ies_svy_cycles_v iscv
29: WHERE response_end_date < sysdate
30: and deployment_status_code = 'ACTIVE'
31: and isdv.survey_cycle_id = iscv.survey_cycle_id
32: FOR UPDATE of deployment_status_code;

Line 38: update ies_svy_deplyments_v

34: begin
35: SAVEPOINT update_deployment_status;
36:
37: for c1_rec in dep_c loop
38: update ies_svy_deplyments_v
39: set deployment_status_code = 'CLOSED'
40: where survey_deployment_id = c1_rec.survey_deployment_id;
41:
42: SELECT count(*)

Line 44: FROM ies_svy_deplyments_v

40: where survey_deployment_id = c1_rec.survey_deployment_id;
41:
42: SELECT count(*)
43: INTO l_dep_count
44: FROM ies_svy_deplyments_v
45: WHERE survey_cycle_id = c1_rec.survey_cycle_id
46: AND deployment_status_code = 'ACTIVE';
47:
48: if (l_dep_count = 0) then