APPS.JMF_SUBCONTRACT_ORDERS_PVT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 84: --| hr_all_organization_units tables. |

80: --| 02/08/2006 vchu Bug fix for 4912487: Fixed the FTS |
81: --| issue in Is_Valid_Location by replacing |
82: --| the WHERE EXISTS logic by a join |
83: --| between the hr_locations_all and |
84: --| hr_all_organization_units tables. |
85: --| 03/23/2006 vchu Polished up the FND Log messages. |
86: --| Fixed bug 5090721: set last_updated_by |
87: --| and last_update_login in all update |
88: --| statements. |

Line 502: -- by a join between the hr_all_organization_units and hr_locations_all

498: -- Check to see if the country code of the OEM org is Japan.
499: -- Added Taiwan (TW) and Korea (KR) to the list of countries
500:
501: -- Bug 4912487: Fixed the FTS issue by replacing the WHERE EXISTS logic
502: -- by a join between the hr_all_organization_units and hr_locations_all
503: -- tables.
504: /* 12.1 Buy/Sell Subcontracting changes */
505: /* No country code validation required for Buy/Sell subcontracting */
506: IF (p_subcontracting_type = 'B') THEN

Line 513: FROM hr_all_organization_units hou,

509:
510:
511: SELECT count(*)
512: INTO l_count
513: FROM hr_all_organization_units hou,
514: hr_locations_all hrl
515: WHERE hou.location_id = hrl.location_id
516: AND hou.organization_id = p_organization_id
517: AND hrl.country in ('JP', 'KR', 'TW');