APPS.OKC_ARTWF_PVT dependencies on HR_ORGANIZATION_INFORMATION

Line 417: from hr_organization_information

413: function get_approver(org_id in number, art_intent in varchar2) return varchar2
414: is
415: cursor c_approvers(p_org_id in number, p_art_intent in varchar2) is
416: select decode(p_art_intent, 'S', org_information2, 'B', org_information6, 'SYSADMIN')
417: from hr_organization_information
418: where organization_id = p_org_id
419: and org_information_context = 'OKC_TERMS_LIBRARY_DETAILS';
420: result hr_organization_information.org_information2%type;
421: begin

Line 420: result hr_organization_information.org_information2%type;

416: select decode(p_art_intent, 'S', org_information2, 'B', org_information6, 'SYSADMIN')
417: from hr_organization_information
418: where organization_id = p_org_id
419: and org_information_context = 'OKC_TERMS_LIBRARY_DETAILS';
420: result hr_organization_information.org_information2%type;
421: begin
422: open c_approvers(org_id, art_intent);
423: fetch c_approvers into result;
424: close c_approvers;

Line 717: hr_organization_information hri,

713: decode(p_art_intent, 'S', org_information3, 'B', org_information7,
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

Line 805: notified hr_organization_information.org_information3%type;

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
809:

Line 810: CURSOR c_usr (notified_usr in hr_organization_information.org_information3%TYPE) IS

806: counter number;
807:
808: --Fix for 6237128.Set null for notified when user is end-dated
809:
810: CURSOR c_usr (notified_usr in hr_organization_information.org_information3%TYPE) IS
811: SELECT user_name
812: FROM fnd_user
813: WHERE user_name = notified_usr
814: AND nvl(end_date, sysdate + 1) > sysdate;