eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.AHL_UMP_SMRINSTANCE_PVT dependencies on AHL_UNIT_DEFERRALS_B

Line 229: from ahl_unit_deferrals_b, fnd_lookup_values_vl fk

225: cursor get_deferral_sts (p_ue_id in number) IS
226: select decode(unit_deferral_type, 'MEL', 'MEL ' || fk.meaning,
227: 'CDL', 'CDL ' || fk.meaning,
228: fk.meaning) deferral_meaning
229: from ahl_unit_deferrals_b, fnd_lookup_values_vl fk
230: where unit_effectivity_id = p_ue_id
231: and fk.lookup_type = 'AHL_PRD_DF_APPR_STATUS_TYPES'
232: and fk.lookup_code = approval_status_code;
233:

Line 237: from ahl_unit_deferrals_b udf, fnd_lookup_values_vl fk

233:
234: -- get deferral status for open UMP rows.
235: cursor get_open_deferral_sts (p_ue_id in number) IS
236: select fk.meaning defer_meaning
237: from ahl_unit_deferrals_b udf, fnd_lookup_values_vl fk
238: where udf.unit_effectivity_id = p_ue_id
239: and fk.lookup_code = decode(udf.approval_status_code, 'DRAFT',
240: 'DEFERRAL_DRAFT',udf.approval_status_code)
241: and fk.lookup_type = 'AHL_PRD_DF_APPR_STATUS_TYPES'

Line 247: from ahl_unit_deferrals_b udf, fnd_lookup_values_vl fk

243:
244: -- get mel/cdl status for open UMP rows.
245: cursor get_open_mel_cdl_sts (p_ue_id in number) IS
246: select unit_deferral_type || ' ' || fk.meaning defer_meaning
247: from ahl_unit_deferrals_b udf, fnd_lookup_values_vl fk
248: where udf.unit_effectivity_id = p_ue_id
249: and fk.lookup_code = decode(udf.approval_status_code, 'DEFERRED',
250: 'APPROVED',udf.approval_status_code)
251: and fk.lookup_type = 'AHL_PRD_DF_APPR_STATUS_TYPES'

Line 619: l_sql_string := l_sql_string || ' AND EXISTS (Select ''x'' FROM ahl_unit_deferrals_b WHERE unit_effectivity_id = UMP.unit_effectivity_id AND approval_status_code = :DEFERRAL_STATUS) ';

615: 'DEFERRAL_REJECTED',
616: 'DRAFT')
617: THEN
618: l_sql_string := l_sql_string || ' AND (UMP.status_code IS NULL OR UMP.status_code = ''INIT-DUE'') ';
619: l_sql_string := l_sql_string || ' AND EXISTS (Select ''x'' FROM ahl_unit_deferrals_b WHERE unit_effectivity_id = UMP.unit_effectivity_id AND approval_status_code = :DEFERRAL_STATUS) ';
620: l_bindvar_tbl(l_bind_index) := p_search_mr_instance_rec.mr_status;
621: l_bind_index := l_bind_index + 1;
622: /*
623: ELSIF p_search_mr_instance_rec.mr_status like 'CDL%' THEN

Line 624: l_sql_string := l_sql_string || ' AND EXISTS (Select ''x'' FROM ahl_unit_deferrals_b WHERE unit_effectivity_id = UMP.unit_effectivity_id AND unit_deferral_type = ''CDL'' AND approval_status_code = :CDL_STATUS) ';

620: l_bindvar_tbl(l_bind_index) := p_search_mr_instance_rec.mr_status;
621: l_bind_index := l_bind_index + 1;
622: /*
623: ELSIF p_search_mr_instance_rec.mr_status like 'CDL%' THEN
624: l_sql_string := l_sql_string || ' AND EXISTS (Select ''x'' FROM ahl_unit_deferrals_b WHERE unit_effectivity_id = UMP.unit_effectivity_id AND unit_deferral_type = ''CDL'' AND approval_status_code = :CDL_STATUS) ';
625: l_bindvar_tbl(l_bind_index) := 'CDL:' || p_search_mr_instance_rec.mr_status;
626: l_bind_index := l_bind_index + 1;
627: ELSIF p_search_mr_instance_rec.mr_status like 'MEL%' THEN
628: l_sql_string := l_sql_string || ' AND EXISTS (Select ''x'' FROM ahl_unit_deferrals_b WHERE unit_effectivity_id = UMP.unit_effectivity_id AND unit_deferral_type = ''MEL'' AND approval_status_code = :MEL_STATUS) ';

Line 628: l_sql_string := l_sql_string || ' AND EXISTS (Select ''x'' FROM ahl_unit_deferrals_b WHERE unit_effectivity_id = UMP.unit_effectivity_id AND unit_deferral_type = ''MEL'' AND approval_status_code = :MEL_STATUS) ';

624: l_sql_string := l_sql_string || ' AND EXISTS (Select ''x'' FROM ahl_unit_deferrals_b WHERE unit_effectivity_id = UMP.unit_effectivity_id AND unit_deferral_type = ''CDL'' AND approval_status_code = :CDL_STATUS) ';
625: l_bindvar_tbl(l_bind_index) := 'CDL:' || p_search_mr_instance_rec.mr_status;
626: l_bind_index := l_bind_index + 1;
627: ELSIF p_search_mr_instance_rec.mr_status like 'MEL%' THEN
628: l_sql_string := l_sql_string || ' AND EXISTS (Select ''x'' FROM ahl_unit_deferrals_b WHERE unit_effectivity_id = UMP.unit_effectivity_id AND unit_deferral_type = ''MEL'' AND approval_status_code = :MEL_STATUS) ';
629: l_bindvar_tbl(l_bind_index) := 'MEL:' || p_search_mr_instance_rec.mr_status;
630: l_bind_index := l_bind_index + 1;
631: */
632: ELSE