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_ORGANIZATION_INFORMATION

Line 476: ,hr_organization_information hrorg

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;
480:

Line 577: ,hr_organization_information hrorg

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;
581:

Line 674: ,hr_organization_information hrorg

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;
678:

Line 1548: (select employee_number from per_all_people_f ppf,hr_organization_information hrorg1

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
1551: and hrorg1.org_information_context = ''Organization Name Alias''
1552: and hrorg1.organization_id = org.organization_id

Line 1558: hr_organization_information hrorg

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)');
1562: else

Line 1572: (select employee_number from per_all_people_f ppf,hr_organization_information hrorg1

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
1575: and hrorg1.org_information_context = ''Organization Name Alias''
1576: and hrorg1.organization_id = org.organization_id

Line 1582: hr_organization_information hrorg

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)');
1586:

Line 1643: hr_organization_information where organization_id = ppf.business_group_id

1639: qryctx := DBMS_XMLGEN.newContext('SELECT :3 as "OPERATION_FLAG",
1640: ppf.business_group_id as "BUSINESS_GROUP_ID",
1641: ppf.person_id as "PERSON_ID",
1642: (select org_information9 from
1643: hr_organization_information where organization_id = ppf.business_group_id
1644: and org_information_context = ''Business Group Information'') as "LEGISLATION_CODE",
1645: EMPLOYEE_NUMBER as "EMPLOYEE_NUMBER",
1646: APPLICANT_NUMBER as "APPLICANT_NUMBER",
1647: NPW_NUMBER as "CWK_NUMBER",

Line 1685: hr_organization_information where organization_id = ppf.business_group_id

1681: null as "PHONE_TYPE",
1682: null as "PHONE_NUMBER",
1683: (select message_text from fnd_new_messages where message_name = ''HR_NATIONAL_ID_NUMBER_''||
1684: (select to_char(org_information9) from
1685: hr_organization_information where organization_id = ppf.business_group_id
1686: and org_information_context = ''Business Group Information'')
1687: and language_code = USERENV(''LANG'') ) as "NATIONAL_IDENTIFIER_LABEL",
1688: hr_hrhd_initial_load.hr_hrhd_encrypt(:1) as "ENCRYPTED_PERSON_ID",
1689: hr_hrhd_initial_load.hr_hrhd_encrypt(ppf.business_group_id) as "ENCRYPTED_BUS_GRP_ID"

Line 1705: hr_organization_information where organization_id = ppf.business_group_id

1701: qryctx := DBMS_XMLGEN.newContext('SELECT :3 as "OPERATION_FLAG",
1702: ppf.business_group_id as "BUSINESS_GROUP_ID",
1703: ppf.person_id as "PERSON_ID",
1704: (select org_information9 from
1705: hr_organization_information where organization_id = ppf.business_group_id
1706: and org_information_context = ''Business Group Information'') as "LEGISLATION_CODE",
1707: EMPLOYEE_NUMBER as "EMPLOYEE_NUMBER",
1708: APPLICANT_NUMBER as "APPLICANT_NUMBER",
1709: NPW_NUMBER as "CWK_NUMBER",

Line 1747: hr_organization_information where organization_id = ppf.business_group_id

1743: null as "PHONE_TYPE",
1744: null as "PHONE_NUMBER",
1745: (select message_text from fnd_new_messages where message_name = ''HR_NATIONAL_ID_NUMBER_''||
1746: (select to_char(org_information9) from
1747: hr_organization_information where organization_id = ppf.business_group_id
1748: and org_information_context = ''Business Group Information'')
1749: and language_code = USERENV(''LANG'') ) as "NATIONAL_IDENTIFIER_LABEL",
1750: hr_hrhd_initial_load.hr_hrhd_encrypt(:1) as "ENCRYPTED_PERSON_ID",
1751: hr_hrhd_initial_load.hr_hrhd_encrypt(ppf.business_group_id) as "ENCRYPTED_BUS_GRP_ID"

Line 1772: hr_organization_information where organization_id = ppf.business_group_id

1768: qryctx := DBMS_XMLGEN.newContext('SELECT :3 as "OPERATION_FLAG",
1769: ppf.business_group_id as "BUSINESS_GROUP_ID",
1770: ppf.person_id as "PERSON_ID",
1771: (select org_information9 from
1772: hr_organization_information where organization_id = ppf.business_group_id
1773: and org_information_context = ''Business Group Information'') as "LEGISLATION_CODE",
1774: EMPLOYEE_NUMBER as "EMPLOYEE_NUMBER",
1775: APPLICANT_NUMBER as "APPLICANT_NUMBER",
1776: NPW_NUMBER as "CWK_NUMBER",

Line 1814: hr_organization_information where organization_id = ppf.business_group_id

1810: PHONE_TYPE as "PHONE_TYPE",
1811: PHONE_NUMBER as "PHONE_NUMBER",
1812: (select message_text from fnd_new_messages where message_name = ''HR_NATIONAL_ID_NUMBER_''||
1813: (select to_char(org_information9) from
1814: hr_organization_information where organization_id = ppf.business_group_id
1815: and org_information_context = ''Business Group Information'')
1816: and language_code = USERENV(''LANG'') ) as "NATIONAL_IDENTIFIER_LABEL",
1817: hr_hrhd_initial_load.hr_hrhd_encrypt(:1) as "ENCRYPTED_PERSON_ID",
1818: hr_hrhd_initial_load.hr_hrhd_encrypt(ppf.business_group_id) as "ENCRYPTED_BUS_GRP_ID"