DBA Data[Home] [Help]

APPS.ICX_PO_REQ_ACCT2 dependencies on FINANCIALS_SYSTEM_PARAMETERS

Line 38: financials_system_parameters fsp,

34:
35: cursor acct_exist(acct_id number) is
36: select count(*)
37: from gl_sets_of_books gsb,
38: financials_system_parameters fsp,
39: gl_code_combinations gl
40: where gsb.SET_OF_BOOKS_ID = fsp.set_of_books_id
41: and gsb.CHART_OF_ACCOUNTS_ID = gl.CHART_OF_ACCOUNTS_ID
42: and gl.CODE_COMBINATION_ID = acct_id;

Line 241: FROM financials_system_parameters fsp,

237: isc.CATEGORY_ID,
238: isc.LINE_TYPE_ID,
239: isc.SUGGESTED_VENDOR_NAME,
240: isc.SUGGESTED_VENDOR_LOCATION
241: FROM financials_system_parameters fsp,
242: hr_employees_current_v hecv,
243: mtl_system_items msi,
244: po_requisition_lines isc
245: where isc.requisition_line_id = reqline_id

Line 262: FROM financials_system_parameters fsp,

258: and nvl(a.org_id,-9999) = nvl(v_oo_id,-9999);
259:
260: cursor set_of_books is
261: SELECT fsp.set_of_books_id
262: FROM financials_system_parameters fsp,
263: gl_sets_of_books gsob
264: WHERE gsob.set_of_books_id = fsp.set_of_books_id
265: AND nvl(fsp.org_id, -9999) = nvl(v_oo_id, -9999);
266:

Line 840: financials_system_parameters fsp

836:
837: CURSOR chart_account_id IS
838: SELECT CHART_OF_ACCOUNTS_ID
839: FROM gl_sets_of_books,
840: financials_system_parameters fsp
841: WHERE gl_sets_of_books.SET_OF_BOOKS_ID = fsp.set_of_books_id;
842:
843: cursor get_line_number(cartline_id number, oo_id number) is
844: select a.line_num

Line 973: financials_system_parameters fsp

969:
970: CURSOR chart_account_id IS
971: SELECT CHART_OF_ACCOUNTS_ID
972: FROM gl_sets_of_books,
973: financials_system_parameters fsp
974: WHERE gl_sets_of_books.SET_OF_BOOKS_ID = fsp.set_of_books_id;
975:
976: cursor get_req_line_number(reqline_id number) is
977: select a.line_num

Line 1119: financials_system_parameters fsp

1115:
1116: CURSOR chart_account_id IS
1117: SELECT CHART_OF_ACCOUNTS_ID
1118: FROM gl_sets_of_books,
1119: financials_system_parameters fsp
1120: WHERE gl_sets_of_books.SET_OF_BOOKS_ID = fsp.set_of_books_id;
1121:
1122: cursor get_cart_line_number is
1123: select cart_line_number

Line 1168: financials_system_parameters fsp,

1164: end if;
1165: if v_account_id is not NULL then
1166: select count(*) into v_exist
1167: from gl_sets_of_books gsb,
1168: financials_system_parameters fsp,
1169: gl_code_combinations gl
1170: where gsb.SET_OF_BOOKS_ID = fsp.set_of_books_id
1171: and gsb.CHART_OF_ACCOUNTS_ID = gl.CHART_OF_ACCOUNTS_ID
1172: and gl.CODE_COMBINATION_ID = v_account_id;

Line 1275: financials_system_parameters fsp

1271:
1272: CURSOR chart_account_id IS
1273: SELECT CHART_OF_ACCOUNTS_ID
1274: FROM gl_sets_of_books,
1275: financials_system_parameters fsp
1276: WHERE gl_sets_of_books.SET_OF_BOOKS_ID = fsp.set_of_books_id;
1277:
1278: cursor get_req_line_number is
1279: select a.line_num

Line 1394: financials_system_parameters fsp

1390:
1391: CURSOR chart_account_id IS
1392: SELECT CHART_OF_ACCOUNTS_ID
1393: FROM gl_sets_of_books,
1394: financials_system_parameters fsp
1395: WHERE gl_sets_of_books.SET_OF_BOOKS_ID = fsp.set_of_books_id;
1396:
1397: v_account_id number;
1398: v_account_num varchar2(2000);