DBA Data[Home] [Help]

APPS.AHL_PRD_DF_PVT dependencies on AHL_MR_HEADERS_B

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

2647:
2648: CURSOR whichever_first_code_csr (p_unit_effectivity_id IN NUMBER) IS
2649: SELECT whichever_first_code
2650: --FROM AHL_MR_HEADERS_APP_V MR, AHL_UNIT_EFFECTIVITIES_APP_V UE
2651: FROM AHL_MR_HEADERS_B MR, AHL_UNIT_EFFECTIVITIES_B UE -- Undid blind changes for app_usage code
2652: WHERE MR.mr_header_id = UE.mr_header_id
2653: AND UE.unit_effectivity_id = p_unit_effectivity_id;
2654:
2655: l_whichever_first_code ahl_mr_headers_b.whichever_first_code%TYPE;

Line 2655: l_whichever_first_code ahl_mr_headers_b.whichever_first_code%TYPE;

2651: FROM AHL_MR_HEADERS_B MR, AHL_UNIT_EFFECTIVITIES_B UE -- Undid blind changes for app_usage code
2652: WHERE MR.mr_header_id = UE.mr_header_id
2653: AND UE.unit_effectivity_id = p_unit_effectivity_id;
2654:
2655: l_whichever_first_code ahl_mr_headers_b.whichever_first_code%TYPE;
2656:
2657:
2658: CURSOR next_due_date_csr(p_unit_effectivity_id IN NUMBER) IS
2659: SELECT UE.due_date