DBA Data[Home] [Help]

APPS.OE_ERROR_WF dependencies on HR_OPERATING_UNITS

Line 103: FROM HR_OPerating_units

99: AND T.TRANSACTION_TYPE_ID = l_order_type_id;
100:
101: SELECT name
102: INTO l_oper_unit_name
103: FROM HR_OPerating_units
104: WHERE ORGANIZATION_ID = l_org_id;
105:
106: IF l_flow_status_code is not NULL THEN
107: SELECT MEANING

Line 501: FROM HR_OPerating_units

497: AND T.TRANSACTION_TYPE_ID = l_order_type_id;
498:
499: SELECT name
500: INTO l_oper_unit_name
501: FROM HR_OPerating_units
502: WHERE ORGANIZATION_ID = l_org_id;
503:
504: SELECT name
505: INTO l_salesrep

Line 604: FROM HR_OPerating_units

600: AND T.TRANSACTION_TYPE_ID = l_order_type_id;
601:
602: SELECT name
603: INTO l_oper_unit_name
604: FROM HR_OPerating_units
605: WHERE ORGANIZATION_ID = l_org_id;
606:
607: SELECT name
608: INTO l_salesrep

Line 729: FROM HR_OPerating_units

725:
726: IF l_org_id IS NOT NULL THEN
727: SELECT name
728: INTO l_oper_unit_name
729: FROM HR_OPerating_units
730: WHERE ORGANIZATION_ID = l_org_id;
731: END IF;
732:
733: If (l_header_id IS NOT NULL) Then