DBA Data[Home] [Help]

APPS.IGC_CC_PO_INTERFACE_PKG dependencies on GL_SETS_OF_BOOKS

Line 632: FROM gl_periods gp, gl_sets_of_books gb

628: /* Removed the hard coded reference to period type of CC Month to fix bug 1427486*/
629: BEGIN
630: SELECT period_name
631: INTO l_po_dist_rec.gl_encumbered_period_name
632: FROM gl_periods gp, gl_sets_of_books gb
633: WHERE gb.set_of_books_id = p_cc_headers_rec.set_of_books_id AND
634: gp.period_set_name = gb.period_set_name AND
635: /* Begin Fix for bug 1569257 */
636: gp.adjustment_period_flag = 'N' AND

Line 815: GL_SETS_OF_BOOKS GB

811: CURSOR c_fiscal_year_dates(p_sob_id NUMBER)
812: IS
813: SELECT MIN(start_date) start_date, MAX(end_date) end_date
814: FROM GL_PERIODS GP,
815: GL_SETS_OF_BOOKS GB
816: WHERE
817: GP.period_set_name = GB.period_set_name AND
818: GP.period_type = GB.accounted_period_type AND
819: GB.set_of_books_id = p_sob_id AND

Line 1216: GL_SETS_OF_BOOKS GB

1212: CURSOR c_fiscal_year_dates(p_sob_id NUMBER)
1213: IS
1214: SELECT MIN(start_date) start_date, MAX(end_date) end_date
1215: FROM GL_PERIODS GP,
1216: GL_SETS_OF_BOOKS GB
1217: WHERE
1218: GP.period_set_name = GB.period_set_name AND
1219: GP.period_type = GB.accounted_period_type AND
1220: GB.set_of_books_id = p_sob_id AND