APPS.JTF_DIAGNOSTIC_COREAPI dependencies on GL_SETS_OF_BOOKS

Line 510: from gl_sets_of_books a,

506: select a.name sobname,
507: count(b.period_name) total_periods,
508: count(decode(b.closing_status,'O',b.PERIOD_NAME,null)) open_periods,
509: a.accounted_period_type period_type
510: from gl_sets_of_books a,
511: gl_period_statuses b
512: where a.set_of_books_id = b.set_of_books_id (+)
513: and b.application_id = p_appId
514: and a.set_of_books_id = p_sobId

Line 2725: from gl_sets_of_books a,

2721: select a.name sobname,
2722: count(b.period_name) total_periods,
2723: count(decode(b.closing_status,'O',b.PERIOD_NAME,null)) open_periods,
2724: a.accounted_period_type period_type
2725: from gl_sets_of_books a,
2726: gl_period_statuses b
2727: where a.set_of_books_id = b.set_of_books_id (+)
2728: and b.application_id = p_appId
2729: and a.set_of_books_id = p_sobId