APPS.JAI_PO_HOOK_PKG dependencies on GL_SETS_OF_BOOKS

Line 185: FROM gl_sets_of_books

181: /*rchandan for 5961325..start*/
182:
183: CURSOR c_func_curr(cp_sob_id IN NUMBER) IS
184: SELECT currency_code
185: FROM gl_sets_of_books
186: WHERE set_of_books_id = cp_sob_id;
187:
188: CURSOR cur_asbn_hdr(cp_header_id NUMBER) IS
189: SELECT *

Line 1249: FROM gl_sets_of_booKs

1245: AND line_type_lookup_code = 'MISCELLANEOUS';
1246:
1247: CURSOR c_sob_curr(cp_org_id NUMBER) IS
1248: SELECT currency_code
1249: FROM gl_sets_of_booKs
1250: WHERE set_of_books_id IN
1251: (SELECT set_of_books_id
1252: FROM hr_operating_units
1253: WHERE organization_id = cp_org_id);

Line 1589: FROM gl_sets_of_booKs

1585: WHERE requisition_line_id = cp_reqn_line_id;
1586:
1587: CURSOR c_sob_curr(cp_org_id NUMBER) IS
1588: SELECT currency_code
1589: FROM gl_sets_of_booKs
1590: WHERE set_of_books_id IN
1591: (SELECT set_of_books_id
1592: FROM hr_operating_units
1593: WHERE organization_id = cp_org_id);

Line 1830: FROM gl_sets_of_booKs

1826:
1827: /* Get the set of books currency (function currency)*/
1828: CURSOR c_sob_curr(cp_org_id NUMBER) IS
1829: SELECT currency_code
1830: FROM gl_sets_of_booKs
1831: WHERE set_of_books_id IN
1832: (SELECT set_of_books_id
1833: FROM hr_operating_units
1834: WHERE organization_id = cp_org_id);

Line 2294: FROM gl_sets_of_booKs

2290: IS
2291:
2292: CURSOR sob_curr_csr(pn_org_id NUMBER) IS
2293: SELECT currency_code
2294: FROM gl_sets_of_booKs
2295: WHERE set_of_books_id IN
2296: (SELECT set_of_books_id
2297: FROM hr_operating_units
2298: WHERE organization_id = pn_org_id);