APPS.INV_TRANSACTION_FLOW_PUB dependencies on HR_ORGANIZATION_UNITS

Line 367: FROM hr_organization_units

363: x_return_status := g_ret_sts_warning;
364: BEGIN
365: select name
366: into l_from_ou_name
367: FROM hr_organization_units
368: WHERE organization_id = p_start_operating_unit;
369:
370: EXCEPTION
371: when no_data_found then

Line 380: FROM hr_organization_units

376:
377: BEGIN
378: select name
379: into l_to_ou_name
380: FROM hr_organization_units
381: WHERE organization_id = p_end_operating_unit;
382: EXCEPTION
383: when no_data_found then
384: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_END_ORG');

Line 845: FROM hr_organization_units

841: IF NOT l_match THEN
842: BEGIN
843: select name
844: into l_from_ou_name
845: FROM hr_organization_units
846: WHERE organization_id = p_start_operating_unit;
847:
848: EXCEPTION
849: when no_data_found then

Line 858: FROM hr_organization_units

854:
855: BEGIN
856: select name
857: into l_to_ou_name
858: FROM hr_organization_units
859: WHERE organization_id = p_end_operating_unit;
860: EXCEPTION
861: when no_data_found then
862: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_END_ORG');

Line 3402: FROM HR_ORGANIZATION_INFORMATION LEI, HR_ORGANIZATION_UNITS OU,

3398: BEGIN
3399: l_progress := 1;
3400: SELECT to_number(LEI.org_information1)
3401: into l_set_of_book_id
3402: FROM HR_ORGANIZATION_INFORMATION LEI, HR_ORGANIZATION_UNITS OU,
3403: HR_ORGANIZATION_INFORMATION OUI
3404: WHERE OU.organization_id = p_org_id
3405: AND LEI.org_information_context = 'Legal Entity Accounting'
3406: AND to_char(LEI.organization_id) = OUI.org_information2