DBA Data[Home] [Help]

APPS.ICX_REQ_ORDER dependencies on FINANCIALS_SYSTEM_PARAMETERS

Line 1163: financials_system_parameters fsp

1159: cursor location(v_location_id number) is
1160: select hrl.location_code
1161: from hr_locations hrl,
1162: org_organization_definitions ood,
1163: financials_system_parameters fsp
1164: where hrl.location_id = v_location_id
1165: and ood.organization_id = nvl(hrl.inventory_organization_id,
1166: fsp.inventory_organization_id)
1167: and sysdate < nvl(hrl.inactive_date, sysdate + 1);

Line 2677: financials_system_parameters fsp

2673: ood.organization_code
2674: from hr_locations hrl,
2675: hr_employees_current_v hrev,
2676: org_organization_definitions ood,
2677: financials_system_parameters fsp
2678: where hrev.employee_id = v_shop_id
2679: and hrev.location_id = hrl.location_id
2680: and ood.organization_id = nvl(hrl.inventory_organization_id,
2681: fsp.inventory_organization_id)