APPS.OKC_TERMS_TMPL_APPROVAL_PVT dependencies on HR_ORGANIZATION_INFORMATION

Line 1259: FROM hr_organization_information org,

1255: l_org_id NUMBER := NULL;
1256:
1257: CURSOR tmpl_approver_csr(cp_template_id IN NUMBER) IS
1258: SELECT decode(tmpl.intent,'S',org.org_information2,org.org_information6) org_information
1259: FROM hr_organization_information org,
1260: okc_terms_templates_all tmpl
1261: WHERE org.organization_id = tmpl.org_id
1262: AND org.org_information_context = 'OKC_TERMS_LIBRARY_DETAILS'
1263: AND tmpl.template_id = cp_template_id;

Line 1782: hr_organization_information hri

1778: SELECT decode(org_information1, 'Y', 'ADOPTED','AVAILABLE'),
1779: hr.organization_id,
1780: decode(cp_tmpl_intent,'S',org_information3,org_information7) org_information
1781: FROM hr_organization_units hr,
1782: hr_organization_information hri
1783: WHERE hri.organization_id = hr.organization_id
1784: and org_information_context = 'OKC_TERMS_LIBRARY_DETAILS'
1785: and hr.organization_id <> cp_global_org_id;
1786:

Line 1872: notified hr_organization_information.org_information3%type;

1868: IS
1869:
1870: operation okc_article_adoptions.adoption_type%type;
1871: organization hr_organization_units_v.organization_id%type;
1872: notified hr_organization_information.org_information3%type;
1873:
1874: org_name VARCHAR(240);
1875: wf_admin_user VARCHAR(320);
1876: counter NUMBER;

Line 2083: hr_organization_information hri

2079: -- if only one org exists in the setup, then return COMPLETE:F
2080: SELECT Count(1)
2081: INTO l_org_count
2082: FROM hr_organization_units hr,
2083: hr_organization_information hri
2084: WHERE hri.organization_id = hr.organization_id
2085: and org_information_context = 'OKC_TERMS_LIBRARY_DETAILS'
2086: and hr.organization_id <> global_org_id;
2087: