DBA Data[Home] [Help]

APPS.INV_RCV_STD_DELIVER_APIS dependencies on HR_ORGANIZATION_INFORMATION

Line 4287: FROM hr_organization_information hoi

4283: IF inv_rcv_common_apis.g_po_startup_value.sob_id IS NULL THEN
4284: --BUG 3444177: User HOR for performance reasons
4285: SELECT TO_NUMBER(hoi.org_information1)
4286: INTO inv_rcv_common_apis.g_po_startup_value.sob_id
4287: FROM hr_organization_information hoi
4288: WHERE hoi.organization_id = p_organization_id
4289: AND (hoi.org_information_context || '') = 'Accounting Information' ;
4290: END IF;
4291:

Line 4483: FROM hr_organization_information hoi

4479: IF inv_rcv_common_apis.g_po_startup_value.sob_id IS NULL THEN
4480: --BUG 3444177: User HOR for performance reasons
4481: SELECT TO_NUMBER(hoi.org_information1)
4482: INTO inv_rcv_common_apis.g_po_startup_value.sob_id
4483: FROM hr_organization_information hoi
4484: WHERE hoi.organization_id = p_organization_id
4485: AND (hoi.org_information_context || '') = 'Accounting Information' ;
4486: END IF;
4487:

Line 4888: FROM hr_organization_information hoi

4884: --BUG 3444177: User HOR for performance reasons
4885: BEGIN
4886: SELECT TO_NUMBER(hoi.org_information1)
4887: INTO inv_rcv_common_apis.g_po_startup_value.sob_id
4888: FROM hr_organization_information hoi
4889: WHERE hoi.organization_id = p_organization_id
4890: AND (hoi.org_information_context || '') = 'Accounting Information' ;
4891: EXCEPTION
4892: WHEN OTHERS THEN