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 477: ,hr_organization_information hrorg

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

Line 581: ,hr_organization_information hrorg

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

Line 678: ,hr_organization_information hrorg

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

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

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

Line 1738: hr_organization_information hrorg

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

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

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

Line 1762: hr_organization_information hrorg

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

Line 1823: hr_organization_information where organization_id = ppf.business_group_id

1819: qryctx := DBMS_XMLGEN.newContext('SELECT :3 as "OPERATION_FLAG",
1820: ppf.business_group_id as "BUSINESS_GROUP_ID",
1821: ppf.person_id as "PERSON_ID",
1822: (select org_information9 from
1823: hr_organization_information where organization_id = ppf.business_group_id
1824: and org_information_context = ''Business Group Information'') as "LEGISLATION_CODE",
1825: EMPLOYEE_NUMBER as "EMPLOYEE_NUMBER",
1826: APPLICANT_NUMBER as "APPLICANT_NUMBER",
1827: NPW_NUMBER as "CWK_NUMBER",

Line 1866: hr_organization_information where organization_id = ppf.business_group_id

1862: null as "PHONE_TYPE",
1863: null as "PHONE_NUMBER",
1864: (select message_text from fnd_new_messages where message_name = ''HR_NATIONAL_ID_NUMBER_''||
1865: (select to_char(org_information9) from
1866: hr_organization_information where organization_id = ppf.business_group_id
1867: and org_information_context = ''Business Group Information'')
1868: and language_code = USERENV(''LANG'') ) as "NATIONAL_IDENTIFIER_LABEL",
1869: hr_hrhd_initial_load.hr_hrhd_encrypt(:1) as "ENCRYPTED_PERSON_ID",
1870: hr_hrhd_initial_load.hr_hrhd_encrypt(ppf.business_group_id) as "ENCRYPTED_BUS_GRP_ID"

Line 1886: hr_organization_information where organization_id = ppf.business_group_id

1882: qryctx := DBMS_XMLGEN.newContext('SELECT :3 as "OPERATION_FLAG",
1883: ppf.business_group_id as "BUSINESS_GROUP_ID",
1884: ppf.person_id as "PERSON_ID",
1885: (select org_information9 from
1886: hr_organization_information where organization_id = ppf.business_group_id
1887: and org_information_context = ''Business Group Information'') as "LEGISLATION_CODE",
1888: EMPLOYEE_NUMBER as "EMPLOYEE_NUMBER",
1889: APPLICANT_NUMBER as "APPLICANT_NUMBER",
1890: NPW_NUMBER as "CWK_NUMBER",

Line 1929: hr_organization_information where organization_id = ppf.business_group_id

1925: null as "PHONE_TYPE",
1926: null as "PHONE_NUMBER",
1927: (select message_text from fnd_new_messages where message_name = ''HR_NATIONAL_ID_NUMBER_''||
1928: (select to_char(org_information9) from
1929: hr_organization_information where organization_id = ppf.business_group_id
1930: and org_information_context = ''Business Group Information'')
1931: and language_code = USERENV(''LANG'') ) as "NATIONAL_IDENTIFIER_LABEL",
1932: hr_hrhd_initial_load.hr_hrhd_encrypt(:1) as "ENCRYPTED_PERSON_ID",
1933: hr_hrhd_initial_load.hr_hrhd_encrypt(ppf.business_group_id) as "ENCRYPTED_BUS_GRP_ID"

Line 1954: hr_organization_information where organization_id = ppf.business_group_id

1950: qryctx := DBMS_XMLGEN.newContext('SELECT :3 as "OPERATION_FLAG",
1951: ppf.business_group_id as "BUSINESS_GROUP_ID",
1952: ppf.person_id as "PERSON_ID",
1953: (select org_information9 from
1954: hr_organization_information where organization_id = ppf.business_group_id
1955: and org_information_context = ''Business Group Information'') as "LEGISLATION_CODE",
1956: EMPLOYEE_NUMBER as "EMPLOYEE_NUMBER",
1957: APPLICANT_NUMBER as "APPLICANT_NUMBER",
1958: NPW_NUMBER as "CWK_NUMBER",

Line 1997: hr_organization_information where organization_id = ppf.business_group_id

1993: PHONE_TYPE as "PHONE_TYPE",
1994: PHONE_NUMBER as "PHONE_NUMBER",
1995: (select message_text from fnd_new_messages where message_name = ''HR_NATIONAL_ID_NUMBER_''||
1996: (select to_char(org_information9) from
1997: hr_organization_information where organization_id = ppf.business_group_id
1998: and org_information_context = ''Business Group Information'')
1999: and language_code = USERENV(''LANG'') ) as "NATIONAL_IDENTIFIER_LABEL",
2000: hr_hrhd_initial_load.hr_hrhd_encrypt(:1) as "ENCRYPTED_PERSON_ID",
2001: hr_hrhd_initial_load.hr_hrhd_encrypt(ppf.business_group_id) as "ENCRYPTED_BUS_GRP_ID"