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_NL_ORG_INFO dependencies on HR_ORGANIZATION_INFORMATION

Line 36: FROM hr_organization_information inf

32: -- Cursor to return the current named hierarchy.
33: --
34: CURSOR c_hierarchy(vp_organization_id NUMBER) IS
35: SELECT TO_NUMBER(inf.org_information1) organization_structure_id
36: FROM hr_organization_information inf
37: ,hr_all_organization_units org
38: WHERE org.organization_id = vp_organization_id
39: AND inf.organization_id = org.business_group_id
40: AND inf.org_information_context = 'NL_BG_INFO'

Line 162: 1. Region org_information1 hr_organization_information NL_ORG_INFO |

158: which the value is required.The procedure will navigate from the org_id
159: supplied up the hierarchy until it finds a value for the data item. |
160: The following data items are required ; |
161: Data Item Column Table Context |
162: 1. Region org_information1 hr_organization_information NL_ORG_INFO |
163: 2. Org. Number org_information1 hr_organization_information NL_ORG_INFO |
164: ---------------------------------------------------------------------------*/
165:
166: PROCEDURE get_org_data_items(

Line 163: 2. Org. Number org_information1 hr_organization_information NL_ORG_INFO |

159: supplied up the hierarchy until it finds a value for the data item. |
160: The following data items are required ; |
161: Data Item Column Table Context |
162: 1. Region org_information1 hr_organization_information NL_ORG_INFO |
163: 2. Org. Number org_information1 hr_organization_information NL_ORG_INFO |
164: ---------------------------------------------------------------------------*/
165:
166: PROCEDURE get_org_data_items(
167: p_org_id in number,

Line 180: hr_organization_information.org_information_context%type;

176: l_organization_number varchar2(255);
177: temp_organization_number varchar2(255);
178: l_org_id hr_organization_units.organization_id%type;
179: l_org_information_context
180: hr_organization_information.org_information_context%type;
181: /* Add a check to see if the data item has a value for the org_id supplied
182: - add as a union or separate query */
183: CURSOR org_data_items
184: (l_org_id in hr_organization_units.organization_id%type) IS

Line 190: hr_organization_information e

186: substr(org_information1, 1, 30),
187: substr(org_information2, 1, 30)
188: from
189: hr_organization_units d,
190: hr_organization_information e
191: where
192: d.organization_id = e.organization_id and
193: d.organization_id = l_org_id and
194: e.org_information_context in ('NL_ORG_INFORMATION');

Line 269: FROM Hr_Organization_information

265: (vp_Organization_ID in hr_organization_units.organization_id%TYPE,
266: vp_region in varchar2) IS
267: SELECT Organization_id,
268: org_information1 Region
269: FROM Hr_Organization_information
270: WHERE Organization_ID = vp_Organization_ID
271: AND Org_Information_Context='NL_ORG_INFORMATION';
272: v_cur_Region cur_Region%ROWTYPE;
273: --

Line 378: hr_organization_information e

374: e.org_information_id,
375: e.org_information4 provider,nvl(e.org_information7,'N') p_flag,
376: decode(e.org_information3,'AMI',0,1) si_class_order
377: from
378: hr_organization_information e
379: ,fnd_sessions s
380: where
381: e.organization_id=l_org_id and
382: e.org_information_context = 'NL_SIP' and

Line 520: hr_organization_information e

516: select
517: e.org_information4 provider,nvl(e.org_information7,'N') p_flag,
518: decode(e.org_information3,'AMI',0,1) si_class_order
519: from
520: hr_organization_information e
521: ,fnd_sessions s
522: where
523: e.organization_id=l_org_id and
524: e.org_information_context = 'NL_SIP' and

Line 664: hr_organization_information e

660: l_org_id in hr_organization_units.organization_id%type) IS
661: select
662: e.org_information4 provider
663: from
664: hr_organization_information e
665: where
666: e.organization_id=l_org_id and
667: e.org_information_context = 'NL_SIP' and
668: e.org_information4 =l_uwv_org_id ;

Line 770: hr_organization_information e

766: select
767: e.org_information_id,
768: e.org_information5 Avg_days_Per_Month
769: from
770: hr_organization_information e
771: where
772: e.organization_id=l_org_id and
773: e.org_information_context= 'NL_ORG_INFORMATION'
774: and e.org_information5 IS NOT NULL;

Line 856: hr_organization_information e

852: select
853: e.org_information_id,
854: e.org_information4 tax_information
855: from
856: hr_organization_information e
857: where
858: e.organization_id=l_org_id and
859: e.org_information_context= 'NL_ORG_INFORMATION'
860: and e.org_information3 IS NOT NULL

Line 869: SELECT tax_org_id,lev from hr_organization_information e,(

865: -- Cursor which fetches Tax Organization list for the given HR Organization
866: --
867: CURSOR tax_org_hierarchy(l_org_struct_version_id in per_org_structure_versions.org_structure_version_id%type,
868: l_org_id in hr_organization_units.organization_id%type) IS
869: SELECT tax_org_id,lev from hr_organization_information e,(
870: SELECT l_org_id tax_org_id,0 lev from dual
871: UNION
872: SELECT distinct organization_id_parent
873: ,level

Line 945: hr_organization_information e

941: select
942: e.org_information_id,
943: e.org_information7 working_hours
944: from
945: hr_organization_information e
946: where
947: e.organization_id=l_org_id and
948: e.org_information_context= 'NL_ORG_INFORMATION'
949: and e.org_information7 IS NOT NULL;

Line 1038: hr_organization_information e

1034: select
1035: e.org_information_id,
1036: e.org_information8 Part_Time_Percentage_Method
1037: from
1038: hr_organization_information e
1039: where
1040: e.organization_id=l_org_id and
1041: e.org_information_context= 'NL_ORG_INFORMATION'
1042: and e.org_information8 IS NOT NULL;

Line 1135: hr_organization_information e

1131: select
1132: e.org_information_id,
1133: e.org_information9 Lunar_5_Week_Month_Wage_Method
1134: from
1135: hr_organization_information e
1136: where
1137: e.organization_id=l_org_id and
1138: e.org_information_context= 'NL_ORG_INFORMATION'
1139: and e.org_information9 IS NOT NULL;

Line 1231: hr_organization_information e

1227: select
1228: e.org_information_id,
1229: e.org_information10 Proration_Tax_Table
1230: from
1231: hr_organization_information e
1232: where
1233: e.organization_id=l_org_id and
1234: e.org_information_context= 'NL_ORG_INFORMATION'
1235: and e.org_information10 IS NOT NULL;

Line 1239: l_Pro_Tax_Table hr_organization_information.ORG_INFORMATION10%TYPE;

1235: and e.org_information10 IS NOT NULL;
1236: --
1237: --Local Variables
1238: --
1239: l_Pro_Tax_Table hr_organization_information.ORG_INFORMATION10%TYPE;
1240: v_Pro_Tax_Table cur_Pro_Tax_Table%ROWTYPE;
1241: l_org_id per_all_assignments_f.organization_id%TYPE;
1242: l_organization_id hr_organization_units.organization_id%TYPE;
1243: l_level number;

Line 1361: hr_organization_information e

1357: select
1358: e.org_information4 provider,nvl(e.org_information7,'N') p_flag,
1359: decode(e.org_information3,'AMI',0,1) si_class_order
1360: from
1361: hr_organization_information e
1362: ,fnd_sessions s
1363: where
1364: e.organization_id=l_org_id and
1365: e.org_information_context = 'NL_SIP' and

Line 1473: from per_org_structure_elements pose,hr_organization_information e

1469: return varchar2 is
1470:
1471: cursor c_all_emp is
1472: select pose.organization_id_child employer
1473: from per_org_structure_elements pose,hr_organization_information e
1474: where pose.org_structure_version_id = P_Org_Struct_Version_Id
1475: and e.organization_id=pose.organization_id_child
1476: and ((e.org_information_context= 'NL_ORG_INFORMATION'
1477: and e.org_information3 IS NOT NULL

Line 1528: hr_organization_information e

1524: select
1525: e.org_information_id,
1526: e.org_information11 Parental_Leave_Perc
1527: from
1528: hr_organization_information e
1529: where
1530: e.organization_id=l_org_id and
1531: e.org_information_context= 'NL_ORG_INFORMATION'
1532: and e.org_information11 IS NOT NULL;

Line 1612: hr_organization_information e

1608: select
1609: e.org_information_id,
1610: e.org_information15 cbs_reporting_frequency
1611: from
1612: hr_organization_information e
1613: where
1614: e.organization_id=l_org_id and
1615: e.org_information_context= 'NL_ORG_INFORMATION'
1616: and e.org_information15 IS NOT NULL;

Line 1620: l_cbs_Rep_Freq hr_organization_information.ORG_INFORMATION15%TYPE;

1616: and e.org_information15 IS NOT NULL;
1617: --
1618: --Local Variables
1619: --
1620: l_cbs_Rep_Freq hr_organization_information.ORG_INFORMATION15%TYPE;
1621: v_Rep_Freq_Table csr_cbs_rep_freq%ROWTYPE;
1622: l_org_id per_all_assignments_f.organization_id%TYPE;
1623: l_organization_id hr_organization_units.organization_id%TYPE;
1624: l_level number;

Line 1690: hr_organization_information e

1686: select
1687: e.org_information_id,
1688: e.org_information16 cbs_cust_number
1689: from
1690: hr_organization_information e
1691: where
1692: e.organization_id=l_org_id and
1693: e.org_information_context= 'NL_ORG_INFORMATION'
1694: and e.org_information16 IS NOT NULL;

Line 1698: l_cbs_cust_num hr_organization_information.ORG_INFORMATION16%TYPE;

1694: and e.org_information16 IS NOT NULL;
1695: --
1696: --Local Variables
1697: --
1698: l_cbs_cust_num hr_organization_information.ORG_INFORMATION16%TYPE;
1699: v_cust_num_table csr_customer_number%ROWTYPE;
1700: l_org_id per_all_assignments_f.organization_id%TYPE;
1701: l_organization_id hr_organization_units.organization_id%TYPE;
1702: l_level number;

Line 1762: hr_organization_information e

1758: select
1759: e.org_information_id,
1760: e.org_information18 cbs_company_unit
1761: from
1762: hr_organization_information e
1763: where
1764: e.organization_id=l_org_id and
1765: e.org_information_context= 'NL_ORG_INFORMATION'
1766: and e.org_information18 IS NOT NULL;

Line 1770: l_cbs_company_unit hr_organization_information.ORG_INFORMATION18%TYPE;

1766: and e.org_information18 IS NOT NULL;
1767: --
1768: --Local Variables
1769: --
1770: l_cbs_company_unit hr_organization_information.ORG_INFORMATION18%TYPE;
1771: v_company_unit_table csr_company_unit%ROWTYPE;
1772: l_org_id per_all_assignments_f.organization_id%TYPE;
1773: l_organization_id hr_organization_units.organization_id%TYPE;
1774: l_level number;

Line 1838: hr_organization_information e

1834: select
1835: e.org_information_id,
1836: e.org_information17 cbs_public_sector_org
1837: from
1838: hr_organization_information e
1839: where
1840: e.organization_id=l_org_id and
1841: e.org_information_context= 'NL_ORG_INFORMATION'
1842: and e.org_information17 IS NOT NULL;

Line 1846: l_cbs_public_sector hr_organization_information.ORG_INFORMATION17%TYPE;

1842: and e.org_information17 IS NOT NULL;
1843: --
1844: --Local Variables
1845: --
1846: l_cbs_public_sector hr_organization_information.ORG_INFORMATION17%TYPE;
1847: v_public_sector_Table csr_public_sector_info%ROWTYPE;
1848: l_org_id per_all_assignments_f.organization_id%TYPE;
1849: l_organization_id hr_organization_units.organization_id%TYPE;
1850: l_level number;

Line 1913: hr_organization_information e

1909: select
1910: e.org_information_id,
1911: e.org_information19 full_sick_wage_paid
1912: from
1913: hr_organization_information e
1914: where
1915: e.organization_id=l_org_id and
1916: e.org_information_context= 'NL_ORG_INFORMATION'
1917: and e.org_information19 IS NOT NULL;

Line 1921: l_full_wage_paid hr_organization_information.ORG_INFORMATION17%TYPE;

1917: and e.org_information19 IS NOT NULL;
1918: --
1919: --Local Variables
1920: --
1921: l_full_wage_paid hr_organization_information.ORG_INFORMATION17%TYPE;
1922: v_full_sick_wage csr_full_wage_paid%ROWTYPE;
1923: l_org_id per_all_assignments_f.organization_id%TYPE;
1924: l_organization_id hr_organization_units.organization_id%TYPE;
1925: l_level number;

Line 1991: hr_organization_information e

1987: select
1988: e.org_information_id,
1989: e.org_information20 IZA_Weekly_Hours
1990: from
1991: hr_organization_information e
1992: where
1993: e.organization_id=l_org_id and
1994: e.org_information_context= 'NL_ORG_INFORMATION'
1995: and e.org_information20 IS NOT NULL;

Line 1999: l_IZA_Weekly_Hours hr_organization_information.ORG_INFORMATION20%TYPE;

1995: and e.org_information20 IS NOT NULL;
1996: --
1997: --Local Variables
1998: --
1999: l_IZA_Weekly_Hours hr_organization_information.ORG_INFORMATION20%TYPE;
2000: v_IZA_Weekly_Hours_table csr_IZA_Weekly_Hours%ROWTYPE;
2001: l_org_id per_all_assignments_f.organization_id%TYPE;
2002: l_organization_id hr_organization_units.organization_id%TYPE;
2003: l_level number;

Line 2081: hr_organization_information e

2077: select
2078: e.org_information_id,
2079: e.org_information12 IZA_Monthly_Hours
2080: from
2081: hr_organization_information e
2082: where
2083: e.organization_id=l_org_id and
2084: e.org_information_context= 'NL_ORG_INFORMATION'
2085: and e.org_information12 IS NOT NULL;

Line 2089: l_IZA_Monthly_Hours hr_organization_information.ORG_INFORMATION12%TYPE;

2085: and e.org_information12 IS NOT NULL;
2086: --
2087: --Local Variables
2088: --
2089: l_IZA_Monthly_Hours hr_organization_information.ORG_INFORMATION12%TYPE;
2090: v_IZA_Monthly_Hours_table csr_IZA_Monthly_Hours%ROWTYPE;
2091: l_org_id per_all_assignments_f.organization_id%TYPE;
2092: l_organization_id hr_organization_units.organization_id%TYPE;
2093: l_level number;

Line 2164: hr_organization_information e

2160: select
2161: e.org_information_id,
2162: e.org_information1 iza_information
2163: from
2164: hr_organization_information e
2165: where
2166: e.organization_id=l_org_id and
2167: e.org_information_context= 'NL_IZA_REPO_INFO'
2168: and e.org_information1 IS NOT NULL

Line 2177: SELECT iza_org_id,lev from hr_organization_information e,(

2173: -- Cursor which fetches IZA Organization list for the given HR Organization
2174: --
2175: CURSOR iza_org_hierarchy(l_org_struct_version_id in per_org_structure_versions.org_structure_version_id%type,
2176: l_org_id in hr_organization_units.organization_id%type) IS
2177: SELECT iza_org_id,lev from hr_organization_information e,(
2178: SELECT l_org_id iza_org_id,0 lev from dual
2179: UNION
2180: SELECT distinct organization_id_parent
2181: ,level