APPS.OKC_TERMS_TMPL_APPROVAL_PVT dependencies on HR_ORGANIZATION_INFORMATION

Line 1210: FROM hr_organization_information org,

1206: l_org_id NUMBER := NULL;
1207:
1208: CURSOR tmpl_approver_csr(cp_template_id IN NUMBER) IS
1209: SELECT decode(tmpl.intent,'S',org.org_information2,org.org_information6) org_information
1210: FROM hr_organization_information org,
1211: okc_terms_templates_all tmpl
1212: WHERE org.organization_id = tmpl.org_id
1213: AND org.org_information_context = 'OKC_TERMS_LIBRARY_DETAILS'
1214: AND tmpl.template_id = cp_template_id;

Line 1733: hr_organization_information hri

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;
1737:

Line 1823: notified hr_organization_information.org_information3%type;

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);
1827: counter NUMBER;