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_FMP_MR_EFFECTIVITY_PVT dependencies on AHL_MR_INTERVALS

Line 899: FROM AHL_MR_INTERVALS_APP_V INT,

895:
896: CURSOR get_intervals_rec ( c_mr_effectivity_id NUMBER )
897: IS
898: SELECT DISTINCT INT.counter_id
899: FROM AHL_MR_INTERVALS_APP_V INT,
900: AHL_MR_EFFECTIVITIES_APP_V EF
901: WHERE INT.mr_effectivity_id = EF.mr_effectivity_id
902: AND EF.mr_effectivity_id = c_mr_effectivity_id;
903:

Line 1617: DELETE AHL_MR_INTERVALS

1613: NULL;
1614: END IF;
1615:
1616: -- Delete the record in related Tables
1617: DELETE AHL_MR_INTERVALS
1618: WHERE mr_effectivity_id = p_x_effectivity_tbl(i).mr_effectivity_id;
1619:
1620: -- If the record does not exist, then, Continue.
1621: IF ( SQL%ROWCOUNT = 0 ) THEN