DBA Data[Home] [Help]

APPS.IGC_CC_OPEN_INTERFACE_PKG dependencies on IGC_CC_PERIODS

Line 425: igc_cc_periods cp

421: INTO l_COUNT
422: FROM fnd_application app,
423: gl_sets_of_books sob,
424: gl_period_statuses gl,
425: igc_cc_periods cp
426: WHERE sob.set_of_books_id = p_set_of_books_id
427: AND gl.set_of_books_id = sob.set_of_books_id
428: AND gl.application_id = app.application_id
429: AND app.application_short_name = 'SQLGL'

Line 3105: FROM igc_cc_periods ccp, gl_sets_of_books sob, gl_periods glp

3101: P_X_Error_Status);
3102: ELSE
3103: BEGIN
3104: SELECT 1 INTO l_count
3105: FROM igc_cc_periods ccp, gl_sets_of_books sob, gl_periods glp
3106: WHERE sob.set_of_books_id = P_Set_of_Books_Id
3107: AND sob.period_set_name = glp.period_set_name
3108: AND sob.accounted_period_type = glp.period_type
3109: AND glp.adjustment_period_flag = 'N'

Line 4956: FROM igc_cc_periods ccp, gl_sets_of_books sob, gl_period_statuses glp

4952: -- Validate the Cc_Det_Pf_Encmbrnc_Date
4953: IF P_Cc_Det_Pf_Encmbrnc_Date IS NOT NULL THEN
4954: BEGIN
4955: SELECT 1 INTO l_count
4956: FROM igc_cc_periods ccp, gl_sets_of_books sob, gl_period_statuses glp
4957: WHERE sob.set_of_books_id = P_Set_of_Books_Id
4958: AND sob.set_of_books_id = glp.set_of_books_id
4959: AND sob.accounted_period_type = glp.period_type
4960: AND sob.period_set_name = ccp.period_set_name