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

Line 305: l_org_information1 hr_organization_information.org_information1%TYPE;

301: l_return VARCHAR2(50);
302: l_field VARCHAR2(300) := NULL;
303:
304: l_business_group_id hr_organization_units.business_group_id%TYPE;
305: l_org_information1 hr_organization_information.org_information1%TYPE;
306: l_pension_type hr_organization_information.org_information1%TYPE;
307: l_pension_grp hr_organization_information.org_information1%TYPE;
308:
309: l_session_date DATE ;

Line 306: l_pension_type hr_organization_information.org_information1%TYPE;

302: l_field VARCHAR2(300) := NULL;
303:
304: l_business_group_id hr_organization_units.business_group_id%TYPE;
305: l_org_information1 hr_organization_information.org_information1%TYPE;
306: l_pension_type hr_organization_information.org_information1%TYPE;
307: l_pension_grp hr_organization_information.org_information1%TYPE;
308:
309: l_session_date DATE ;
310: l_count NUMBER ;

Line 307: l_pension_grp hr_organization_information.org_information1%TYPE;

303:
304: l_business_group_id hr_organization_units.business_group_id%TYPE;
305: l_org_information1 hr_organization_information.org_information1%TYPE;
306: l_pension_type hr_organization_information.org_information1%TYPE;
307: l_pension_grp hr_organization_information.org_information1%TYPE;
308:
309: l_session_date DATE ;
310: l_count NUMBER ;
311:

Line 342: FROM hr_organization_units o , hr_organization_information hoi ,fnd_sessions s

338:
339: CURSOR orglocalunit
340: IS
341: SELECT COUNT(*)
342: FROM hr_organization_units o , hr_organization_information hoi ,fnd_sessions s
343: WHERE o.organization_id = hoi.organization_id
344: AND hoi.org_information_context = 'CLASS'
345: AND hoi.org_information1 = 'FI_LOCAL_UNIT'
346: AND o.business_group_id = l_business_group_id

Line 350: FROM hr_organization_units org, hr_organization_information hoinf , fnd_sessions s

346: AND o.business_group_id = l_business_group_id
347: AND TO_CHAR(o.organization_id) IN
348: (
349: SELECT hoinf.org_information1
350: FROM hr_organization_units org, hr_organization_information hoinf , fnd_sessions s
351: WHERE org.business_group_id = l_business_group_id
352: AND org.organization_id = hoinf.organization_id
353: AND hoinf.org_information_context = 'FI_LOCAL_UNITS'
354: AND s.session_id = userenv('sessionid')

Line 365: FROM hr_organization_information hoi, hr_organization_units ou ,fnd_sessions s

361:
362: CURSOR getynumber
363: IS
364: SELECT count(*)
365: FROM hr_organization_information hoi, hr_organization_units ou ,fnd_sessions s
366: WHERE (hoi.org_information_context = 'FI_LEGAL_EMPLOYER_DETAILS' or
367: hoi.org_information_context = 'FI_EXTERNAL_COMPANY_DETAILS')
368: AND ou.organization_id = hoi.organization_id
369: AND ou.organization_id <> nvl(p_organization_id , 0)

Line 375: FROM hr_organization_information hoi, hr_organization_units ou

371: AND hoi.org_information1 = p_org_information1 ;
372:
373: CURSOR c_ins_group_code IS
374: SELECT COUNT(*)
375: FROM hr_organization_information hoi, hr_organization_units ou
376: WHERE (hoi.org_information_context = 'FI_PENSION_TYPES')
377: AND ou.organization_id = hoi.organization_id
378: AND ou.organization_id = nvl(p_organization_id , 0)
379: AND ou.business_group_id = l_business_group_id

Line 385: FROM hr_organization_information hoi, hr_organization_units ou

381: AND hoi.org_information2 = p_org_information2;
382:
383: CURSOR c_ins_tyel_pt IS
384: SELECT COUNT(*)
385: FROM hr_organization_information hoi, hr_organization_units ou
386: WHERE (hoi.org_information_context = 'FI_PENSION_TYPES')
387: AND ou.organization_id = hoi.organization_id
388: AND ou.organization_id = nvl(p_organization_id , 0)
389: AND ou.business_group_id = l_business_group_id

Line 397: FROM hr_organization_information hoi, hr_organization_units ou

393:
394:
395: CURSOR c_ins_dept_code IS
396: SELECT COUNT(*)
397: FROM hr_organization_information hoi, hr_organization_units ou
398: WHERE (hoi.org_information_context = 'FI_PENSION_DEPARTMENT_CODES')
399: AND ou.organization_id = hoi.organization_id
400: AND ou.organization_id = nvl(p_organization_id , 0)
401: AND ou.business_group_id = l_business_group_id

Line 407: FROM hr_organization_information hoi, hr_organization_units ou

403: AND hoi.org_information1 = p_org_information1;
404:
405: CURSOR c_ins_le_lc IS
406: SELECT COUNT(*)
407: FROM hr_organization_information hoi, hr_organization_units ou
408: WHERE (hoi.org_information_context = 'FI_PENSION_DEPARTMENT_CODES')
409: AND ou.organization_id = hoi.organization_id
410: AND ou.business_group_id = l_business_group_id
411: AND hoi.org_information1 = p_org_information1

Line 417: FROM hr_organization_information hoi, hr_organization_units ou

413:
414:
415: CURSOR c_ins_pp_ins_num IS
416: SELECT COUNT(*)
417: FROM hr_organization_information hoi, hr_organization_units ou
418: WHERE (hoi.org_information_context = 'FI_PENSION_PROVIDERS')
419: AND ou.organization_id = hoi.organization_id
420: AND ou.business_group_id = l_business_group_id
421: AND hoi.org_information6 = p_org_information6 ;

Line 426: FROM hr_organization_information hoi, hr_organization_units ou

422:
423:
424: CURSOR c_ins_lu_pp_ins_num IS
425: SELECT COUNT(*)
426: FROM hr_organization_information hoi, hr_organization_units ou
427: WHERE (hoi.org_information_context = 'FI_LU_PENSION_PROVIDERS')
428: AND ou.organization_id = hoi.organization_id
429: AND ou.organization_id = nvl(p_organization_id , 0)
430: AND ou.business_group_id = l_business_group_id

Line 436: FROM hr_organization_information hoi, hr_organization_units ou

432:
433:
434: CURSOR c_ins_le_ap_dtls IS
435: SELECT COUNT(*)
436: FROM hr_organization_information hoi, hr_organization_units ou
437: WHERE (hoi.org_information_context = 'FI_ACCIDENT_PROVIDERS')
438: AND ou.organization_id = hoi.organization_id
439: AND ou.organization_id = nvl(p_organization_id , 0)
440: AND ou.business_group_id = l_business_group_id

Line 452: FROM hr_organization_information hoi, hr_organization_units ou

448: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY'))));
449:
450: CURSOR c_ins_lu_ap_dtls IS
451: SELECT COUNT(*)
452: FROM hr_organization_information hoi, hr_organization_units ou
453: WHERE (hoi.org_information_context = 'FI_LU_ACCIDENT_PROVIDERS')
454: AND ou.organization_id = hoi.organization_id
455: AND ou.organization_id = nvl(p_organization_id , 0)
456: AND ou.business_group_id = l_business_group_id

Line 468: FROM hr_organization_information hoi, hr_organization_units ou

464: nvl(fnd_date.canonical_to_date(p_org_information2),to_date('31/12/4712','DD/MM/YYYY'))));
465:
466: CURSOR c_ins_pp_user_pt IS
467: SELECT COUNT(*)
468: FROM hr_organization_information hoi, hr_organization_units ou
469: WHERE (hoi.org_information_context = 'FI_PENSION_PROVIDERS')
470: AND ou.organization_id = hoi.organization_id
471: AND ou.organization_id = nvl(p_organization_id , 0)
472: AND ou.business_group_id = l_business_group_id

Line 478: FROM hr_organization_information hoi, hr_organization_units ou

474:
475:
476: CURSOR c_pg_dtls_pg IS
477: SELECT COUNT(*)
478: FROM hr_organization_information hoi, hr_organization_units ou
479: WHERE (hoi.org_information_context = 'FI_PENSION_GROUP_DETAILS')
480: AND ou.organization_id = hoi.organization_id
481: AND ou.business_group_id = l_business_group_id
482: AND hoi.org_information1 = p_org_information1

Line 1122: l_organization_id hr_organization_information.organization_id%TYPE;

1118: l_field VARCHAR2(300) := NULL;
1119:
1120:
1121: l_business_group_id hr_organization_units.business_group_id%TYPE;
1122: l_organization_id hr_organization_information.organization_id%TYPE;
1123: l_org_information1 hr_organization_information.org_information1%TYPE;
1124: l_pension_type hr_organization_information.org_information1%TYPE;
1125: l_pension_grp hr_organization_information.org_information1%TYPE;
1126:

Line 1123: l_org_information1 hr_organization_information.org_information1%TYPE;

1119:
1120:
1121: l_business_group_id hr_organization_units.business_group_id%TYPE;
1122: l_organization_id hr_organization_information.organization_id%TYPE;
1123: l_org_information1 hr_organization_information.org_information1%TYPE;
1124: l_pension_type hr_organization_information.org_information1%TYPE;
1125: l_pension_grp hr_organization_information.org_information1%TYPE;
1126:
1127: l_session_date DATE ;

Line 1124: l_pension_type hr_organization_information.org_information1%TYPE;

1120:
1121: l_business_group_id hr_organization_units.business_group_id%TYPE;
1122: l_organization_id hr_organization_information.organization_id%TYPE;
1123: l_org_information1 hr_organization_information.org_information1%TYPE;
1124: l_pension_type hr_organization_information.org_information1%TYPE;
1125: l_pension_grp hr_organization_information.org_information1%TYPE;
1126:
1127: l_session_date DATE ;
1128:

Line 1125: l_pension_grp hr_organization_information.org_information1%TYPE;

1121: l_business_group_id hr_organization_units.business_group_id%TYPE;
1122: l_organization_id hr_organization_information.organization_id%TYPE;
1123: l_org_information1 hr_organization_information.org_information1%TYPE;
1124: l_pension_type hr_organization_information.org_information1%TYPE;
1125: l_pension_grp hr_organization_information.org_information1%TYPE;
1126:
1127: l_session_date DATE ;
1128:
1129: INVALID_POLICY_NUMBER_FORMAT EXCEPTION;

Line 1157: FROM hr_organization_information

1153:
1154: CURSOR getorgid
1155: IS
1156: SELECT organization_id
1157: FROM hr_organization_information
1158: WHERE org_information_id = p_org_information_id;
1159:
1160: CURSOR orglocalunit
1161: IS

Line 1163: FROM hr_organization_units o , hr_organization_information hoi ,fnd_sessions s

1159:
1160: CURSOR orglocalunit
1161: IS
1162: SELECT COUNT(*)
1163: FROM hr_organization_units o , hr_organization_information hoi ,fnd_sessions s
1164: WHERE o.organization_id = hoi.organization_id
1165: AND hoi.org_information_context = 'CLASS'
1166: AND hoi.org_information1 = 'FI_LOCAL_UNIT'
1167: AND o.business_group_id = l_business_group_id

Line 1171: FROM hr_organization_units org, hr_organization_information hoinf ,fnd_sessions s

1167: AND o.business_group_id = l_business_group_id
1168: AND TO_CHAR(o.organization_id) IN
1169: (
1170: SELECT hoinf.org_information1
1171: FROM hr_organization_units org, hr_organization_information hoinf ,fnd_sessions s
1172: WHERE org.business_group_id = l_business_group_id
1173: AND org.organization_id = hoinf.organization_id
1174: AND org.organization_id <> l_organization_id
1175: AND hoinf.org_information_context = 'FI_LOCAL_UNITS'

Line 1186: FROM hr_organization_information hoi, hr_organization_units ou

1182:
1183: CURSOR getynumber
1184: IS
1185: SELECT COUNT(*)
1186: FROM hr_organization_information hoi, hr_organization_units ou
1187: WHERE (hoi.org_information_context = 'FI_LEGAL_EMPLOYER_DETAILS' or
1188: hoi.org_information_context = 'FI_EXTERNAL_COMPANY_DETAILS')
1189: AND ou.organization_id = hoi.organization_id
1190: AND ou.organization_id <> nvl(l_organization_id , 0)

Line 1196: FROM hr_organization_information hoi, hr_organization_units ou

1192: AND hoi.org_information1 = p_org_information1 ;
1193:
1194: CURSOR c_upd_group_code IS
1195: SELECT COUNT(*)
1196: FROM hr_organization_information hoi, hr_organization_units ou
1197: WHERE (hoi.org_information_context = 'FI_PENSION_TYPES')
1198: AND ou.organization_id = hoi.organization_id
1199: AND ou.organization_id = nvl(l_organization_id , 0)
1200: AND ou.business_group_id = l_business_group_id

Line 1207: FROM hr_organization_information hoi, hr_organization_units ou

1203: AND hoi.org_information_id <> p_org_information_id ;
1204:
1205: CURSOR c_upd_tyel_pt IS
1206: SELECT COUNT(*)
1207: FROM hr_organization_information hoi, hr_organization_units ou
1208: WHERE (hoi.org_information_context = 'FI_PENSION_TYPES')
1209: AND ou.organization_id = hoi.organization_id
1210: AND ou.organization_id = nvl(l_organization_id , 0)
1211: AND ou.business_group_id = l_business_group_id

Line 1219: FROM hr_organization_information hoi, hr_organization_units ou

1215: AND hoi.org_information3 IS NULL;
1216:
1217: CURSOR c_upd_dept_code IS
1218: SELECT COUNT(*)
1219: FROM hr_organization_information hoi, hr_organization_units ou
1220: WHERE (hoi.org_information_context = 'FI_PENSION_DEPARTMENT_CODES')
1221: AND ou.organization_id = hoi.organization_id
1222: AND ou.organization_id = nvl(l_organization_id , 0)
1223: AND ou.business_group_id = l_business_group_id

Line 1230: FROM hr_organization_information hoi, hr_organization_units ou

1226: AND hoi.org_information_id <> p_org_information_id ;
1227:
1228: CURSOR c_upd_le_lc IS
1229: SELECT COUNT(*)
1230: FROM hr_organization_information hoi, hr_organization_units ou
1231: WHERE (hoi.org_information_context = 'FI_PENSION_DEPARTMENT_CODES')
1232: AND ou.organization_id = hoi.organization_id
1233: AND ou.business_group_id = l_business_group_id
1234: AND hoi.org_information1 = p_org_information1

Line 1240: FROM hr_organization_information hoi, hr_organization_units ou

1236: AND hoi.org_information_id <> p_org_information_id ;
1237:
1238: CURSOR c_upd_pp_ins_num IS
1239: SELECT COUNT(*)
1240: FROM hr_organization_information hoi, hr_organization_units ou
1241: WHERE (hoi.org_information_context = 'FI_PENSION_PROVIDERS')
1242: AND ou.business_group_id = l_business_group_id
1243: AND ou.organization_id = hoi.organization_id
1244: AND hoi.org_information6 = p_org_information6

Line 1249: FROM hr_organization_information hoi, hr_organization_units ou

1245: AND hoi.org_information_id <> p_org_information_id ;
1246:
1247: CURSOR c_upd_pp_user_pt IS
1248: SELECT COUNT(*)
1249: FROM hr_organization_information hoi, hr_organization_units ou
1250: WHERE (hoi.org_information_context = 'FI_PENSION_PROVIDERS')
1251: AND ou.business_group_id = l_business_group_id
1252: AND ou.organization_id = hoi.organization_id
1253: AND ou.organization_id = nvl(l_organization_id , 0)

Line 1260: FROM hr_organization_information hoi, hr_organization_units ou

1256:
1257:
1258: CURSOR c_upd_lu_pp_ins_num IS
1259: SELECT COUNT(*)
1260: FROM hr_organization_information hoi, hr_organization_units ou
1261: WHERE (hoi.org_information_context = 'FI_LU_PENSION_PROVIDERS')
1262: AND ou.organization_id = hoi.organization_id
1263: AND ou.organization_id = nvl(l_organization_id , 0)
1264: AND ou.business_group_id = l_business_group_id

Line 1271: FROM hr_organization_information hoi, hr_organization_units ou

1267:
1268:
1269: CURSOR c_upd_le_ap_dtls IS
1270: SELECT COUNT(*)
1271: FROM hr_organization_information hoi, hr_organization_units ou
1272: WHERE (hoi.org_information_context = 'FI_ACCIDENT_PROVIDERS')
1273: AND ou.organization_id = hoi.organization_id
1274: AND ou.organization_id = nvl(l_organization_id , 0)
1275: AND ou.business_group_id = l_business_group_id

Line 1288: FROM hr_organization_information hoi, hr_organization_units ou

1284: AND hoi.org_information_id <> p_org_information_id ;
1285:
1286: CURSOR c_upd_lu_ap_dtls IS
1287: SELECT COUNT(*)
1288: FROM hr_organization_information hoi, hr_organization_units ou
1289: WHERE (hoi.org_information_context = 'FI_LU_ACCIDENT_PROVIDERS')
1290: AND ou.organization_id = hoi.organization_id
1291: AND ou.organization_id = nvl(l_organization_id , 0)
1292: AND ou.business_group_id = l_business_group_id

Line 1308: FROM hr_organization_information hoi, hr_organization_units ou

1304:
1305:
1306: CURSOR c_upd_pg_dtls_pg IS
1307: SELECT COUNT(*)
1308: FROM hr_organization_information hoi, hr_organization_units ou
1309: WHERE (hoi.org_information_context = 'FI_PENSION_GROUP_DETAILS')
1310: AND ou.organization_id = hoi.organization_id
1311: AND ou.organization_id = nvl(l_organization_id , 0)
1312: AND ou.business_group_id = l_business_group_id

Line 1961: ,HR_ORGANIZATION_INFORMATION hoi1

1957: CURSOR get_rpt_asg ( p_le NUMBER )
1958: IS
1959: SELECT hsc.segment12
1960: FROM HR_ORGANIZATION_UNITS o1
1961: ,HR_ORGANIZATION_INFORMATION hoi1
1962: ,HR_ORGANIZATION_INFORMATION hoi2
1963: ,PER_ALL_ASSIGNMENTS_F paa
1964: ,HR_SOFT_CODING_KEYFLEX hsc
1965: WHERE o1.business_group_id =l_business_group_id

Line 1962: ,HR_ORGANIZATION_INFORMATION hoi2

1958: IS
1959: SELECT hsc.segment12
1960: FROM HR_ORGANIZATION_UNITS o1
1961: ,HR_ORGANIZATION_INFORMATION hoi1
1962: ,HR_ORGANIZATION_INFORMATION hoi2
1963: ,PER_ALL_ASSIGNMENTS_F paa
1964: ,HR_SOFT_CODING_KEYFLEX hsc
1965: WHERE o1.business_group_id =l_business_group_id
1966: and o1.organization_id = hoi1.organization_id

Line 1981: , HR_ORGANIZATION_INFORMATION hoi1

1977:
1978: CURSOR csr_le IS
1979: SELECT hoi3.organization_id
1980: FROM HR_ORGANIZATION_UNITS o1
1981: , HR_ORGANIZATION_INFORMATION hoi1
1982: , HR_ORGANIZATION_INFORMATION hoi2
1983: , HR_ORGANIZATION_INFORMATION hoi3
1984: WHERE o1.business_group_id =l_business_group_id
1985: AND hoi1.organization_id = o1.organization_id

Line 1982: , HR_ORGANIZATION_INFORMATION hoi2

1978: CURSOR csr_le IS
1979: SELECT hoi3.organization_id
1980: FROM HR_ORGANIZATION_UNITS o1
1981: , HR_ORGANIZATION_INFORMATION hoi1
1982: , HR_ORGANIZATION_INFORMATION hoi2
1983: , HR_ORGANIZATION_INFORMATION hoi3
1984: WHERE o1.business_group_id =l_business_group_id
1985: AND hoi1.organization_id = o1.organization_id
1986: AND hoi1.organization_id = p_organization_id

Line 1983: , HR_ORGANIZATION_INFORMATION hoi3

1979: SELECT hoi3.organization_id
1980: FROM HR_ORGANIZATION_UNITS o1
1981: , HR_ORGANIZATION_INFORMATION hoi1
1982: , HR_ORGANIZATION_INFORMATION hoi2
1983: , HR_ORGANIZATION_INFORMATION hoi3
1984: WHERE o1.business_group_id =l_business_group_id
1985: AND hoi1.organization_id = o1.organization_id
1986: AND hoi1.organization_id = p_organization_id
1987: AND hoi1.org_information1 = 'FI_LOCAL_UNIT'

Line 2065: ,HR_ORGANIZATION_INFORMATION hoi1

2061: CURSOR get_rpt_asg ( p_le NUMBER )
2062: IS
2063: SELECT hsc.segment12
2064: FROM HR_ORGANIZATION_UNITS o1
2065: ,HR_ORGANIZATION_INFORMATION hoi1
2066: ,HR_ORGANIZATION_INFORMATION hoi2
2067: ,PER_ALL_ASSIGNMENTS_F paa
2068: ,HR_SOFT_CODING_KEYFLEX hsc
2069: WHERE o1.business_group_id =l_business_group_id

Line 2066: ,HR_ORGANIZATION_INFORMATION hoi2

2062: IS
2063: SELECT hsc.segment12
2064: FROM HR_ORGANIZATION_UNITS o1
2065: ,HR_ORGANIZATION_INFORMATION hoi1
2066: ,HR_ORGANIZATION_INFORMATION hoi2
2067: ,PER_ALL_ASSIGNMENTS_F paa
2068: ,HR_SOFT_CODING_KEYFLEX hsc
2069: WHERE o1.business_group_id =l_business_group_id
2070: and o1.organization_id = hoi1.organization_id

Line 2086: , HR_ORGANIZATION_INFORMATION hoi1

2082:
2083: CURSOR csr_le IS
2084: SELECT hoi3.organization_id
2085: FROM HR_ORGANIZATION_UNITS o1
2086: , HR_ORGANIZATION_INFORMATION hoi1
2087: , HR_ORGANIZATION_INFORMATION hoi2
2088: , HR_ORGANIZATION_INFORMATION hoi3
2089: WHERE o1.business_group_id =l_business_group_id
2090: AND hoi1.organization_id = o1.organization_id

Line 2087: , HR_ORGANIZATION_INFORMATION hoi2

2083: CURSOR csr_le IS
2084: SELECT hoi3.organization_id
2085: FROM HR_ORGANIZATION_UNITS o1
2086: , HR_ORGANIZATION_INFORMATION hoi1
2087: , HR_ORGANIZATION_INFORMATION hoi2
2088: , HR_ORGANIZATION_INFORMATION hoi3
2089: WHERE o1.business_group_id =l_business_group_id
2090: AND hoi1.organization_id = o1.organization_id
2091: AND hoi1.organization_id = p_segment2

Line 2088: , HR_ORGANIZATION_INFORMATION hoi3

2084: SELECT hoi3.organization_id
2085: FROM HR_ORGANIZATION_UNITS o1
2086: , HR_ORGANIZATION_INFORMATION hoi1
2087: , HR_ORGANIZATION_INFORMATION hoi2
2088: , HR_ORGANIZATION_INFORMATION hoi3
2089: WHERE o1.business_group_id =l_business_group_id
2090: AND hoi1.organization_id = o1.organization_id
2091: AND hoi1.organization_id = p_segment2
2092: AND hoi1.org_information1 = 'FI_LOCAL_UNIT'