APPS.IGC_CC_REVALUE_PROCESS_PKG dependencies on IGC_CC_PERIODS

Line 46: l_cc_period_status igc_cc_periods.cc_period_status%TYPE;

42: p_request_id IN NUMBER)
43: RETURN BOOLEAN
44: IS
45: l_period_status gl_period_statuses.closing_status%TYPE;
46: l_cc_period_status igc_cc_periods.cc_period_status%TYPE;
47: l_rate NUMBER;
48: l_message igc_cc_process_exceptions.exception_reason%TYPE;
49: BEGIN
50:

Line 210: FROM igc_cc_periods ccp,

206: /* Check whether CC period is open */
207: BEGIN
208: SELECT ccp.cc_period_status
209: INTO l_cc_period_status
210: FROM igc_cc_periods ccp,
211: gl_periods gp ,
212: gl_sets_of_books gb
213: WHERE
214: ccp.period_set_name = gp.period_set_name AND