APPS.PNP_UTIL_FUNC dependencies on GL_SETS_OF_BOOKS

Line 1617: FROM gl_sets_of_books gl_sob

1613:
1614:
1615: CURSOR get_coa_id (p_set_of_books_id IN NUMBER) IS
1616: SELECT gl_sob.chart_of_accounts_id
1617: FROM gl_sets_of_books gl_sob
1618: WHERE gl_sob.set_of_books_id = l_set_of_books_id;
1619:
1620: BEGIN
1621:

Line 1840: FROM gl_sets_of_books

1836: p_org_id));
1837:
1838: SELECT chart_of_accounts_id
1839: INTO coa_id
1840: FROM gl_sets_of_books
1841: WHERE set_of_books_id = l_set_of_books_id;
1842:
1843: RETURN coa_id;
1844:

Line 2213: FROM gl_sets_of_books gsob,

2209:
2210: else
2211: SELECT glp.start_date
2212: INTO l_start_date
2213: FROM gl_sets_of_books gsob,
2214: gl_periods glp
2215: WHERE gsob.period_set_name = glp.period_set_name
2216: AND gsob.set_of_books_id = l_set_of_books_id
2217: AND glp.period_name = p_period_name;