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_LTP_MATRL_AVAL_PUB dependencies on AHL_VISIT_TASKS_B

Line 551: FROM AHL_VISIT_TASKS_B

547: -- anraj added for checking whether atleast one task is in status planning
548: CURSOR c_any_task_in_planning (c_visit_id IN NUMBER)
549: IS
550: SELECT 1
551: FROM AHL_VISIT_TASKS_B
552: WHERE visit_id = c_visit_id
553: AND status_code = 'PLANNING';
554:
555: l_dummy number;

Line 1087: FROM AHL_VISIT_TASKS_B

1083: -- anraj added for checking whether atleast one task is in status planning
1084: CURSOR c_any_task_in_planning (c_visit_id IN NUMBER)
1085: IS
1086: SELECT 1
1087: FROM AHL_VISIT_TASKS_B
1088: WHERE visit_id = c_visit_id
1089: AND status_code = 'PLANNING';
1090: l_dummy number;
1091: --Standard local variables