APPS.IGC_CC_OPEN_INTERFACE_PKG dependencies on GL_SETS_OF_BOOKS

Line 355: FROM gl_sets_of_books

351:
352: BEGIN
353: SELECT NVL(enable_budgetary_control_flag,'N')
354: INTO p_sbc_enable_flag
355: FROM gl_sets_of_books
356: WHERE set_of_books_id = p_set_of_books_id;
357:
358: EXCEPTION
359: WHEN NO_DATA_FOUND

Line 423: gl_sets_of_books sob,

419: -- gl_period_statuses_v gl,
420: SELECT count(*)
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

Line 1181: gl_sets_of_books sob

1177: SELECT gp.period_name,
1178: gp.period_num,
1179: gp.period_year
1180: FROM gl_periods gp,
1181: gl_sets_of_books sob
1182: WHERE gp.period_set_name = sob.period_set_name
1183: AND gp.period_type = sob.accounted_period_type
1184: AND sob.set_of_books_id = p_sob_id
1185: AND p_date BETWEEN gp.start_date AND gp.end_date

Line 1420: GL_SETS_OF_BOOKS GB

1416: CURSOR c_fiscal_year_dates(P_Sob_Id NUMBER)
1417: IS
1418: SELECT MIN(start_date) start_date, MAX(end_date) end_date
1419: FROM GL_PERIODS GP,
1420: GL_SETS_OF_BOOKS GB
1421: WHERE
1422: GP.period_set_name = GB.period_set_name AND
1423: GP.period_type = GB.accounted_period_type AND
1424: GB.set_of_books_id = P_Sob_Id AND

Line 1511: FROM gl_sets_of_books

1507:
1508: -- Get the Functional Currency Code
1509: BEGIN
1510: SELECT currency_code INTO l_func_currency_code
1511: FROM gl_sets_of_books
1512: WHERE set_of_books_id = l_current_set_of_books_id;
1513: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
1514: END;
1515:

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