APPS.OKC_TERMS_TMPL_APPROVAL_PVT dependencies on HR_ORGANIZATION_UNITS

Line 1732: FROM hr_organization_units hr,

1728: CURSOR notified_csr(cp_tmpl_intent IN VARCHAR2, cp_global_org_id IN NUMBER) is
1729: SELECT decode(org_information1, 'Y', 'ADOPTED','AVAILABLE'),
1730: hr.organization_id,
1731: decode(cp_tmpl_intent,'S',org_information3,org_information7) org_information
1732: FROM hr_organization_units hr,
1733: hr_organization_information hri
1734: WHERE hri.organization_id = hr.organization_id
1735: and org_information_context = 'OKC_TERMS_LIBRARY_DETAILS'
1736: and hr.organization_id <> cp_global_org_id;

Line 1822: organization hr_organization_units_v.organization_id%type;

1818: resultout out nocopy varchar2)
1819: IS
1820:
1821: operation okc_article_adoptions.adoption_type%type;
1822: organization hr_organization_units_v.organization_id%type;
1823: notified hr_organization_information.org_information3%type;
1824:
1825: org_name VARCHAR(240);
1826: wf_admin_user VARCHAR(320);