APPS.OKC_ARTWF_PVT dependencies on HR_ORGANIZATION_UNITS

Line 718: hr_organization_units hr

714: 'SYSADMIN') notified
715: from
716: okc_article_adoptions arta,
717: hr_organization_information hri,
718: hr_organization_units hr
719: where
720: global_article_version_id = p_artv_id
721: and
722: hri.organization_id = local_org_id

Line 804: organization hr_organization_units_v.organization_id%type;

800: funcmode in varchar2,
801: resultout out nocopy varchar2)
802: is
803: operation okc_article_adoptions.adoption_type%type;
804: organization hr_organization_units_v.organization_id%type;
805: notified hr_organization_information.org_information3%type;
806: counter number;
807:
808: --Fix for 6237128.Set null for notified when user is end-dated

Line 1617: org_name hr_organization_units.name%type;

1613: end;
1614:
1615: function get_org_name(p_org_id in number) return varchar2
1616: is
1617: org_name hr_organization_units.name%type;
1618: begin
1619: -- Fix for bug# 5010703, replaced hr_organization_units_v with hr_organization_units for Performance(shared memory)
1620: /* bug 5028066
1621: select name into org_name

Line 1619: -- Fix for bug# 5010703, replaced hr_organization_units_v with hr_organization_units for Performance(shared memory)

1615: function get_org_name(p_org_id in number) return varchar2
1616: is
1617: org_name hr_organization_units.name%type;
1618: begin
1619: -- Fix for bug# 5010703, replaced hr_organization_units_v with hr_organization_units for Performance(shared memory)
1620: /* bug 5028066
1621: select name into org_name
1622: from hr_organization_units
1623: where organization_id = p_org_id;

Line 1622: from hr_organization_units

1618: begin
1619: -- Fix for bug# 5010703, replaced hr_organization_units_v with hr_organization_units for Performance(shared memory)
1620: /* bug 5028066
1621: select name into org_name
1622: from hr_organization_units
1623: where organization_id = p_org_id;
1624: */
1625: select
1626: otl.name into org_name

Line 1975: org_name hr_organization_units.name%type;

1971:
1972: -- bug 5202585 start
1973: function get_terms_org_name(p_template_id in number) return varchar2
1974: is
1975: org_name hr_organization_units.name%type;
1976: begin
1977: select
1978: otl.name into org_name
1979: from