DBA Data[Home] [Help]

APPS.AMS_UTILITY_PVT dependencies on GL_SETS_OF_BOOKS

Line 1941: FROM gl_sets_of_books gs

1937: p_org_id IN NUMBER)
1938: IS
1939: SELECT gs.set_of_books_id
1940: ,gs.currency_code
1941: FROM gl_sets_of_books gs
1942: ,org_organization_definitions org
1943: WHERE gs.mrc_sob_type_code = 'P'
1944: AND org.set_of_books_id = gs.set_of_books_id
1945: AND org.operating_unit = p_org_id;

Line 1952: FROM gl_sets_of_books gs

1948: CURSOR c_get_gl_info( p_org_id IN NUMBER)
1949: IS
1950: SELECT gs.set_of_books_id
1951: , gs.currency_code
1952: FROM gl_sets_of_books gs
1953: , ozf_sys_parameters_all org
1954: WHERE org.set_of_books_id = gs.set_of_books_id
1955: AND org.org_id = p_org_id;
1956:

Line 2127: FROM gl_sets_of_books gs

2123: p_org_id IN NUMBER)
2124: IS
2125: SELECT gs.set_of_books_id
2126: ,gs.currency_code
2127: FROM gl_sets_of_books gs
2128: ,org_organization_definitions org
2129: WHERE org.set_of_books_id = gs.set_of_books_id
2130: AND org.operating_unit = p_org_id;
2131: */

Line 2137: FROM gl_sets_of_books gs

2133: CURSOR c_get_gl_info(p_org_id IN NUMBER)
2134: IS
2135: SELECT gs.set_of_books_id
2136: , gs.currency_code
2137: FROM gl_sets_of_books gs
2138: , ozf_sys_parameters_all org
2139: WHERE org.set_of_books_id = gs.set_of_books_id
2140: AND org.org_id = p_org_id;
2141: