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_INFORMATION

Line 196: l_org_information1 hr_organization_information.org_information1%TYPE;

192: ,p_org_information20 in varchar2
193: ) IS
194:
195:
196: l_org_information1 hr_organization_information.org_information1%TYPE;
197: l_organization_id hr_organization_units.organization_id%TYPE;
198: l_business_group_id hr_organization_units.business_group_id%TYPE;
199: l_org_information_id hr_organization_information.org_information_id%TYPE;
200: l_org_info_type_code hr_organization_information.org_information_context%TYPE;

Line 199: l_org_information_id hr_organization_information.org_information_id%TYPE;

195:
196: l_org_information1 hr_organization_information.org_information1%TYPE;
197: l_organization_id hr_organization_units.organization_id%TYPE;
198: l_business_group_id hr_organization_units.business_group_id%TYPE;
199: l_org_information_id hr_organization_information.org_information_id%TYPE;
200: l_org_info_type_code hr_organization_information.org_information_context%TYPE;
201: l_org_id hr_organization_information.org_information_id%TYPE;
202:
203:

Line 200: l_org_info_type_code hr_organization_information.org_information_context%TYPE;

196: l_org_information1 hr_organization_information.org_information1%TYPE;
197: l_organization_id hr_organization_units.organization_id%TYPE;
198: l_business_group_id hr_organization_units.business_group_id%TYPE;
199: l_org_information_id hr_organization_information.org_information_id%TYPE;
200: l_org_info_type_code hr_organization_information.org_information_context%TYPE;
201: l_org_id hr_organization_information.org_information_id%TYPE;
202:
203:
204: /* Bug Fix 4463101 */

Line 201: l_org_id hr_organization_information.org_information_id%TYPE;

197: l_organization_id hr_organization_units.organization_id%TYPE;
198: l_business_group_id hr_organization_units.business_group_id%TYPE;
199: l_org_information_id hr_organization_information.org_information_id%TYPE;
200: l_org_info_type_code hr_organization_information.org_information_context%TYPE;
201: l_org_id hr_organization_information.org_information_id%TYPE;
202:
203:
204: /* Bug Fix 4463101 */
205:

Line 214: FROM hr_organization_information hoi

210: l_overlap_status VARCHAR2(1);
211:
212: CURSOR csr_repoting_span IS
213: SELECT 'Y'
214: FROM hr_organization_information hoi
215: WHERE hoi.organization_id = p_organization_id
216: AND hoi.org_information_context = 'NO_EOY_REPORTING_RULE_OVERRIDE'
217: AND hoi.org_information3 = p_org_information3
218: AND (to_number(hoi.org_information1) BETWEEN to_number(p_org_information1)

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

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

Line 240: from hr_organization_units o , hr_organization_information hoi

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

Line 247: from hr_organization_units org, hr_organization_information hoinf

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

Line 262: FROM hr_organization_information hoi

258: CURSOR csr_get_exemption_lim_details (p_organization_id NUMBER) IS
259: SELECT hoi.ORG_INFORMATION1 p_org_info1
260: ,hoi.ORG_INFORMATION2 p_org_info2
261: ,hoi.ORG_INFORMATION3 p_org_info3
262: FROM hr_organization_information hoi
263: WHERE hoi.ORGANIZATION_ID = p_organization_id
264: AND hoi.ORG_INFORMATION_CONTEXT = 'NO_NI_EXEMPTION_LIMIT';
265:
266: /*Pgopal - Bug 5341353 fix*/

Line 271: hr_organization_information hoi

267: CURSOR csr_hourly_salaried IS
268: SELECT
269: hoi.org_information5 hourly_salaried
270: FROM
271: hr_organization_information hoi
272: WHERE
273: hoi.organization_id = p_organization_id
274: AND hoi.org_information_context = 'NO_ABSENCE_PAYMENT_DETAILS';
275:

Line 280: hr_organization_information hoi

276: CURSOR csr_pay_to_be_adjusted IS
277: SELECT
278: hoi.org_information5 pay_to_be_adjusted
279: FROM
280: hr_organization_information hoi
281: WHERE
282: hoi.organization_id = p_organization_id
283: AND hoi.org_information_context = 'NO_HOLIDAY_PAY_DETAILS';
284:

Line 288: FROM hr_organization_information hoi

284:
285: -- Pension Validation Bug 6153601, Bug 6166346----
286: CURSOR csr_pension_type_chk IS
287: SELECT hoi.ORG_INFORMATION1 pension_types
288: FROM hr_organization_information hoi
289: WHERE hoi.organization_id = p_organization_id
290: AND hoi.org_information_context = 'NO_PENSION_DETAILS';
291:
292:

Line 295: FROM hr_organization_information hoi

291:
292:
293: CURSOR csr_org_number_chk IS
294: SELECT hoi.ORG_INFORMATION2 org_number
295: FROM hr_organization_information hoi
296: WHERE hoi.organization_id = p_organization_id
297: AND hoi.org_information_context = 'NO_PENSION_DETAILS';
298:
299: Cursor csr_pension_type_provider_chk IS

Line 302: FROM hr_organization_information hoi

298:
299: Cursor csr_pension_type_provider_chk IS
300: SELECT hoi.org_information1,
301: hoi.org_information2
302: FROM hr_organization_information hoi
303: WHERE hoi.organization_id = p_organization_id
304: AND hoi.org_information_context = 'NO_PENSION_PROVIDER'
305: AND hoi.org_information3 = p_org_information3
306: AND ( (fnd_date.canonical_to_date(hoi.org_information1) BETWEEN fnd_date.canonical_to_date(p_org_information1) AND fnd_date.canonical_to_date(p_org_information2)

Line 362: from hr_organization_information

358: exit when orgnum%NOTFOUND;
359:
360: -- fetch curr org_id , code--
361: select organization_id,org_information_context,org_information1 into l_org_id, l_org_info_type_code,l_org_information1
362: from hr_organization_information
363: where org_information_id = l_org_information_id;
364:
365: -- ignore if same type and same organization_id --
366: IF l_org_information1 = p_org_information1 THEN

Line 646: l_org_information1 hr_organization_information.org_information1%TYPE;

642: ,p_org_information20 in varchar2
643: ) IS
644:
645:
646: l_org_information1 hr_organization_information.org_information1%TYPE;
647: l_organization_id hr_organization_information.organization_id%TYPE;
648: l_business_group_id hr_organization_units.business_group_id%TYPE;
649: l_org_information_id hr_organization_information.org_information_id%TYPE;
650: l_org_info_type_code hr_organization_information.org_information_context%TYPE;

Line 647: l_organization_id hr_organization_information.organization_id%TYPE;

643: ) IS
644:
645:
646: l_org_information1 hr_organization_information.org_information1%TYPE;
647: l_organization_id hr_organization_information.organization_id%TYPE;
648: l_business_group_id hr_organization_units.business_group_id%TYPE;
649: l_org_information_id hr_organization_information.org_information_id%TYPE;
650: l_org_info_type_code hr_organization_information.org_information_context%TYPE;
651: l_org_id hr_organization_information.org_information_id%TYPE;

Line 649: l_org_information_id hr_organization_information.org_information_id%TYPE;

645:
646: l_org_information1 hr_organization_information.org_information1%TYPE;
647: l_organization_id hr_organization_information.organization_id%TYPE;
648: l_business_group_id hr_organization_units.business_group_id%TYPE;
649: l_org_information_id hr_organization_information.org_information_id%TYPE;
650: l_org_info_type_code hr_organization_information.org_information_context%TYPE;
651: l_org_id hr_organization_information.org_information_id%TYPE;
652:
653: /* Bug Fix 4463101 */

Line 650: l_org_info_type_code hr_organization_information.org_information_context%TYPE;

646: l_org_information1 hr_organization_information.org_information1%TYPE;
647: l_organization_id hr_organization_information.organization_id%TYPE;
648: l_business_group_id hr_organization_units.business_group_id%TYPE;
649: l_org_information_id hr_organization_information.org_information_id%TYPE;
650: l_org_info_type_code hr_organization_information.org_information_context%TYPE;
651: l_org_id hr_organization_information.org_information_id%TYPE;
652:
653: /* Bug Fix 4463101 */
654:

Line 651: l_org_id hr_organization_information.org_information_id%TYPE;

647: l_organization_id hr_organization_information.organization_id%TYPE;
648: l_business_group_id hr_organization_units.business_group_id%TYPE;
649: l_org_information_id hr_organization_information.org_information_id%TYPE;
650: l_org_info_type_code hr_organization_information.org_information_context%TYPE;
651: l_org_id hr_organization_information.org_information_id%TYPE;
652:
653: /* Bug Fix 4463101 */
654:
655: l_curr_start_date DATE;

Line 663: FROM hr_organization_information hoi

659: l_overlap_status VARCHAR2(1);
660:
661: CURSOR csr_repoting_span(l_organization_id NUMBER) IS
662: SELECT 'Y'
663: FROM hr_organization_information hoi
664: WHERE hoi.organization_id = l_organization_id
665: AND hoi.org_information_context = 'NO_EOY_REPORTING_RULE_OVERRIDE'
666: AND hoi.org_information3 = p_org_information3
667: AND hoi.org_information_id <> p_org_information_id

Line 680: from hr_organization_information

676: where organization_id = l_organization_id;
677:
678: cursor getorgid is
679: select organization_id
680: from hr_organization_information
681: where org_information_id = p_org_information_id;
682: /* Performance Bug fix 4892110 - Changed the below cursor to parameterized cursor avoiding fnd_sessions table */
683: cursor orgnum(s_eff_date date) is
684: select orgif.org_information_id from hr_organization_information orgif,hr_organization_units ou

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

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

Line 694: from hr_organization_units o , hr_organization_information hoi

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

Line 701: from hr_organization_units org, hr_organization_information hoinf

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

Line 717: FROM hr_organization_information hoi

713: CURSOR csr_get_exemption_details (p_organization_id NUMBER , p_org_information_id NUMBER) IS
714: SELECT hoi.ORG_INFORMATION1 p_org_info1
715: ,hoi.ORG_INFORMATION2 p_org_info2
716: ,hoi.ORG_INFORMATION3 p_org_info3
717: FROM hr_organization_information hoi
718: WHERE hoi.ORGANIZATION_ID = p_organization_id
719: AND hoi.ORG_INFORMATION_CONTEXT = 'NO_NI_EXEMPTION_LIMIT'
720: AND hoi.ORG_INFORMATION_ID <> p_org_information_id;
721:

Line 727: hr_organization_information hoi

723: CURSOR csr_hourly_salaried(p_organization_id NUMBER) IS
724: SELECT
725: hoi.org_information5 hourly_salaried
726: FROM
727: hr_organization_information hoi
728: WHERE
729: hoi.organization_id = p_organization_id
730: AND hoi.org_information_context = 'NO_ABSENCE_PAYMENT_DETAILS';
731:

Line 736: hr_organization_information hoi

732: CURSOR csr_pay_to_be_adjusted(p_organization_id NUMBER) IS
733: SELECT
734: hoi.org_information5 pay_to_be_adjusted
735: FROM
736: hr_organization_information hoi
737: WHERE
738: hoi.organization_id = p_organization_id
739: AND hoi.org_information_context = 'NO_HOLIDAY_PAY_DETAILS';
740:

Line 744: FROM hr_organization_information hoi

740:
741: -- Pension Validation Bug 6153601 , Bug 6166346----
742: CURSOR csr_pension_type_chk IS
743: SELECT hoi.ORG_INFORMATION1 pension_types
744: FROM hr_organization_information hoi
745: WHERE hoi.ORG_INFORMATION_ID = p_org_information_id
746: AND hoi.org_information_context = 'NO_PENSION_DETAILS';
747:
748:

Line 751: FROM hr_organization_information hoi

747:
748:
749: CURSOR csr_org_number_chk IS
750: SELECT hoi.ORG_INFORMATION2 org_number
751: FROM hr_organization_information hoi
752: WHERE hoi.ORG_INFORMATION_ID = p_org_information_id
753: AND hoi.org_information_context = 'NO_PENSION_DETAILS';
754:
755: CURSOR csr_pension_provider_date_chk IS

Line 758: FROM hr_organization_information hoi

754:
755: CURSOR csr_pension_provider_date_chk IS
756: SELECT hoi.org_information1,
757: hoi.org_information2
758: FROM hr_organization_information hoi
759: WHERE hoi.org_information_id = p_org_information_id
760: AND hoi.org_information_context = 'NO_PENSION_PROVIDER';
761:
762: Cursor csr_pension_type_provider_chk IS

Line 766: FROM hr_organization_information hoi

762: Cursor csr_pension_type_provider_chk IS
763: SELECT hoi.org_information1,
764: hoi.org_information2,
765: hoi.org_information_id
766: FROM hr_organization_information hoi
767: WHERE hoi.organization_id = ( SELECT hoi1.organization_id
768: FROM hr_organization_information hoi1
769: WHERE hoi1.org_information_id = p_org_information_id
770: )

Line 768: FROM hr_organization_information hoi1

764: hoi.org_information2,
765: hoi.org_information_id
766: FROM hr_organization_information hoi
767: WHERE hoi.organization_id = ( SELECT hoi1.organization_id
768: FROM hr_organization_information hoi1
769: WHERE hoi1.org_information_id = p_org_information_id
770: )
771: AND hoi.org_information_context = 'NO_PENSION_PROVIDER'
772: AND hoi.org_information3 = p_org_information3

Line 839: from hr_organization_information

835:
836: -- fetch curr org_id , code--
837: select organization_id,org_information_context,org_information1
838: into l_org_id, l_org_info_type_code,l_org_information1
839: from hr_organization_information
840: where org_information_id = l_org_information_id;
841:
842: -- ignore if same type and same organization_id --
843: IF l_org_information1 = p_org_information1 THEN

Line 1581: ,hr_organization_information hoi

1577:
1578: CURSOR csr_get_le_details(p_le_id NUMBER) IS
1579: SELECT hou.name NAME
1580: FROM hr_organization_units hou
1581: ,hr_organization_information hoi
1582: WHERE hoi.organization_id = hou.organization_id
1583: AND hoi.org_information_context = 'NO_LEGAL_EMPLOYER_DETAILS'
1584: AND hou.organization_id = p_le_id;
1585:

Line 1787: ,hr_organization_information hoi

1783:
1784: CURSOR csr_get_le_details(p_le_id NUMBER) IS
1785: SELECT hou.name NAME
1786: FROM hr_organization_units hou
1787: ,hr_organization_information hoi
1788: WHERE hoi.organization_id = hou.organization_id
1789: AND hoi.org_information_context = 'NO_LEGAL_EMPLOYER_DETAILS'
1790: AND hou.organization_id = p_le_id;
1791: