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 2721: from gl_sets_of_books a,

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