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_HRHD_RIR_WF dependencies on HR_ALL_ORGANIZATION_UNITS

Line 476: from hr_all_organization_units org

472: p_date_chk varchar2(11);
473:
474: cursor csr_chk_hr_org(p_org_id number) is
475: select org.organization_id,to_char(org.date_to,'DD/MM/YYYY')
476: from hr_all_organization_units org
477: ,hr_organization_information hrorg
478: where hrorg.organization_id = org.organization_id
479: and hrorg.org_information1 = 'HR_ORG'
480: and org.organization_id = p_org_id;

Line 580: from hr_all_organization_units org

576: p_hr_org_chk varchar2(10);
577:
578: cursor csr_chk_hr_org(p_org_id number) is
579: select 'x'
580: from hr_all_organization_units org
581: ,hr_organization_information hrorg
582: where hrorg.organization_id = org.organization_id
583: and hrorg.org_information1 = 'HR_ORG'
584: and org.organization_id = p_org_id;

Line 677: from hr_all_organization_units org

673: p_hr_org_chk varchar2(10);
674:
675: cursor csr_chk_hr_org(p_org_id number) is
676: select 'x'
677: from hr_all_organization_units org
678: ,hr_organization_information hrorg
679: where hrorg.organization_id = org.organization_id
680: and hrorg.org_information1 = 'HR_ORG'
681: and org.organization_id = p_org_id;

Line 1726: cursor(select language lang_code,name data from hr_all_organization_units_tl TL where tl.organization_id = org.organization_id) as "ORGANIZATIONNAME",

1722: ORG.BUSINESS_GROUP_ID as "BUSINESS_GROUP_ID",
1723: ORG.ORGANIZATION_ID as "ORGANIZATION_ID",
1724: to_char(nvl(date_to,trunc(sysdate)),''YYYY-MM-DD'') as "EFFECTIVE_DATE",
1725: ''I'' as "EFFECTIVE_STATUS",
1726: cursor(select language lang_code,name data from hr_all_organization_units_tl TL where tl.organization_id = org.organization_id) as "ORGANIZATIONNAME",
1727: ORG.LOCATION_ID as "LOCATION_ID",
1728: (select employee_number from per_all_people_f ppf,hr_organization_information hrorg1
1729: where ppf.person_id = hrorg1.ORG_INFORMATION2
1730: and ppf.business_group_id = org.business_group_id

Line 1737: from hr_all_organization_units org,

1733: and nvl(org.date_to,to_date(''31/12/4712'',''DD/MM/YYYY'')) between fnd_date.canonical_to_date(hrorg1.org_information3)
1734: and nvl(fnd_date.canonical_to_date(hrorg1.org_information4),to_date(''31/12/4712'',''DD/MM/YYYY''))
1735: and fnd_date.canonical_to_date(hrorg1.org_information3) between ppf.effective_start_date and ppf.effective_end_date) as "MANAGER_ID"
1736:
1737: from hr_all_organization_units org,
1738: hr_organization_information hrorg
1739: where hrorg.organization_id = org.organization_id
1740: and hrorg.org_information1 = ''HR_ORG''
1741: and org.last_update_date = (select max(last_update_date) from hr_all_organization_units where organization_id = :1)');

Line 1741: and org.last_update_date = (select max(last_update_date) from hr_all_organization_units where organization_id = :1)');

1737: from hr_all_organization_units org,
1738: hr_organization_information hrorg
1739: where hrorg.organization_id = org.organization_id
1740: and hrorg.org_information1 = ''HR_ORG''
1741: and org.last_update_date = (select max(last_update_date) from hr_all_organization_units where organization_id = :1)');
1742: else
1743:
1744: qryctx := DBMS_XMLGEN.newContext(
1745: 'SELECT :2 as "OPERATION_FLAG",

Line 1750: cursor(select language lang_code,name data from hr_all_organization_units_tl TL where tl.organization_id = org.organization_id) as "ORGANIZATIONNAME",

1746: ORG.BUSINESS_GROUP_ID as "BUSINESS_GROUP_ID",
1747: ORG.ORGANIZATION_ID as "ORGANIZATION_ID",
1748: to_char(DATE_FROM,''YYYY-MM-DD'') as "EFFECTIVE_DATE" ,
1749: ''A'' as "EFFECTIVE_STATUS" ,
1750: cursor(select language lang_code,name data from hr_all_organization_units_tl TL where tl.organization_id = org.organization_id) as "ORGANIZATIONNAME",
1751: ORG.LOCATION_ID as "LOCATION_ID",
1752: (select employee_number from per_all_people_f ppf,hr_organization_information hrorg1
1753: where ppf.person_id = hrorg1.ORG_INFORMATION2
1754: and ppf.business_group_id = org.business_group_id

Line 1761: from hr_all_organization_units org,

1757: and nvl(org.date_to,to_date(''31/12/4712'',''DD/MM/YYYY'')) between fnd_date.canonical_to_date(hrorg1.org_information3)
1758: and nvl(fnd_date.canonical_to_date(hrorg1.org_information4),to_date(''31/12/4712'',''DD/MM/YYYY''))
1759: and fnd_date.canonical_to_date(hrorg1.org_information3) between ppf.effective_start_date and ppf.effective_end_date) as "MANAGER_ID"
1760:
1761: from hr_all_organization_units org,
1762: hr_organization_information hrorg
1763: where hrorg.organization_id = org.organization_id
1764: and hrorg.org_information1 = ''HR_ORG''
1765: and org.last_update_date = (select max(last_update_date) from hr_all_organization_units where organization_id = :1)');

Line 1765: and org.last_update_date = (select max(last_update_date) from hr_all_organization_units where organization_id = :1)');

1761: from hr_all_organization_units org,
1762: hr_organization_information hrorg
1763: where hrorg.organization_id = org.organization_id
1764: and hrorg.org_information1 = ''HR_ORG''
1765: and org.last_update_date = (select max(last_update_date) from hr_all_organization_units where organization_id = :1)');
1766:
1767: end if;
1768:
1769: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_ORGANIZATION_id);