DBA Data[Home] [Help]

APPS.INV_RCV_STD_DELIVER_APIS dependencies on HR_ORGANIZATION_INFORMATION

Line 4171: FROM hr_organization_information hoi

4167: IF inv_rcv_common_apis.g_po_startup_value.sob_id IS NULL THEN
4168: --BUG 3444177: User HOR for performance reasons
4169: SELECT TO_NUMBER(hoi.org_information1)
4170: INTO inv_rcv_common_apis.g_po_startup_value.sob_id
4171: FROM hr_organization_information hoi
4172: WHERE hoi.organization_id = p_organization_id
4173: AND (hoi.org_information_context || '') = 'Accounting Information' ;
4174: END IF;
4175:

Line 4367: FROM hr_organization_information hoi

4363: IF inv_rcv_common_apis.g_po_startup_value.sob_id IS NULL THEN
4364: --BUG 3444177: User HOR for performance reasons
4365: SELECT TO_NUMBER(hoi.org_information1)
4366: INTO inv_rcv_common_apis.g_po_startup_value.sob_id
4367: FROM hr_organization_information hoi
4368: WHERE hoi.organization_id = p_organization_id
4369: AND (hoi.org_information_context || '') = 'Accounting Information' ;
4370: END IF;
4371:

Line 4770: FROM hr_organization_information hoi

4766: --BUG 3444177: User HOR for performance reasons
4767: BEGIN
4768: SELECT TO_NUMBER(hoi.org_information1)
4769: INTO inv_rcv_common_apis.g_po_startup_value.sob_id
4770: FROM hr_organization_information hoi
4771: WHERE hoi.organization_id = p_organization_id
4772: AND (hoi.org_information_context || '') = 'Accounting Information' ;
4773: EXCEPTION
4774: WHEN OTHERS THEN