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_NO_VALIDATE_PKG dependencies on HR_ORGANIZATION_UNITS

Line 193: l_organization_id hr_organization_units.organization_id%TYPE;

189: ) IS
190:
191:
192: l_org_information1 hr_organization_information.org_information1%TYPE;
193: l_organization_id hr_organization_units.organization_id%TYPE;
194: l_business_group_id hr_organization_units.business_group_id%TYPE;
195: l_org_information_id hr_organization_information.org_information_id%TYPE;
196: l_org_info_type_code hr_organization_information.org_information_context%TYPE;
197: l_org_id hr_organization_information.org_information_id%TYPE;

Line 194: l_business_group_id hr_organization_units.business_group_id%TYPE;

190:
191:
192: l_org_information1 hr_organization_information.org_information1%TYPE;
193: l_organization_id hr_organization_units.organization_id%TYPE;
194: l_business_group_id hr_organization_units.business_group_id%TYPE;
195: l_org_information_id hr_organization_information.org_information_id%TYPE;
196: l_org_info_type_code hr_organization_information.org_information_context%TYPE;
197: l_org_id hr_organization_information.org_information_id%TYPE;
198:

Line 221: from hr_organization_units

217: AND to_number(nvl(hoi.org_information2,'4712')));
218: --
219: cursor getbgid is
220: select business_group_id
221: from hr_organization_units
222: where organization_id = p_organization_id;
223:
224: /* Performance Bug fix 4892110 - Changed the below cursor to parameterized cursor avoiding fnd_sessions table */
225: cursor orgnum(s_eff_date date) is

Line 226: select orgif.org_information_id from hr_organization_information orgif,hr_organization_units ou

222: where organization_id = p_organization_id;
223:
224: /* Performance Bug fix 4892110 - Changed the below cursor to parameterized cursor avoiding fnd_sessions table */
225: cursor orgnum(s_eff_date date) is
226: select orgif.org_information_id from hr_organization_information orgif,hr_organization_units ou
227: where ( orgif.org_information_context = 'NO_LOCAL_UNIT_DETAILS' or orgif.org_information_context = 'NO_LEGAL_EMPLOYER_DETAILS')
228: and ou.organization_id = orgif.organization_id
229: and ou.business_group_id = l_business_group_id
230: and orgif.org_information1 = p_org_information1

Line 236: from hr_organization_units o , hr_organization_information hoi

232:
233: /* Performance Bug fix 4892110 - Changed the below cursor to parameterized cursor avoiding fnd_sessions table */
234: cursor orglocalunit(s_eff_date date) is
235: select o.organization_id
236: from hr_organization_units o , hr_organization_information hoi
237: where o.organization_id = hoi.organization_id
238: and o.business_group_id = l_business_group_id
239: and hoi.org_information_context = 'CLASS'
240: and hoi.org_information1 = 'NO_LOCAL_UNIT'

Line 243: from hr_organization_units org, hr_organization_information hoinf

239: and hoi.org_information_context = 'CLASS'
240: and hoi.org_information1 = 'NO_LOCAL_UNIT'
241: and to_char(o.organization_id) in (
242: select hoinf.org_information1
243: from hr_organization_units org, hr_organization_information hoinf
244: where org.business_group_id = l_business_group_id
245: and org.organization_id = hoinf.organization_id
246: and hoinf.org_information_context = 'NO_LOCAL_UNITS'
247: )

Line 644: l_business_group_id hr_organization_units.business_group_id%TYPE;

640:
641:
642: l_org_information1 hr_organization_information.org_information1%TYPE;
643: l_organization_id hr_organization_information.organization_id%TYPE;
644: l_business_group_id hr_organization_units.business_group_id%TYPE;
645: l_org_information_id hr_organization_information.org_information_id%TYPE;
646: l_org_info_type_code hr_organization_information.org_information_context%TYPE;
647: l_org_id hr_organization_information.org_information_id%TYPE;
648:

Line 671: from hr_organization_units

667: AND to_number(nvl(hoi.org_information2,'4712')));
668:
669: cursor getbgid is
670: select business_group_id
671: from hr_organization_units
672: where organization_id = l_organization_id;
673:
674: cursor getorgid is
675: select organization_id

Line 680: select orgif.org_information_id from hr_organization_information orgif,hr_organization_units ou

676: from hr_organization_information
677: where org_information_id = p_org_information_id;
678: /* Performance Bug fix 4892110 - Changed the below cursor to parameterized cursor avoiding fnd_sessions table */
679: cursor orgnum(s_eff_date date) is
680: select orgif.org_information_id from hr_organization_information orgif,hr_organization_units ou
681: where ( orgif.org_information_context = 'NO_LOCAL_UNIT_DETAILS' or orgif.org_information_context = 'NO_LEGAL_EMPLOYER_DETAILS')
682: and ou.organization_id = orgif.organization_id
683: and ou.business_group_id = l_business_group_id
684: and orgif.org_information1 = p_org_information1

Line 690: from hr_organization_units o , hr_organization_information hoi

686:
687: /* Performance Bug fix 4892110 - Changed the below cursor to parameterized cursor avoiding fnd_sessions table */
688: cursor orglocalunit(s_eff_date date) is
689: select o.organization_id
690: from hr_organization_units o , hr_organization_information hoi
691: where o.organization_id = hoi.organization_id
692: and o.business_group_id = l_business_group_id
693: and hoi.org_information_context = 'CLASS'
694: and hoi.org_information1 = 'NO_LOCAL_UNIT'

Line 697: from hr_organization_units org, hr_organization_information hoinf

693: and hoi.org_information_context = 'CLASS'
694: and hoi.org_information1 = 'NO_LOCAL_UNIT'
695: and to_char(o.organization_id) in (
696: select hoinf.org_information1
697: from hr_organization_units org, hr_organization_information hoinf
698: where org.business_group_id = l_business_group_id
699: and org.organization_id = hoinf.organization_id
700: and org.organization_id <> l_organization_id
701: and hoinf.org_information_context = 'NO_LOCAL_UNITS'

Line 1217: l_organization_id hr_organization_units.organization_id%TYPE;

1213: (p_organization_id in number
1214: ,p_org_information1 in varchar2
1215: ) IS
1216:
1217: l_organization_id hr_organization_units.organization_id%TYPE;
1218: l_business_group_id hr_organization_units.business_group_id%TYPE;
1219: l_int_ext_flag hr_organization_units.internal_external_flag%TYPE;
1220:
1221: cursor getbgid is

Line 1218: l_business_group_id hr_organization_units.business_group_id%TYPE;

1214: ,p_org_information1 in varchar2
1215: ) IS
1216:
1217: l_organization_id hr_organization_units.organization_id%TYPE;
1218: l_business_group_id hr_organization_units.business_group_id%TYPE;
1219: l_int_ext_flag hr_organization_units.internal_external_flag%TYPE;
1220:
1221: cursor getbgid is
1222: select business_group_id

Line 1219: l_int_ext_flag hr_organization_units.internal_external_flag%TYPE;

1215: ) IS
1216:
1217: l_organization_id hr_organization_units.organization_id%TYPE;
1218: l_business_group_id hr_organization_units.business_group_id%TYPE;
1219: l_int_ext_flag hr_organization_units.internal_external_flag%TYPE;
1220:
1221: cursor getbgid is
1222: select business_group_id
1223: from hr_organization_units

Line 1223: from hr_organization_units

1219: l_int_ext_flag hr_organization_units.internal_external_flag%TYPE;
1220:
1221: cursor getbgid is
1222: select business_group_id
1223: from hr_organization_units
1224: where organization_id = p_organization_id;
1225:
1226: cursor orgtype is
1227: select ou.internal_external_flag from hr_organization_units ou ,FND_SESSIONS s

Line 1227: select ou.internal_external_flag from hr_organization_units ou ,FND_SESSIONS s

1223: from hr_organization_units
1224: where organization_id = p_organization_id;
1225:
1226: cursor orgtype is
1227: select ou.internal_external_flag from hr_organization_units ou ,FND_SESSIONS s
1228: where ou.organization_id= p_organization_id
1229: and s.session_id = userenv('sessionid')
1230: and s.effective_date between ou.date_from and nvl(ou.date_to,to_date('31/12/4712','DD/MM/YYYY'));
1231:

Line 1576: FROM hr_organization_units hou

1572: AND petei.element_type_id = p_ele_type_id ;
1573:
1574: CURSOR csr_get_le_details(p_le_id NUMBER) IS
1575: SELECT hou.name NAME
1576: FROM hr_organization_units hou
1577: ,hr_organization_information hoi
1578: WHERE hoi.organization_id = hou.organization_id
1579: AND hoi.org_information_context = 'NO_LEGAL_EMPLOYER_DETAILS'
1580: AND hou.organization_id = p_le_id;

Line 1782: FROM hr_organization_units hou

1778: AND petei.eei_information1 = p_ele_code;
1779:
1780: CURSOR csr_get_le_details(p_le_id NUMBER) IS
1781: SELECT hou.name NAME
1782: FROM hr_organization_units hou
1783: ,hr_organization_information hoi
1784: WHERE hoi.organization_id = hou.organization_id
1785: AND hoi.org_information_context = 'NO_LEGAL_EMPLOYER_DETAILS'
1786: AND hou.organization_id = p_le_id;