DBA Data[Home] [Help]

APPS.ICX_REQ_ACCT2 dependencies on FINANCIALS_SYSTEM_PARAMETERS

Line 32: financials_system_parameters fsp,

28:
29: cursor acct_exist(acct_id number) is
30: select count(*)
31: from gl_sets_of_books gsb,
32: financials_system_parameters fsp,
33: gl_code_combinations gl
34: where gsb.SET_OF_BOOKS_ID = fsp.set_of_books_id
35: and gsb.CHART_OF_ACCOUNTS_ID = gl.CHART_OF_ACCOUNTS_ID
36: and gl.CODE_COMBINATION_ID = acct_id;

Line 787: financials_system_parameters fsp

783:
784: CURSOR chart_account_id IS
785: SELECT CHART_OF_ACCOUNTS_ID
786: FROM gl_sets_of_books,
787: financials_system_parameters fsp
788: WHERE gl_sets_of_books.SET_OF_BOOKS_ID = fsp.set_of_books_id;
789:
790: cursor get_cart_line_number(cartid number,cartline_id number) is
791: select cart_line_number

Line 912: financials_system_parameters fsp

908:
909: CURSOR chart_account_id IS
910: SELECT CHART_OF_ACCOUNTS_ID
911: FROM gl_sets_of_books,
912: financials_system_parameters fsp
913: WHERE gl_sets_of_books.SET_OF_BOOKS_ID = fsp.set_of_books_id;
914:
915: cursor get_cart_line_number(cartid number,cartline_id number) is
916: select cart_line_number

Line 1042: financials_system_parameters fsp

1038:
1039: CURSOR chart_account_id IS
1040: SELECT CHART_OF_ACCOUNTS_ID
1041: FROM gl_sets_of_books,
1042: financials_system_parameters fsp
1043: WHERE gl_sets_of_books.SET_OF_BOOKS_ID = fsp.set_of_books_id;
1044:
1045: cursor get_cart_line_number is
1046: select cart_line_number

Line 1091: financials_system_parameters fsp,

1087: end if;
1088: if v_account_id is not NULL then
1089: select count(*) into v_exist
1090: from gl_sets_of_books gsb,
1091: financials_system_parameters fsp,
1092: gl_code_combinations gl
1093: where gsb.SET_OF_BOOKS_ID = fsp.set_of_books_id
1094: and gsb.CHART_OF_ACCOUNTS_ID = gl.CHART_OF_ACCOUNTS_ID
1095: and gl.CODE_COMBINATION_ID = v_account_id;

Line 1200: financials_system_parameters fsp

1196:
1197: CURSOR chart_account_id IS
1198: SELECT CHART_OF_ACCOUNTS_ID
1199: FROM gl_sets_of_books,
1200: financials_system_parameters fsp
1201: WHERE gl_sets_of_books.SET_OF_BOOKS_ID = fsp.set_of_books_id;
1202:
1203: cursor get_cart_line_number is
1204: select cart_line_number

Line 1313: financials_system_parameters fsp

1309:
1310: CURSOR chart_account_id IS
1311: SELECT CHART_OF_ACCOUNTS_ID
1312: FROM gl_sets_of_books,
1313: financials_system_parameters fsp
1314: WHERE gl_sets_of_books.SET_OF_BOOKS_ID = fsp.set_of_books_id;
1315:
1316: v_account_id number;
1317: v_account_num varchar2(2000);