DBA Data[Home] [Help]

APPS.GMF_SUBLEDGER_PKG dependencies on GL_SETS_OF_BOOKS

Line 1182: gl_sets_of_books gsb

1178: SELECT DISTINCT glp.period_year
1179: FROM
1180: gl_periods glp,
1181: gl_period_sets gps,
1182: gl_sets_of_books gsb
1183: WHERE
1184: glp.period_year = cp_fiscal_year
1185: AND gsb.set_of_books_id = cp_ledger_id
1186: AND gsb.period_set_name = glp.period_set_name

Line 1201: gl_sets_of_books gsob

1197: glp.start_date, glp.end_date, sts.closing_status
1198: FROM
1199: gl_periods glp,
1200: gl_period_statuses sts,
1201: gl_sets_of_books gsob
1202: WHERE
1203: glp.period_set_name = gsob.period_set_name -- use the sob period-name
1204: AND glp.period_type = gsob.accounted_period_type -- and sob period-type
1205: AND gsob.set_of_books_id = cp_ledger_id