APPS.JAI_PO_HOOK_PKG dependencies on GL_SETS_OF_BOOKS

Line 144: FROM gl_sets_of_books

140: /*rchandan for 5961325..start*/
141:
142: CURSOR c_func_curr(cp_sob_id IN NUMBER) IS
143: SELECT currency_code
144: FROM gl_sets_of_books
145: WHERE set_of_books_id = cp_sob_id;
146:
147: CURSOR cur_asbn_hdr(cp_header_id NUMBER) IS
148: SELECT *

Line 1120: FROM gl_sets_of_booKs

1116: AND line_type_lookup_code = 'MISCELLANEOUS';
1117:
1118: CURSOR c_sob_curr(cp_org_id NUMBER) IS
1119: SELECT currency_code
1120: FROM gl_sets_of_booKs
1121: WHERE set_of_books_id IN
1122: (SELECT set_of_books_id
1123: FROM hr_operating_units
1124: WHERE organization_id = cp_org_id);

Line 1460: FROM gl_sets_of_booKs

1456: WHERE requisition_line_id = cp_reqn_line_id;
1457:
1458: CURSOR c_sob_curr(cp_org_id NUMBER) IS
1459: SELECT currency_code
1460: FROM gl_sets_of_booKs
1461: WHERE set_of_books_id IN
1462: (SELECT set_of_books_id
1463: FROM hr_operating_units
1464: WHERE organization_id = cp_org_id);

Line 1693: FROM gl_sets_of_booKs

1689:
1690: /* Get the set of books currency (function currency)*/
1691: CURSOR c_sob_curr(cp_org_id NUMBER) IS
1692: SELECT currency_code
1693: FROM gl_sets_of_booKs
1694: WHERE set_of_books_id IN
1695: (SELECT set_of_books_id
1696: FROM hr_operating_units
1697: WHERE organization_id = cp_org_id);

Line 2106: FROM gl_sets_of_booKs

2102: IS
2103:
2104: CURSOR sob_curr_csr(pn_org_id NUMBER) IS
2105: SELECT currency_code
2106: FROM gl_sets_of_booKs
2107: WHERE set_of_books_id IN
2108: (SELECT set_of_books_id
2109: FROM hr_operating_units
2110: WHERE organization_id = pn_org_id);