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.IGC_CC_APPROVAL_WF_PKG dependencies on IGC_CC_CONTROL_FUNCTIONS

Line 3085: FROM igc_cc_control_functions

3081: AND effective_end_date;
3082:
3083: CURSOR c_control_func_info IS
3084: SELECT control_group_id
3085: FROM igc_cc_control_functions
3086: WHERE sysdate BETWEEN NVL(start_date,sysdate-1) AND NVL(end_date,sysdate+1)
3087: AND ( (l_pos_id IS NOT NULL AND position_id = l_pos_id)
3088: OR (l_job_id IS NOT NULL AND job_id = l_job_id)
3089: )

Line 3097: CURSOR c_pos_cont_func_info(p_position_id igc_cc_control_functions.position_id%TYPE) IS

3093:
3094: -- CBC CC Bug 2111529 07-Feb-2001 S Brewer Start(7)
3095: -- Cursor to find control group for the position (if position hierarchies
3096: -- are being used)
3097: CURSOR c_pos_cont_func_info(p_position_id igc_cc_control_functions.position_id%TYPE) IS
3098: SELECT control_group_id
3099: FROM igc_cc_control_functions
3100: WHERE sysdate BETWEEN nvl(start_date,sysdate) AND nvl(end_date,sysdate)
3101: AND position_id = p_position_id

Line 3099: FROM igc_cc_control_functions

3095: -- Cursor to find control group for the position (if position hierarchies
3096: -- are being used)
3097: CURSOR c_pos_cont_func_info(p_position_id igc_cc_control_functions.position_id%TYPE) IS
3098: SELECT control_group_id
3099: FROM igc_cc_control_functions
3100: WHERE sysdate BETWEEN nvl(start_date,sysdate) AND nvl(end_date,sysdate)
3101: AND position_id = p_position_id
3102: AND cc_state = g_cc_state
3103: AND cc_type = g_cc_type