DBA Data[Home] [Help]

APPS.OZF_AUTOPAY_PVT dependencies on FND_PROFILE

Line 860: AND organization_id = FND_PROFILE.VALUE('AMS_ITEM_ORGANIZATION_ID');

856: CURSOR csr_prod_name(p_product_id IN NUMBER) IS
857: SELECT DESCRIPTION
858: FROM MTL_SYSTEM_ITEMS_KFV
859: WHERE INVENTORY_ITEM_ID = p_product_id
860: AND organization_id = FND_PROFILE.VALUE('AMS_ITEM_ORGANIZATION_ID');
861:
862: CURSOR csr_cust_name(cv_cust_account_id IN NUMBER) IS
863: SELECT CONCAT(CONCAT(party.party_name, ' ('), CONCAT(ca.account_number, ') '))
864: FROM hz_cust_accounts ca