DBA Data[Home] [Help]

APPS.INV_RCV_STD_TRANSFER_APIS dependencies on HR_ORGANIZATION_INFORMATION

Line 2464: --For better performance, using hr_organization_information to fetch set_of_books_id

2460: --First check if the transaction date satisfies the validation.
2461: --If the transaction date is invalid then error out the transaction
2462: IF inv_rcv_common_apis.g_po_startup_value.sob_id IS NULL THEN
2463: --Bug # 3444214
2464: --For better performance, using hr_organization_information to fetch set_of_books_id
2465: SELECT TO_NUMBER(hoi.org_information1)
2466: INTO inv_rcv_common_apis.g_po_startup_value.sob_id
2467: FROM hr_organization_information hoi
2468: WHERE hoi.organization_id = p_organization_id

Line 2467: FROM hr_organization_information hoi

2463: --Bug # 3444214
2464: --For better performance, using hr_organization_information to fetch set_of_books_id
2465: SELECT TO_NUMBER(hoi.org_information1)
2466: INTO inv_rcv_common_apis.g_po_startup_value.sob_id
2467: FROM hr_organization_information hoi
2468: WHERE hoi.organization_id = p_organization_id
2469: AND (hoi.org_information_context || '') = 'Accounting Information';
2470: END IF;
2471: