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.

APPS.AHL_PRD_DF_PVT dependencies on AHL_MR_HEADERS_B

Line 2729: FROM AHL_MR_HEADERS_B MR, AHL_UNIT_EFFECTIVITIES_B UE -- Undid blind changes for app_usage code

2725:
2726: CURSOR whichever_first_code_csr (p_unit_effectivity_id IN NUMBER) IS
2727: SELECT whichever_first_code
2728: --FROM AHL_MR_HEADERS_APP_V MR, AHL_UNIT_EFFECTIVITIES_APP_V UE
2729: FROM AHL_MR_HEADERS_B MR, AHL_UNIT_EFFECTIVITIES_B UE -- Undid blind changes for app_usage code
2730: WHERE MR.mr_header_id = UE.mr_header_id
2731: AND UE.unit_effectivity_id = p_unit_effectivity_id;
2732:
2733: l_whichever_first_code ahl_mr_headers_b.whichever_first_code%TYPE;

Line 2733: l_whichever_first_code ahl_mr_headers_b.whichever_first_code%TYPE;

2729: FROM AHL_MR_HEADERS_B MR, AHL_UNIT_EFFECTIVITIES_B UE -- Undid blind changes for app_usage code
2730: WHERE MR.mr_header_id = UE.mr_header_id
2731: AND UE.unit_effectivity_id = p_unit_effectivity_id;
2732:
2733: l_whichever_first_code ahl_mr_headers_b.whichever_first_code%TYPE;
2734:
2735:
2736: CURSOR next_due_date_csr(p_unit_effectivity_id IN NUMBER) IS
2737: SELECT UE.due_date

Line 5966: from ahl_mr_headers_b MR,ahl_unit_effectivities_b UE, csi_item_instances ii

5962: -- added active_end_date to fix bug# 12776603; sorao for backporting project
5963: CURSOR get_mr_details_csr(p_unit_effectivity_id IN NUMBER) IS
5964: SELECT MR.mr_header_id,MR.title,MR.effective_from,MR.effective_to,MR.version_number,UE.csi_item_instance_id,
5965: ii.active_end_date
5966: from ahl_mr_headers_b MR,ahl_unit_effectivities_b UE, csi_item_instances ii
5967: WHERE MR.mr_header_id = UE.mr_header_id
5968: AND UE.csi_item_instance_id = ii.instance_id
5969: AND UE.unit_effectivity_id = p_unit_effectivity_id;
5970:

Line 5973: l_title ahl_mr_headers_b.title%TYPE;

5969: AND UE.unit_effectivity_id = p_unit_effectivity_id;
5970:
5971:
5972: l_mr_header_id NUMBER;
5973: l_title ahl_mr_headers_b.title%TYPE;
5974: l_effective_from DATE;
5975: l_effective_to DATE;
5976: l_version_number ahl_mr_headers_b.version_number%TYPE;
5977: l_item_instance_id NUMBER;

Line 5976: l_version_number ahl_mr_headers_b.version_number%TYPE;

5972: l_mr_header_id NUMBER;
5973: l_title ahl_mr_headers_b.title%TYPE;
5974: l_effective_from DATE;
5975: l_effective_to DATE;
5976: l_version_number ahl_mr_headers_b.version_number%TYPE;
5977: l_item_instance_id NUMBER;
5978: l_active_end_date DATE;
5979:
5980: -- cursor fixed for bug 9143707

Line 5984: Select mr_header_id FROM ahl_mr_headers_b

5980: -- cursor fixed for bug 9143707
5981: CURSOR get_new_mr_details_csr(p_title IN VARCHAR2,
5982: p_mr_header_id IN NUMBER,
5983: p_version_number IN NUMBER) IS
5984: Select mr_header_id FROM ahl_mr_headers_b
5985: WHERE title = p_title
5986: AND version_number > p_version_number
5987: AND sysdate between effective_from and NVL(effective_to,SYSDATE+1)
5988: AND MR_status_code = 'COMPLETE'