APPS.IES_SVY_DPYLMENT_STATUS_PVT dependencies on IES_SVY_CYCLES_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 49: UPDATE ies_svy_cycles_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
49: UPDATE ies_svy_cycles_v
50: SET cycle_status_code = 'OPEN'
51: WHERE survey_cycle_id = c1_rec.survey_cycle_id;
52: end if;
53:

Line 56: FROM ies_svy_cycles_v

52: end if;
53:
54: select count(*)
55: INTO l_cycle_count
56: FROM ies_svy_cycles_v
57: WHERE survey_id = c1_rec.survey_id
58: AND cycle_status_code = 'ACTIVE';
59:
60: if (l_cycle_count = 0) then