APPS.OZF_UTILITY_PVT dependencies on GL_SETS_OF_BOOKS

Line 1992: FROM gl_sets_of_books gs

1988: p_org_id IN NUMBER)
1989: IS
1990: SELECT gs.set_of_books_id
1991: ,gs.currency_code
1992: FROM gl_sets_of_books gs
1993: ,org_organization_definitions org
1994: WHERE gs.mrc_sob_type_code = 'P'
1995: AND org.set_of_books_id = gs.set_of_books_id
1996: AND org.operating_unit = p_org_id;

Line 2003: FROM gl_sets_of_books gs

1999: CURSOR c_get_gl_info( p_org_id IN NUMBER)
2000: IS
2001: SELECT gs.set_of_books_id
2002: , gs.currency_code
2003: FROM gl_sets_of_books gs
2004: , ozf_sys_parameters_all org
2005: WHERE org.set_of_books_id = gs.set_of_books_id
2006: AND NVL(org.org_id, -99) = NVL(p_org_id, -99);
2007:

Line 2171: FROM gl_sets_of_books gs

2167: p_org_id IN NUMBER)
2168: IS
2169: SELECT gs.set_of_books_id
2170: ,gs.currency_code
2171: FROM gl_sets_of_books gs
2172: ,org_organization_definitions org
2173: WHERE org.set_of_books_id = gs.set_of_books_id
2174: AND org.operating_unit = p_org_id;
2175: */

Line 2181: FROM gl_sets_of_books gs

2177: CURSOR c_get_gl_info(p_org_id IN NUMBER)
2178: IS
2179: SELECT gs.set_of_books_id
2180: , gs.currency_code
2181: FROM gl_sets_of_books gs
2182: , ozf_sys_parameters_all org
2183: WHERE org.set_of_books_id = gs.set_of_books_id
2184: AND NVL(org.org_id, -99) = NVL(p_org_id, -99);
2185: