DBA Data[Home] [Help]

APPS.CSP_NOTIFICATIONS_ORDER_PKG dependencies on HR_ORGANIZATION_UNITS

Line 77: FROM hr_organization_units

73: WHERE user_id = l_user_id;
74:
75: CURSOR location_id_cur IS
76: SELECT location_id
77: FROM hr_organization_units
78: WHERE organization_id = p_dest_orgn_id;
79:
80: CURSOR po_org_id_cur IS
81: SELECT operating_unit