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 475: from hr_all_organization_units org

471: p_hr_org_chk varchar2(10);
472:
473: cursor csr_chk_hr_org(p_org_id number) is
474: select 'x'
475: from hr_all_organization_units org
476: ,hr_organization_information hrorg
477: where hrorg.organization_id = org.organization_id
478: and hrorg.org_information1 = 'HR_ORG'
479: and org.organization_id = p_org_id;

Line 576: from hr_all_organization_units org

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

Line 673: from hr_all_organization_units org

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

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

1542: ORG.BUSINESS_GROUP_ID as "BUSINESS_GROUP_ID",
1543: ORG.ORGANIZATION_ID as "ORGANIZATION_ID",
1544: to_char(nvl(date_to,trunc(sysdate)),''YYYY-MM-DD'') as "EFFECTIVE_DATE",
1545: ''I'' as "EFFECTIVE_STATUS",
1546: cursor(select language lang_code,name data from hr_all_organization_units_tl TL where tl.organization_id = org.organization_id) as "ORGANIZATIONNAME",
1547: ORG.LOCATION_ID as "LOCATION_ID",
1548: (select employee_number from per_all_people_f ppf,hr_organization_information hrorg1
1549: where ppf.person_id = hrorg1.ORG_INFORMATION2
1550: and ppf.business_group_id = org.business_group_id

Line 1557: from hr_all_organization_units org,

1553: and nvl(org.date_to,to_date(''31/12/4712'',''DD/MM/YYYY'')) between fnd_date.canonical_to_date(hrorg1.org_information3)
1554: and nvl(fnd_date.canonical_to_date(hrorg1.org_information4),to_date(''31/12/4712'',''DD/MM/YYYY''))
1555: and fnd_date.canonical_to_date(hrorg1.org_information3) between ppf.effective_start_date and ppf.effective_end_date) as "MANAGER_ID"
1556:
1557: from hr_all_organization_units org,
1558: hr_organization_information hrorg
1559: where hrorg.organization_id = org.organization_id
1560: and hrorg.org_information1 = ''HR_ORG''
1561: and org.last_update_date = (select max(last_update_date) from hr_all_organization_units where organization_id = :1)');

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

1557: from hr_all_organization_units org,
1558: hr_organization_information hrorg
1559: where hrorg.organization_id = org.organization_id
1560: and hrorg.org_information1 = ''HR_ORG''
1561: and org.last_update_date = (select max(last_update_date) from hr_all_organization_units where organization_id = :1)');
1562: else
1563:
1564: qryctx := DBMS_XMLGEN.newContext(
1565: 'SELECT :2 as "OPERATION_FLAG",

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

1566: ORG.BUSINESS_GROUP_ID as "BUSINESS_GROUP_ID",
1567: ORG.ORGANIZATION_ID as "ORGANIZATION_ID",
1568: to_char(DATE_FROM,''YYYY-MM-DD'') as "EFFECTIVE_DATE" ,
1569: ''A'' as "EFFECTIVE_STATUS" ,
1570: cursor(select language lang_code,name data from hr_all_organization_units_tl TL where tl.organization_id = org.organization_id) as "ORGANIZATIONNAME",
1571: ORG.LOCATION_ID as "LOCATION_ID",
1572: (select employee_number from per_all_people_f ppf,hr_organization_information hrorg1
1573: where ppf.person_id = hrorg1.ORG_INFORMATION2
1574: and ppf.business_group_id = org.business_group_id

Line 1581: from hr_all_organization_units org,

1577: and nvl(org.date_to,to_date(''31/12/4712'',''DD/MM/YYYY'')) between fnd_date.canonical_to_date(hrorg1.org_information3)
1578: and nvl(fnd_date.canonical_to_date(hrorg1.org_information4),to_date(''31/12/4712'',''DD/MM/YYYY''))
1579: and fnd_date.canonical_to_date(hrorg1.org_information3) between ppf.effective_start_date and ppf.effective_end_date) as "MANAGER_ID"
1580:
1581: from hr_all_organization_units org,
1582: hr_organization_information hrorg
1583: where hrorg.organization_id = org.organization_id
1584: and hrorg.org_information1 = ''HR_ORG''
1585: and org.last_update_date = (select max(last_update_date) from hr_all_organization_units where organization_id = :1)');

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

1581: from hr_all_organization_units org,
1582: hr_organization_information hrorg
1583: where hrorg.organization_id = org.organization_id
1584: and hrorg.org_information1 = ''HR_ORG''
1585: and org.last_update_date = (select max(last_update_date) from hr_all_organization_units where organization_id = :1)');
1586:
1587: end if;
1588:
1589: DBMS_XMLGEN.setbindvalue (qryctx, '1', p_ORGANIZATION_id);