APPS.INV_RCV_STD_INSPECT_APIS dependencies on HR_ORGANIZATION_INFORMATION

Line 1216: FROM hr_organization_information hoi

1212: THEN
1213: --BUG 3444196: Used the HR view instead for performance reasons
1214: SELECT TO_NUMBER (hoi.org_information1)
1215: INTO inv_rcv_common_apis.g_po_startup_value.sob_id
1216: FROM hr_organization_information hoi
1217: WHERE hoi.organization_id = p_organization_id
1218: AND (hoi.org_information_context || '') = 'Accounting Information';
1219: END IF;
1220:

Line 2359: FROM hr_organization_information hoi

2355: IF inv_rcv_common_apis.g_po_startup_value.sob_id IS NULL THEN
2356: --BUG 3444196: Used the HR view instead for performance reasons
2357: SELECT TO_NUMBER(hoi.org_information1)
2358: INTO inv_rcv_common_apis.g_po_startup_value.sob_id
2359: FROM hr_organization_information hoi
2360: WHERE hoi.organization_id = p_organization_id
2361: AND (hoi.org_information_context || '') = 'Accounting Information' ;
2362: END IF;
2363:

Line 3515: FROM hr_organization_information hoi

3511: IF inv_rcv_common_apis.g_po_startup_value.sob_id IS NULL THEN
3512: --BUG 3444196: Used the HR view instead for performance reasons
3513: SELECT TO_NUMBER(hoi.org_information1)
3514: INTO inv_rcv_common_apis.g_po_startup_value.sob_id
3515: FROM hr_organization_information hoi
3516: WHERE hoi.organization_id = p_organization_id
3517: AND (hoi.org_information_context || '') = 'Accounting Information' ;
3518: END IF;
3519:

Line 3930: FROM hr_organization_information hoi

3926: IF inv_rcv_common_apis.g_po_startup_value.sob_id IS NULL THEN
3927: --BUG 3444196: Used the HR view instead for performance reasons
3928: SELECT TO_NUMBER(hoi.org_information1)
3929: INTO inv_rcv_common_apis.g_po_startup_value.sob_id
3930: FROM hr_organization_information hoi
3931: WHERE hoi.organization_id = p_organization_id
3932: AND (hoi.org_information_context || '') = 'Accounting Information' ;
3933: END IF;
3934:

Line 4346: FROM hr_organization_information hoi

4342: IF inv_rcv_common_apis.g_po_startup_value.sob_id IS NULL THEN
4343: --BUG 3444196: Used the HR view instead for performance reasons
4344: SELECT TO_NUMBER(hoi.org_information1)
4345: INTO inv_rcv_common_apis.g_po_startup_value.sob_id
4346: FROM hr_organization_information hoi
4347: WHERE hoi.organization_id = p_organization_id
4348: AND (hoi.org_information_context || '') = 'Accounting Information' ;
4349: END IF;
4350:

Line 4759: FROM hr_organization_information hoi

4755: IF inv_rcv_common_apis.g_po_startup_value.sob_id IS NULL THEN
4756: --BUG 3444196: Used the HR view instead for performance reasons
4757: SELECT TO_NUMBER(hoi.org_information1)
4758: INTO inv_rcv_common_apis.g_po_startup_value.sob_id
4759: FROM hr_organization_information hoi
4760: WHERE hoi.organization_id = p_organization_id
4761: AND (hoi.org_information_context || '') = 'Accounting Information' ;
4762: END IF;
4763: