DBA Data[Home] [Help]

APPS.AHL_UMP_PROCESSUNIT_PVT dependencies on AHL_UNIT_DEFERRALS_VL

Line 3636: FROM ahl_unit_effectivities_app_v ue, ahl_unit_deferrals_vl ud

3632: -- get the unit effectivity record for init-due for this mr and item.
3633: CURSOR ahl_init_due_csr (p_csi_item_instance_id IN NUMBER,
3634: p_mr_header_id IN NUMBER) IS
3635: SELECT ud.set_due_date, ue.unit_effectivity_id, ud.unit_deferral_id
3636: FROM ahl_unit_effectivities_app_v ue, ahl_unit_deferrals_vl ud
3637: WHERE ue.unit_effectivity_id = ud.unit_effectivity_id AND
3638: ud.unit_deferral_type = 'INIT-DUE' AND
3639: ue.csi_item_instance_id = p_csi_item_instance_id AND
3640: ue.mr_header_id = p_mr_header_id AND