APPS.ICX_REQ_SUBMIT dependencies on FINANCIALS_SYSTEM_PARAMETERS

Line 101: financials_system_parameters fsp

97: cursor getLoccd(locid number) is
98: select hrl.location_code
99: from hr_locations hrl,
100: org_organization_definitions ood,
101: financials_system_parameters fsp
102: where hrl.location_id = locid
103: and ood.organization_id = nvl(hrl.inventory_organization_id,
104: fsp.inventory_organization_id)
105: and sysdate < nvl(hrl.inactive_date,sysdate + 1);

Line 774: financials_system_parameters fsp

770: SELECT hrl.location_id,
771: nvl(hrl.inventory_organization_id,
772: fsp.inventory_organization_id) organization_id
773: from hr_locations hrl,
774: financials_system_parameters fsp
775: where sysdate < nvl(hrl.inactive_date, sysdate + 1)
776: and hrl.location_code = loc;
777:
778: cursor requester_check(v_req_name varchar2,v_org_id number) is

Line 818: financials_system_parameters fsp

814:
815: cursor get_acct is
816: select CHART_OF_ACCOUNTS_ID
817: from gl_sets_of_books,
818: financials_system_parameters fsp
819: where gl_sets_of_books.SET_OF_BOOKS_ID = fsp.set_of_books_id;
820:
821: cursor invalid_locations(l_cart_id number, v_oo_id number) is
822: select cart_line_number, DELIVER_TO_LOCATION

Line 2043: financials_system_parameters fsp

2039: (select hrl.location_id,
2040: nvl(hrl.inventory_organization_id,
2041: fsp.inventory_organization_id)
2042: from hr_locations hrl,
2043: financials_system_parameters fsp
2044: where sysdate < nvl(hrl.inactive_date, sysdate + 1)
2045: and hrl.location_code =
2046: icx_shopping_cart_lines.DELIVER_TO_LOCATION)
2047: where DELIVER_TO_LOCATION_ID is null

Line 2116: financials_system_parameters fsp,

2112: else
2113: if (v_account_id is not null) then
2114: select count(*) into v_exist
2115: from gl_sets_of_books gsb,
2116: financials_system_parameters fsp,
2117: gl_code_combinations gl
2118: where gsb.SET_OF_BOOKS_ID = fsp.set_of_books_id
2119: and gsb.CHART_OF_ACCOUNTS_ID = gl.CHART_OF_ACCOUNTS_ID
2120: and gl.CODE_COMBINATION_ID = v_account_id;