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.

APPS.HR_CN_API dependencies on HR_ORGANIZATION_INFORMATION

Line 469: FROM hr_organization_information hrg

465: IS
466:
467: CURSOR csr_org_class (p_organization_id number, p_classfication VARCHAR2) IS
468: SELECT hrg.org_information_id
469: FROM hr_organization_information hrg
470: WHERE hrg.organization_id = p_organization_id
471: AND hrg.org_information_context = p_classIFication;
472:
473: l_org_info_id hr_organization_information.org_information_id%type;

Line 473: l_org_info_id hr_organization_information.org_information_id%type;

469: FROM hr_organization_information hrg
470: WHERE hrg.organization_id = p_organization_id
471: AND hrg.org_information_context = p_classIFication;
472:
473: l_org_info_id hr_organization_information.org_information_id%type;
474:
475: BEGIN
476:
477: OPEN csr_org_class(p_organization_id, p_classIFication);

Line 520: FROM hr_organization_information hrg

516: IS
517:
518: CURSOR csr_org_type (p_organization_id number, p_type VARCHAR2) IS
519: SELECT hrg.org_information_id
520: FROM hr_organization_information hrg
521: WHERE hrg.organization_id = p_organization_id
522: AND hrg.org_information1 = p_type
523: AND hrg.org_information2 = 'Y';
524:

Line 525: l_org_info_id hr_organization_information.org_information_id%type;

521: WHERE hrg.organization_id = p_organization_id
522: AND hrg.org_information1 = p_type
523: AND hrg.org_information2 = 'Y';
524:
525: l_org_info_id hr_organization_information.org_information_id%type;
526:
527: BEGIN
528:
529: OPEN csr_org_type(p_organization_id, p_type);