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 554: FROM AHL_VISIT_TASKS_B

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

Line 1108: FROM AHL_VISIT_TASKS_B

1104: -- anraj added for checking whether atleast one task is in status planning
1105: CURSOR c_any_task_in_planning (c_visit_id IN NUMBER)
1106: IS
1107: SELECT 1
1108: FROM AHL_VISIT_TASKS_B
1109: WHERE visit_id = c_visit_id
1110: AND status_code = 'PLANNING';
1111: l_dummy number;
1112: --Standard local variables