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 192: l_org_information1 hr_organization_information.org_information1%TYPE;

188: ,p_org_information20 in varchar2
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;

Line 195: l_org_information_id hr_organization_information.org_information_id%TYPE;

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:
199:

Line 196: l_org_info_type_code hr_organization_information.org_information_context%TYPE;

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:
199:
200: /* Bug Fix 4463101 */

Line 197: l_org_id hr_organization_information.org_information_id%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:
199:
200: /* Bug Fix 4463101 */
201:

Line 210: FROM hr_organization_information hoi

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

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 258: FROM hr_organization_information hoi

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

Line 267: hr_organization_information hoi

263: CURSOR csr_hourly_salaried IS
264: SELECT
265: hoi.org_information5 hourly_salaried
266: FROM
267: hr_organization_information hoi
268: WHERE
269: hoi.organization_id = p_organization_id
270: AND hoi.org_information_context = 'NO_ABSENCE_PAYMENT_DETAILS';
271:

Line 276: hr_organization_information hoi

272: CURSOR csr_pay_to_be_adjusted IS
273: SELECT
274: hoi.org_information5 pay_to_be_adjusted
275: FROM
276: hr_organization_information hoi
277: WHERE
278: hoi.organization_id = p_organization_id
279: AND hoi.org_information_context = 'NO_HOLIDAY_PAY_DETAILS';
280:

Line 284: FROM hr_organization_information hoi

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

Line 291: FROM hr_organization_information hoi

287:
288:
289: CURSOR csr_org_number_chk IS
290: SELECT hoi.ORG_INFORMATION2 org_number
291: FROM hr_organization_information hoi
292: WHERE hoi.organization_id = p_organization_id
293: AND hoi.org_information_context = 'NO_PENSION_DETAILS';
294:
295: Cursor csr_pension_type_provider_chk IS

Line 298: FROM hr_organization_information hoi

294:
295: Cursor csr_pension_type_provider_chk IS
296: SELECT hoi.org_information1,
297: hoi.org_information2
298: FROM hr_organization_information hoi
299: WHERE hoi.organization_id = p_organization_id
300: AND hoi.org_information_context = 'NO_PENSION_PROVIDER'
301: AND hoi.org_information3 = p_org_information3
302: 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 358: from hr_organization_information

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

Line 642: l_org_information1 hr_organization_information.org_information1%TYPE;

638: ,p_org_information20 in varchar2
639: ) IS
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;

Line 643: l_organization_id hr_organization_information.organization_id%TYPE;

639: ) IS
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;

Line 645: l_org_information_id hr_organization_information.org_information_id%TYPE;

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:
649: /* Bug Fix 4463101 */

Line 646: l_org_info_type_code hr_organization_information.org_information_context%TYPE;

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:
649: /* Bug Fix 4463101 */
650:

Line 647: l_org_id hr_organization_information.org_information_id%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:
649: /* Bug Fix 4463101 */
650:
651: l_curr_start_date DATE;

Line 659: FROM hr_organization_information hoi

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

Line 676: from hr_organization_information

672: where organization_id = l_organization_id;
673:
674: cursor getorgid is
675: select organization_id
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

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 713: FROM hr_organization_information hoi

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

Line 723: hr_organization_information hoi

719: CURSOR csr_hourly_salaried(p_organization_id NUMBER) IS
720: SELECT
721: hoi.org_information5 hourly_salaried
722: FROM
723: hr_organization_information hoi
724: WHERE
725: hoi.organization_id = p_organization_id
726: AND hoi.org_information_context = 'NO_ABSENCE_PAYMENT_DETAILS';
727:

Line 732: hr_organization_information hoi

728: CURSOR csr_pay_to_be_adjusted(p_organization_id NUMBER) IS
729: SELECT
730: hoi.org_information5 pay_to_be_adjusted
731: FROM
732: hr_organization_information hoi
733: WHERE
734: hoi.organization_id = p_organization_id
735: AND hoi.org_information_context = 'NO_HOLIDAY_PAY_DETAILS';
736:

Line 740: FROM hr_organization_information hoi

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

Line 747: FROM hr_organization_information hoi

743:
744:
745: CURSOR csr_org_number_chk IS
746: SELECT hoi.ORG_INFORMATION2 org_number
747: FROM hr_organization_information hoi
748: WHERE hoi.ORG_INFORMATION_ID = p_org_information_id
749: AND hoi.org_information_context = 'NO_PENSION_DETAILS';
750:
751: CURSOR csr_pension_provider_date_chk IS

Line 754: FROM hr_organization_information hoi

750:
751: CURSOR csr_pension_provider_date_chk IS
752: SELECT hoi.org_information1,
753: hoi.org_information2
754: FROM hr_organization_information hoi
755: WHERE hoi.org_information_id = p_org_information_id
756: AND hoi.org_information_context = 'NO_PENSION_PROVIDER';
757:
758: Cursor csr_pension_type_provider_chk IS

Line 762: FROM hr_organization_information hoi

758: Cursor csr_pension_type_provider_chk IS
759: SELECT hoi.org_information1,
760: hoi.org_information2,
761: hoi.org_information_id
762: FROM hr_organization_information hoi
763: WHERE hoi.organization_id = ( SELECT hoi1.organization_id
764: FROM hr_organization_information hoi1
765: WHERE hoi1.org_information_id = p_org_information_id
766: )

Line 764: FROM hr_organization_information hoi1

760: hoi.org_information2,
761: hoi.org_information_id
762: FROM hr_organization_information hoi
763: WHERE hoi.organization_id = ( SELECT hoi1.organization_id
764: FROM hr_organization_information hoi1
765: WHERE hoi1.org_information_id = p_org_information_id
766: )
767: AND hoi.org_information_context = 'NO_PENSION_PROVIDER'
768: AND hoi.org_information3 = p_org_information3

Line 835: from hr_organization_information

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

Line 1577: ,hr_organization_information hoi

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

Line 1783: ,hr_organization_information hoi

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