DBA Data[Home] [Help]

APPS.AP_VENDOR_PUB_PKG dependencies on FINANCIALS_SYSTEM_PARAMETERS

Line 409: FROM FINANCIALS_SYSTEM_PARAMETERS fsp);

405: INTO l_dummy
406: FROM HR_CURRENT_EMP hre
407: WHERE hre.employee_id = p_employee_id
408: AND hre.BUSINESS_GROUP_ID IN ( SELECT fsp.BUSINESS_GROUP_ID
409: FROM FINANCIALS_SYSTEM_PARAMETERS fsp);
410: --end of bug 13535075
411:
412: EXCEPTION
413: -- Trap validation error

Line 996: l_ven_num_code financials_system_parameters.user_defined_vendor_num_code%TYPE;

992: PROCEDURE Chk_Null_Vendor_Number(p_segment1 IN VARCHAR2 default null,
993: x_valid OUT NOCOPY BOOLEAN
994: ) IS
995:
996: l_ven_num_code financials_system_parameters.user_defined_vendor_num_code%TYPE;
997:
998: BEGIN
999:
1000: x_valid := TRUE;

Line 16612: --AND org_id IN (SELECT fsp.org_id FROM financials_system_parameters fsp) --bug13801271

16608: WHERE import_request_id = l_request_id
16609: AND (org_id IS NOT NULL OR operating_unit_name IS NOT NULL)
16610: AND vendor_id IS NOT NULL
16611: AND org_id = nvl(p_org_id, org_id) --bug13801271
16612: --AND org_id IN (SELECT fsp.org_id FROM financials_system_parameters fsp) --bug13801271
16613: AND mo_global.check_access(org_id)= 'Y' --bug13989575
16614: ;
16615:
16616: site_int_rec site_int_cur%ROWTYPE;