APPS.AHL_FMP_PVT dependencies on AHL_MR_EFFECTIVITY_EXT_DTLS

Line 2132: FROM ahl_mr_effectivity_ext_dtls a

2128:
2129: -- added for perf fix 9434441
2130: CURSOR get_effect_ext_details(c_mr_effectivity_id NUMBER) IS
2131: SELECT 'Y'
2132: FROM ahl_mr_effectivity_ext_dtls a
2133: WHERE a.mr_effectivity_id = c_mr_effectivity_id
2134: AND rownum < 2;
2135:
2136: /* not used

Line 3519: FROM AHL_MR_EFFECTIVITY_EXT_DTLS

3515:
3516: CURSOR get_effect_ext_detail(c_mr_effectivity_id NUMBER) IS
3517: SELECT exclude_flag, EFFECT_EXT_DTL_REC_TYPE, OWNER_ID, LOCATION_TYPE_CODE,
3518: CSI_EXT_ATTRIBUTE_CODE, CSI_EXT_ATTRIBUTE_VALUE
3519: FROM AHL_MR_EFFECTIVITY_EXT_DTLS
3520: WHERE mr_effectivity_id = c_mr_effectivity_id
3521: AND EFFECT_EXT_DTL_REC_TYPE IN ('OWNER','LOCATION','CSIEXTATTR')
3522: ORDER BY EFFECT_EXT_DTL_REC_TYPE DESC,exclude_flag ASC; --exteremely improtant this --will break if changed
3523:

Line 4706: FROM ahl_mr_effectivity_ext_dtls a

4702:
4703: -- added for perf fix 9434441
4704: CURSOR get_effect_ext_details(c_mr_effectivity_id NUMBER) IS
4705: SELECT 'Y'
4706: FROM ahl_mr_effectivity_ext_dtls a
4707: WHERE a.mr_effectivity_id = c_mr_effectivity_id
4708: AND rownum < 2;
4709:
4710: -- to get configuration nodes.