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 1=1 --pose.org_structure_version_id = P_Org_Struct_Version_Id --16275108
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 1529: hr_organization_information e

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

Line 1613: hr_organization_information e

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

Line 1621: l_cbs_Rep_Freq hr_organization_information.ORG_INFORMATION15%TYPE;

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

Line 1691: hr_organization_information e

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

Line 1699: l_cbs_cust_num hr_organization_information.ORG_INFORMATION16%TYPE;

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

Line 1763: hr_organization_information e

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

Line 1771: l_cbs_company_unit hr_organization_information.ORG_INFORMATION18%TYPE;

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

Line 1839: hr_organization_information e

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

Line 1847: l_cbs_public_sector hr_organization_information.ORG_INFORMATION17%TYPE;

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

Line 1914: hr_organization_information e

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

Line 1922: l_full_wage_paid hr_organization_information.ORG_INFORMATION17%TYPE;

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

Line 1992: hr_organization_information e

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

Line 2000: l_IZA_Weekly_Hours hr_organization_information.ORG_INFORMATION20%TYPE;

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

Line 2082: hr_organization_information e

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

Line 2090: l_IZA_Monthly_Hours hr_organization_information.ORG_INFORMATION12%TYPE;

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

Line 2165: hr_organization_information e

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

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

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

Line 2243: hr_organization_information e

2239: (l_org_id in hr_organization_units.organization_id%type,l_si_class varchar2,l_date_earned DATE) IS
2240: select
2241: 1
2242: from
2243: hr_organization_information e
2244: where e.organization_id=l_org_id
2245: and e.org_information_context = 'NL_AMI'
2246: and e.org_information3=l_si_class
2247: and l_date_earned between fnd_date.canonical_to_date(e.org_INFORMATION1)

Line 2341: FROM hr_organization_information hoi

2337: AND session_id = userenv ('sessionid');
2338:
2339: CURSOR csr_get_lhd_override(l_org_id in hr_organization_units.organization_id%type) IS
2340: SELECT hoi.org_information6 lhd_pro_override
2341: FROM hr_organization_information hoi
2342: WHERE hoi.organization_id = l_org_id
2343: AND hoi.org_information_context = 'NL_ORG_INFORMATION'
2344: AND hoi.org_information6 IS NOT NULL;
2345: --

Line 2349: l_lhd_pro_override hr_organization_information.ORG_INFORMATION6%TYPE;

2345: --
2346: --Local Variables
2347: --
2348: v_csr_get_lhd_override csr_get_lhd_override%ROWTYPE;
2349: l_lhd_pro_override hr_organization_information.ORG_INFORMATION6%TYPE;
2350: l_org_id per_all_assignments_f.organization_id%TYPE;
2351: l_organization_id per_all_assignments_f.organization_id%TYPE; --15837938
2352: l_level number; --15837938
2353:

Line 2430: FROM hr_organization_information hoi

2426: AND session_id = userenv ('sessionid');
2427:
2428: CURSOR csr_get_bene_rul_sepa(l_org_id IN hr_organization_units.organization_id%TYPE) IS
2429: SELECT hoi.org_information7 benefi_rule
2430: FROM hr_organization_information hoi
2431: WHERE hoi.organization_id = l_org_id
2432: AND hoi.org_information_context = 'NL_ORG_INFORMATION'
2433: AND hoi.org_information7 IS NOT NULL;
2434:

Line 2437: l_benefi_rule hr_organization_information.org_information7%TYPE;

2433: AND hoi.org_information7 IS NOT NULL;
2434:
2435: --Local Variable
2436: rec_get_bene_rul_sepa csr_get_bene_rul_sepa%ROWTYPE;
2437: l_benefi_rule hr_organization_information.org_information7%TYPE;
2438: l_org_id per_all_assignments_f.organization_id%TYPE;
2439: l_organization_id per_all_assignments_f.organization_id%TYPE;
2440: l_level number;
2441: