APPS.AHL_PRD_DF_PVT dependencies on AHL_UE_DEFERRAL_DETAILS_V

Line 405: FROM ahl_ue_deferral_details_v

401:
402: CURSOR unit_effectivity_info_csr(p_unit_effectivity_id IN NUMBER) IS
403: SELECT mr_header_id,cs_incident_id,repetitive_mr_flag,orig_deferral_ue_id,ue_status_code,
404: def_status_code,manually_planned_flag
405: FROM ahl_ue_deferral_details_v
406: WHERE unit_effectivity_id = p_unit_effectivity_id
407: AND APPLICATION_USG_CODE = RTRIM(LTRIM(FND_PROFILE.VALUE('AHL_APPLN_USAGE'))) ;
408:
409: l_mr_header_id NUMBER;

Line 5385: FROM ahl_ue_deferral_details_v

5381: -- to fecth context information
5382: CURSOR context_info_csr(p_unit_effectivity_id IN NUMBER) IS
5383: SELECT due_date, mr_header_id,title,description,repetitive_mr_flag,cs_incident_id,cs_incident_number,
5384: cs_incident_summary,manually_planned_flag
5385: FROM ahl_ue_deferral_details_v
5386: WHERE unit_effectivity_id = p_unit_effectivity_id
5387: AND APPLICATION_USG_CODE = RTRIM(LTRIM(FND_PROFILE.VALUE('AHL_APPLN_USAGE'))) ;--this takes care of app_usage changes
5388:
5389: -- mr status meaning has to be fecthed seperately because function returns only code

Line 5844: FROM ahl_ue_deferral_details_v

5840:
5841: -- to fecth context information
5842: CURSOR applicable_ue_csr(p_unit_effectivity_id IN NUMBER) IS
5843: SELECT orig_deferral_ue_id,ue_status_code,def_status_code
5844: FROM ahl_ue_deferral_details_v
5845: WHERE unit_effectivity_id = p_unit_effectivity_id;
5846:
5847: l_orig_deferral_ue_id NUMBER;
5848: l_ue_status_code VARCHAR2(30);