APPS.PNP_UTIL_FUNC dependencies on GL_SETS_OF_BOOKS

Line 1772: FROM gl_sets_of_books gl_sob

1768:
1769:
1770: CURSOR get_coa_id (p_set_of_books_id IN NUMBER) IS
1771: SELECT gl_sob.chart_of_accounts_id
1772: FROM gl_sets_of_books gl_sob
1773: WHERE gl_sob.set_of_books_id = l_set_of_books_id;
1774:
1775: BEGIN
1776:

Line 1995: FROM gl_sets_of_books

1991: p_org_id));
1992:
1993: SELECT chart_of_accounts_id
1994: INTO coa_id
1995: FROM gl_sets_of_books
1996: WHERE set_of_books_id = l_set_of_books_id;
1997:
1998: RETURN coa_id;
1999:

Line 2368: FROM gl_sets_of_books gsob,

2364:
2365: else
2366: SELECT glp.start_date
2367: INTO l_start_date
2368: FROM gl_sets_of_books gsob,
2369: gl_periods glp
2370: WHERE gsob.period_set_name = glp.period_set_name
2371: AND gsob.set_of_books_id = l_set_of_books_id
2372: AND glp.period_name = p_period_name;