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 240: from ahl_unit_deferrals_b, fnd_lookup_values_vl fk

236: cursor get_deferral_sts (p_ue_id in number) IS
237: select decode(unit_deferral_type, 'MEL', 'MEL ' || fk.meaning,
238: 'CDL', 'CDL ' || fk.meaning,
239: fk.meaning) deferral_meaning
240: from ahl_unit_deferrals_b, fnd_lookup_values_vl fk
241: where unit_effectivity_id = p_ue_id
242: and fk.lookup_type = 'AHL_PRD_DF_APPR_STATUS_TYPES'
243: and fk.lookup_code = approval_status_code;
244:

Line 248: from ahl_unit_deferrals_b udf, fnd_lookup_values_vl fk

244:
245: -- get deferral status for open UMP rows.
246: cursor get_open_deferral_sts (p_ue_id in number) IS
247: select fk.meaning defer_meaning
248: from ahl_unit_deferrals_b udf, fnd_lookup_values_vl fk
249: where udf.unit_effectivity_id = p_ue_id
250: and fk.lookup_code = decode(udf.approval_status_code,
251: 'DEFERRAL_PENDING', DECODE(NVL(udf.cancel_flag,'N'),'Y','CANCEL_PENDING','DEFERRAL_PENDING'),
252: 'DEFERRAL_REJECTED', DECODE(NVL(udf.cancel_flag,'N'),'Y','CANCEL_REJECTED','DEFERRAL_REJECTED'),

Line 261: from ahl_unit_deferrals_b udf, fnd_lookup_values_vl fk

257:
258: -- get mel/cdl status for open UMP rows.
259: cursor get_open_mel_cdl_sts (p_ue_id in number) IS
260: select unit_deferral_type || ' ' || fk.meaning defer_meaning
261: from ahl_unit_deferrals_b udf, fnd_lookup_values_vl fk
262: where udf.unit_effectivity_id = p_ue_id
263: and fk.lookup_code = decode(udf.approval_status_code, 'DEFERRED',
264: 'APPROVED',udf.approval_status_code)
265: and fk.lookup_type = 'AHL_PRD_DF_APPR_STATUS_TYPES'

Line 687: 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) ';

683: 'DEFERRAL_REJECTED',
684: 'DRAFT')
685: THEN
686: l_sql_string := l_sql_string || ' AND (UMP.status_code IS NULL OR UMP.status_code = ''INIT-DUE'') ';
687: 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) ';
688: IF(p_search_mr_instance_rec.mr_status = 'CANCEL_REJECTED')THEN
689: l_bindvar_tbl(l_bind_index) := 'DEFERRAL_REJECTED';
690: ELSIF (p_search_mr_instance_rec.mr_status = 'CANCEL_PENDING')THEN
691: l_bindvar_tbl(l_bind_index) := 'DEFERRAL_PENDING';

Line 698: 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) ';

694: END IF;
695: l_bind_index := l_bind_index + 1;
696: /*
697: ELSIF p_search_mr_instance_rec.mr_status like 'CDL%' THEN
698: 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) ';
699: l_bindvar_tbl(l_bind_index) := 'CDL:' || p_search_mr_instance_rec.mr_status;
700: l_bind_index := l_bind_index + 1;
701: ELSIF p_search_mr_instance_rec.mr_status like 'MEL%' THEN
702: 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 702: 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) ';

698: 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) ';
699: l_bindvar_tbl(l_bind_index) := 'CDL:' || p_search_mr_instance_rec.mr_status;
700: l_bind_index := l_bind_index + 1;
701: ELSIF p_search_mr_instance_rec.mr_status like 'MEL%' THEN
702: 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) ';
703: l_bindvar_tbl(l_bind_index) := 'MEL:' || p_search_mr_instance_rec.mr_status;
704: l_bind_index := l_bind_index + 1;
705: */
706: ELSE