eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.OKC_TERMS_TMPL_APPROVAL_PVT dependencies on HR_ORGANIZATION_UNITS

Line 1781: FROM hr_organization_units hr,

1777: CURSOR notified_csr(cp_tmpl_intent IN VARCHAR2, cp_global_org_id IN NUMBER) is
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;

Line 1871: organization hr_organization_units_v.organization_id%type;

1867: resultout out nocopy varchar2)
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);

Line 2082: FROM hr_organization_units hr,

2078: -- bug fix 14822902 start - SKAVUTHA
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;