APPS.IGC_CC_REVAL_FIX_PROCESS_PKG dependencies on IGC_CC_PERIODS

Line 293: l_cc_period_status igc_cc_periods.cc_period_status%TYPE;

289: p_request_id IN NUMBER)
290: RETURN BOOLEAN
291: IS
292: l_period_status gl_period_statuses.closing_status%TYPE;
293: l_cc_period_status igc_cc_periods.cc_period_status%TYPE;
294: l_rate NUMBER;
295: l_message igc_cc_process_exceptions.exception_reason%TYPE;
296: l_cc_num igc_cc_headers.cc_num%TYPE;
297: BEGIN

Line 439: FROM igc_cc_periods ccp,

435: /* Check whether CC period is open */
436: BEGIN
437: SELECT ccp.cc_period_status
438: INTO l_cc_period_status
439: FROM igc_cc_periods ccp,
440: gl_periods gp ,
441: gl_sets_of_books gb
442: WHERE
443: ccp.period_set_name = gp.period_set_name AND