APPS.INV_RCV_STD_INSPECT_APIS dependencies on HR_ORGANIZATION_INFORMATION

Line 508: FROM hr_organization_information hoi

504: IF inv_rcv_common_apis.g_po_startup_value.sob_id IS NULL THEN
505: --BUG 3444196: Used the HR view instead for performance reasons
506: SELECT TO_NUMBER(hoi.org_information1)
507: INTO inv_rcv_common_apis.g_po_startup_value.sob_id
508: FROM hr_organization_information hoi
509: WHERE hoi.organization_id = p_organization_id
510: AND (hoi.org_information_context || '') = 'Accounting Information' ;
511: END IF;
512:

Line 1623: FROM hr_organization_information hoi

1619: IF inv_rcv_common_apis.g_po_startup_value.sob_id IS NULL THEN
1620: --BUG 3444196: Used the HR view instead for performance reasons
1621: SELECT TO_NUMBER(hoi.org_information1)
1622: INTO inv_rcv_common_apis.g_po_startup_value.sob_id
1623: FROM hr_organization_information hoi
1624: WHERE hoi.organization_id = p_organization_id
1625: AND (hoi.org_information_context || '') = 'Accounting Information' ;
1626: END IF;
1627:

Line 2038: FROM hr_organization_information hoi

2034: IF inv_rcv_common_apis.g_po_startup_value.sob_id IS NULL THEN
2035: --BUG 3444196: Used the HR view instead for performance reasons
2036: SELECT TO_NUMBER(hoi.org_information1)
2037: INTO inv_rcv_common_apis.g_po_startup_value.sob_id
2038: FROM hr_organization_information hoi
2039: WHERE hoi.organization_id = p_organization_id
2040: AND (hoi.org_information_context || '') = 'Accounting Information' ;
2041: END IF;
2042:

Line 2452: FROM hr_organization_information hoi

2448: IF inv_rcv_common_apis.g_po_startup_value.sob_id IS NULL THEN
2449: --BUG 3444196: Used the HR view instead for performance reasons
2450: SELECT TO_NUMBER(hoi.org_information1)
2451: INTO inv_rcv_common_apis.g_po_startup_value.sob_id
2452: FROM hr_organization_information hoi
2453: WHERE hoi.organization_id = p_organization_id
2454: AND (hoi.org_information_context || '') = 'Accounting Information' ;
2455: END IF;
2456:

Line 2860: FROM hr_organization_information hoi

2856: IF inv_rcv_common_apis.g_po_startup_value.sob_id IS NULL THEN
2857: --BUG 3444196: Used the HR view instead for performance reasons
2858: SELECT TO_NUMBER(hoi.org_information1)
2859: INTO inv_rcv_common_apis.g_po_startup_value.sob_id
2860: FROM hr_organization_information hoi
2861: WHERE hoi.organization_id = p_organization_id
2862: AND (hoi.org_information_context || '') = 'Accounting Information' ;
2863: END IF;
2864: