APPS.PO_ASL_API_PUB dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 1380: FROM hr_all_organization_units_tl hout

1376:
1377: UPDATE po_approved_supplier_list_gt past
1378: SET past.owning_organization_id =
1379: (SELECT hout.organization_id
1380: FROM hr_all_organization_units_tl hout
1381: WHERE hout.name = past.owning_organization_dsp
1382: AND hout.language = UserEnv('lang')
1383: AND ROWNUM < 2)
1384: WHERE past.owning_organization_dsp IS NOT NULL;

Line 1523: FROM hr_all_organization_units_tl hout

1519:
1520: UPDATE po_asl_documents_gt padt
1521: SET padt.using_organization_id =
1522: (SELECT hout.organization_id
1523: FROM hr_all_organization_units_tl hout
1524: WHERE hout.name = padt.using_organization_dsp
1525: AND hout.language = UserEnv('lang')
1526: AND ROWNUM < 2)
1527: WHERE padt.using_organization_dsp IS NOT NULL;

Line 1612: FROM hr_all_organization_units_tl hout

1608:
1609: UPDATE chv_authorizations_gt chv
1610: SET chv.using_organization_id =
1611: (SELECT hout.organization_id
1612: FROM hr_all_organization_units_tl hout
1613: WHERE hout.name = chv.using_organization_dsp
1614: AND hout.language = UserEnv('lang')
1615: AND ROWNUM < 2)
1616: WHERE chv.using_organization_dsp IS NOT NULL;

Line 1664: FROM hr_all_organization_units_tl hout

1660:
1661: UPDATE po_asl_attributes_gt paa
1662: SET paa.using_organization_id =
1663: (SELECT hout.organization_id
1664: FROM hr_all_organization_units_tl hout
1665: WHERE hout.name = paa.using_organization_dsp
1666: AND hout.language = UserEnv('lang')
1667: AND ROWNUM < 2)
1668: WHERE paa.using_organization_dsp IS NOT NULL;

Line 1831: FROM hr_all_organization_units_tl hout

1827:
1828: UPDATE po_supplier_item_capacity_gt poic
1829: SET poic.using_organization_id =
1830: (SELECT hout.organization_id
1831: FROM hr_all_organization_units_tl hout
1832: WHERE hout.name = poic.using_organization_dsp
1833: AND hout.language = UserEnv('lang')
1834: AND ROWNUM < 2)
1835: WHERE poic.using_organization_dsp IS NOT NULL;

Line 1880: FROM hr_all_organization_units_tl hout

1876:
1877: UPDATE po_supplier_item_tolerance_gt poit
1878: SET poit.using_organization_id =
1879: (SELECT hout.organization_id
1880: FROM hr_all_organization_units_tl hout
1881: WHERE hout.name = poit.using_organization_dsp
1882: AND hout.language = UserEnv('lang')
1883: AND ROWNUM < 2)
1884: WHERE poit.using_organization_dsp IS NOT NULL;