DBA Data[Home] [Help]

APPS.GMF_SUBLEDGER_PKG dependencies on GL_SETS_OF_BOOKS

Line 741: gl_sets_of_books gsb

737: SELECT DISTINCT glp.period_year
738: FROM
739: gl_periods glp,
740: gl_period_sets gps,
741: gl_sets_of_books gsb
742: WHERE
743: glp.period_year = cp_fiscal_year
744: AND gsb.set_of_books_id = cp_ledger_id
745: AND gsb.period_set_name = glp.period_set_name

Line 760: gl_sets_of_books gsob

756: glp.start_date, glp.end_date, sts.closing_status
757: FROM
758: gl_periods glp,
759: gl_period_statuses sts,
760: gl_sets_of_books gsob
761: WHERE
762: glp.period_set_name = gsob.period_set_name -- use the sob period-name
763: AND glp.period_type = gsob.accounted_period_type -- and sob period-type
764: AND gsob.set_of_books_id = cp_ledger_id