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

296: l_return VARCHAR2(50);
297: l_field VARCHAR2(300) := NULL;
298:
299: l_business_group_id hr_organization_units.business_group_id%TYPE;
300: l_org_information1 hr_organization_information.org_information1%TYPE;
301: l_pension_type hr_organization_information.org_information1%TYPE;
302: l_pension_grp hr_organization_information.org_information1%TYPE;
303:
304: l_session_date DATE ;

Line 301: l_pension_type hr_organization_information.org_information1%TYPE;

297: l_field VARCHAR2(300) := NULL;
298:
299: l_business_group_id hr_organization_units.business_group_id%TYPE;
300: l_org_information1 hr_organization_information.org_information1%TYPE;
301: l_pension_type hr_organization_information.org_information1%TYPE;
302: l_pension_grp hr_organization_information.org_information1%TYPE;
303:
304: l_session_date DATE ;
305: l_count NUMBER ;

Line 302: l_pension_grp hr_organization_information.org_information1%TYPE;

298:
299: l_business_group_id hr_organization_units.business_group_id%TYPE;
300: l_org_information1 hr_organization_information.org_information1%TYPE;
301: l_pension_type hr_organization_information.org_information1%TYPE;
302: l_pension_grp hr_organization_information.org_information1%TYPE;
303:
304: l_session_date DATE ;
305: l_count NUMBER ;
306:

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

333:
334: CURSOR orglocalunit
335: IS
336: SELECT COUNT(*)
337: FROM hr_organization_units o , hr_organization_information hoi ,fnd_sessions s
338: WHERE o.organization_id = hoi.organization_id
339: AND hoi.org_information_context = 'CLASS'
340: AND hoi.org_information1 = 'FI_LOCAL_UNIT'
341: AND o.business_group_id = l_business_group_id

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

341: AND o.business_group_id = l_business_group_id
342: AND TO_CHAR(o.organization_id) IN
343: (
344: SELECT hoinf.org_information1
345: FROM hr_organization_units org, hr_organization_information hoinf , fnd_sessions s
346: WHERE org.business_group_id = l_business_group_id
347: AND org.organization_id = hoinf.organization_id
348: AND hoinf.org_information_context = 'FI_LOCAL_UNITS'
349: AND s.session_id = userenv('sessionid')

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

356:
357: CURSOR getynumber
358: IS
359: SELECT count(*)
360: FROM hr_organization_information hoi, hr_organization_units ou ,fnd_sessions s
361: WHERE (hoi.org_information_context = 'FI_LEGAL_EMPLOYER_DETAILS' or
362: hoi.org_information_context = 'FI_EXTERNAL_COMPANY_DETAILS')
363: AND ou.organization_id = hoi.organization_id
364: AND ou.organization_id <> nvl(p_organization_id , 0)

Line 370: FROM hr_organization_information hoi, hr_organization_units ou

366: AND hoi.org_information1 = p_org_information1 ;
367:
368: CURSOR c_ins_group_code IS
369: SELECT COUNT(*)
370: FROM hr_organization_information hoi, hr_organization_units ou
371: WHERE (hoi.org_information_context = 'FI_PENSION_TYPES')
372: AND ou.organization_id = hoi.organization_id
373: AND ou.organization_id = nvl(p_organization_id , 0)
374: AND ou.business_group_id = l_business_group_id

Line 380: FROM hr_organization_information hoi, hr_organization_units ou

376: AND hoi.org_information2 = p_org_information2;
377:
378: CURSOR c_ins_tyel_pt IS
379: SELECT COUNT(*)
380: FROM hr_organization_information hoi, hr_organization_units ou
381: WHERE (hoi.org_information_context = 'FI_PENSION_TYPES')
382: AND ou.organization_id = hoi.organization_id
383: AND ou.organization_id = nvl(p_organization_id , 0)
384: AND ou.business_group_id = l_business_group_id

Line 392: FROM hr_organization_information hoi, hr_organization_units ou

388:
389:
390: CURSOR c_ins_dept_code IS
391: SELECT COUNT(*)
392: FROM hr_organization_information hoi, hr_organization_units ou
393: WHERE (hoi.org_information_context = 'FI_PENSION_DEPARTMENT_CODES')
394: AND ou.organization_id = hoi.organization_id
395: AND ou.organization_id = nvl(p_organization_id , 0)
396: AND ou.business_group_id = l_business_group_id

Line 402: FROM hr_organization_information hoi, hr_organization_units ou

398: AND hoi.org_information1 = p_org_information1;
399:
400: CURSOR c_ins_le_lc IS
401: SELECT COUNT(*)
402: FROM hr_organization_information hoi, hr_organization_units ou
403: WHERE (hoi.org_information_context = 'FI_PENSION_DEPARTMENT_CODES')
404: AND ou.organization_id = hoi.organization_id
405: AND ou.business_group_id = l_business_group_id
406: AND hoi.org_information1 = p_org_information1

Line 412: FROM hr_organization_information hoi, hr_organization_units ou

408:
409:
410: CURSOR c_ins_pp_ins_num IS
411: SELECT COUNT(*)
412: FROM hr_organization_information hoi, hr_organization_units ou
413: WHERE (hoi.org_information_context = 'FI_PENSION_PROVIDERS')
414: AND ou.organization_id = hoi.organization_id
415: AND ou.business_group_id = l_business_group_id
416: AND hoi.org_information6 = p_org_information6 ;

Line 421: FROM hr_organization_information hoi, hr_organization_units ou

417:
418:
419: CURSOR c_ins_lu_pp_ins_num IS
420: SELECT COUNT(*)
421: FROM hr_organization_information hoi, hr_organization_units ou
422: WHERE (hoi.org_information_context = 'FI_LU_PENSION_PROVIDERS')
423: AND ou.organization_id = hoi.organization_id
424: AND ou.organization_id = nvl(p_organization_id , 0)
425: AND ou.business_group_id = l_business_group_id

Line 431: FROM hr_organization_information hoi, hr_organization_units ou

427:
428:
429: CURSOR c_ins_le_ap_dtls IS
430: SELECT COUNT(*)
431: FROM hr_organization_information hoi, hr_organization_units ou
432: WHERE (hoi.org_information_context = 'FI_ACCIDENT_PROVIDERS')
433: AND ou.organization_id = hoi.organization_id
434: AND ou.organization_id = nvl(p_organization_id , 0)
435: AND ou.business_group_id = l_business_group_id

Line 447: FROM hr_organization_information hoi, hr_organization_units ou

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

Line 463: FROM hr_organization_information hoi, hr_organization_units ou

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

Line 473: FROM hr_organization_information hoi, hr_organization_units ou

469:
470:
471: CURSOR c_pg_dtls_pg IS
472: SELECT COUNT(*)
473: FROM hr_organization_information hoi, hr_organization_units ou
474: WHERE (hoi.org_information_context = 'FI_PENSION_GROUP_DETAILS')
475: AND ou.organization_id = hoi.organization_id
476: AND ou.business_group_id = l_business_group_id
477: AND hoi.org_information1 = p_org_information1

Line 1108: l_organization_id hr_organization_information.organization_id%TYPE;

1104: l_field VARCHAR2(300) := NULL;
1105:
1106:
1107: l_business_group_id hr_organization_units.business_group_id%TYPE;
1108: l_organization_id hr_organization_information.organization_id%TYPE;
1109: l_org_information1 hr_organization_information.org_information1%TYPE;
1110: l_pension_type hr_organization_information.org_information1%TYPE;
1111: l_pension_grp hr_organization_information.org_information1%TYPE;
1112:

Line 1109: l_org_information1 hr_organization_information.org_information1%TYPE;

1105:
1106:
1107: l_business_group_id hr_organization_units.business_group_id%TYPE;
1108: l_organization_id hr_organization_information.organization_id%TYPE;
1109: l_org_information1 hr_organization_information.org_information1%TYPE;
1110: l_pension_type hr_organization_information.org_information1%TYPE;
1111: l_pension_grp hr_organization_information.org_information1%TYPE;
1112:
1113: l_session_date DATE ;

Line 1110: l_pension_type hr_organization_information.org_information1%TYPE;

1106:
1107: l_business_group_id hr_organization_units.business_group_id%TYPE;
1108: l_organization_id hr_organization_information.organization_id%TYPE;
1109: l_org_information1 hr_organization_information.org_information1%TYPE;
1110: l_pension_type hr_organization_information.org_information1%TYPE;
1111: l_pension_grp hr_organization_information.org_information1%TYPE;
1112:
1113: l_session_date DATE ;
1114:

Line 1111: l_pension_grp hr_organization_information.org_information1%TYPE;

1107: l_business_group_id hr_organization_units.business_group_id%TYPE;
1108: l_organization_id hr_organization_information.organization_id%TYPE;
1109: l_org_information1 hr_organization_information.org_information1%TYPE;
1110: l_pension_type hr_organization_information.org_information1%TYPE;
1111: l_pension_grp hr_organization_information.org_information1%TYPE;
1112:
1113: l_session_date DATE ;
1114:
1115: INVALID_POLICY_NUMBER_FORMAT EXCEPTION;

Line 1143: FROM hr_organization_information

1139:
1140: CURSOR getorgid
1141: IS
1142: SELECT organization_id
1143: FROM hr_organization_information
1144: WHERE org_information_id = p_org_information_id;
1145:
1146: CURSOR orglocalunit
1147: IS

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

1145:
1146: CURSOR orglocalunit
1147: IS
1148: SELECT COUNT(*)
1149: FROM hr_organization_units o , hr_organization_information hoi ,fnd_sessions s
1150: WHERE o.organization_id = hoi.organization_id
1151: AND hoi.org_information_context = 'CLASS'
1152: AND hoi.org_information1 = 'FI_LOCAL_UNIT'
1153: AND o.business_group_id = l_business_group_id

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

1153: AND o.business_group_id = l_business_group_id
1154: AND TO_CHAR(o.organization_id) IN
1155: (
1156: SELECT hoinf.org_information1
1157: FROM hr_organization_units org, hr_organization_information hoinf ,fnd_sessions s
1158: WHERE org.business_group_id = l_business_group_id
1159: AND org.organization_id = hoinf.organization_id
1160: AND org.organization_id <> l_organization_id
1161: AND hoinf.org_information_context = 'FI_LOCAL_UNITS'

Line 1172: FROM hr_organization_information hoi, hr_organization_units ou

1168:
1169: CURSOR getynumber
1170: IS
1171: SELECT COUNT(*)
1172: FROM hr_organization_information hoi, hr_organization_units ou
1173: WHERE (hoi.org_information_context = 'FI_LEGAL_EMPLOYER_DETAILS' or
1174: hoi.org_information_context = 'FI_EXTERNAL_COMPANY_DETAILS')
1175: AND ou.organization_id = hoi.organization_id
1176: AND ou.organization_id <> nvl(l_organization_id , 0)

Line 1182: FROM hr_organization_information hoi, hr_organization_units ou

1178: AND hoi.org_information1 = p_org_information1 ;
1179:
1180: CURSOR c_upd_group_code IS
1181: SELECT COUNT(*)
1182: FROM hr_organization_information hoi, hr_organization_units ou
1183: WHERE (hoi.org_information_context = 'FI_PENSION_TYPES')
1184: AND ou.organization_id = hoi.organization_id
1185: AND ou.organization_id = nvl(l_organization_id , 0)
1186: AND ou.business_group_id = l_business_group_id

Line 1193: FROM hr_organization_information hoi, hr_organization_units ou

1189: AND hoi.org_information_id <> p_org_information_id ;
1190:
1191: CURSOR c_upd_tyel_pt IS
1192: SELECT COUNT(*)
1193: FROM hr_organization_information hoi, hr_organization_units ou
1194: WHERE (hoi.org_information_context = 'FI_PENSION_TYPES')
1195: AND ou.organization_id = hoi.organization_id
1196: AND ou.organization_id = nvl(l_organization_id , 0)
1197: AND ou.business_group_id = l_business_group_id

Line 1205: FROM hr_organization_information hoi, hr_organization_units ou

1201: AND hoi.org_information3 IS NULL;
1202:
1203: CURSOR c_upd_dept_code IS
1204: SELECT COUNT(*)
1205: FROM hr_organization_information hoi, hr_organization_units ou
1206: WHERE (hoi.org_information_context = 'FI_PENSION_DEPARTMENT_CODES')
1207: AND ou.organization_id = hoi.organization_id
1208: AND ou.organization_id = nvl(l_organization_id , 0)
1209: AND ou.business_group_id = l_business_group_id

Line 1216: FROM hr_organization_information hoi, hr_organization_units ou

1212: AND hoi.org_information_id <> p_org_information_id ;
1213:
1214: CURSOR c_upd_le_lc IS
1215: SELECT COUNT(*)
1216: FROM hr_organization_information hoi, hr_organization_units ou
1217: WHERE (hoi.org_information_context = 'FI_PENSION_DEPARTMENT_CODES')
1218: AND ou.organization_id = hoi.organization_id
1219: AND ou.business_group_id = l_business_group_id
1220: AND hoi.org_information1 = p_org_information1

Line 1226: FROM hr_organization_information hoi, hr_organization_units ou

1222: AND hoi.org_information_id <> p_org_information_id ;
1223:
1224: CURSOR c_upd_pp_ins_num IS
1225: SELECT COUNT(*)
1226: FROM hr_organization_information hoi, hr_organization_units ou
1227: WHERE (hoi.org_information_context = 'FI_PENSION_PROVIDERS')
1228: AND ou.business_group_id = l_business_group_id
1229: AND ou.organization_id = hoi.organization_id
1230: AND hoi.org_information6 = p_org_information6

Line 1235: FROM hr_organization_information hoi, hr_organization_units ou

1231: AND hoi.org_information_id <> p_org_information_id ;
1232:
1233: CURSOR c_upd_pp_user_pt IS
1234: SELECT COUNT(*)
1235: FROM hr_organization_information hoi, hr_organization_units ou
1236: WHERE (hoi.org_information_context = 'FI_PENSION_PROVIDERS')
1237: AND ou.business_group_id = l_business_group_id
1238: AND ou.organization_id = hoi.organization_id
1239: AND ou.organization_id = nvl(l_organization_id , 0)

Line 1246: FROM hr_organization_information hoi, hr_organization_units ou

1242:
1243:
1244: CURSOR c_upd_lu_pp_ins_num IS
1245: SELECT COUNT(*)
1246: FROM hr_organization_information hoi, hr_organization_units ou
1247: WHERE (hoi.org_information_context = 'FI_LU_PENSION_PROVIDERS')
1248: AND ou.organization_id = hoi.organization_id
1249: AND ou.organization_id = nvl(l_organization_id , 0)
1250: AND ou.business_group_id = l_business_group_id

Line 1257: FROM hr_organization_information hoi, hr_organization_units ou

1253:
1254:
1255: CURSOR c_upd_le_ap_dtls IS
1256: SELECT COUNT(*)
1257: FROM hr_organization_information hoi, hr_organization_units ou
1258: WHERE (hoi.org_information_context = 'FI_ACCIDENT_PROVIDERS')
1259: AND ou.organization_id = hoi.organization_id
1260: AND ou.organization_id = nvl(l_organization_id , 0)
1261: AND ou.business_group_id = l_business_group_id

Line 1274: FROM hr_organization_information hoi, hr_organization_units ou

1270: AND hoi.org_information_id <> p_org_information_id ;
1271:
1272: CURSOR c_upd_lu_ap_dtls IS
1273: SELECT COUNT(*)
1274: FROM hr_organization_information hoi, hr_organization_units ou
1275: WHERE (hoi.org_information_context = 'FI_LU_ACCIDENT_PROVIDERS')
1276: AND ou.organization_id = hoi.organization_id
1277: AND ou.organization_id = nvl(l_organization_id , 0)
1278: AND ou.business_group_id = l_business_group_id

Line 1294: FROM hr_organization_information hoi, hr_organization_units ou

1290:
1291:
1292: CURSOR c_upd_pg_dtls_pg IS
1293: SELECT COUNT(*)
1294: FROM hr_organization_information hoi, hr_organization_units ou
1295: WHERE (hoi.org_information_context = 'FI_PENSION_GROUP_DETAILS')
1296: AND ou.organization_id = hoi.organization_id
1297: AND ou.organization_id = nvl(l_organization_id , 0)
1298: AND ou.business_group_id = l_business_group_id

Line 1941: ,HR_ORGANIZATION_INFORMATION hoi1

1937: CURSOR get_rpt_asg ( p_le NUMBER )
1938: IS
1939: SELECT hsc.segment12
1940: FROM HR_ORGANIZATION_UNITS o1
1941: ,HR_ORGANIZATION_INFORMATION hoi1
1942: ,HR_ORGANIZATION_INFORMATION hoi2
1943: ,PER_ALL_ASSIGNMENTS_F paa
1944: ,HR_SOFT_CODING_KEYFLEX hsc
1945: WHERE o1.business_group_id =l_business_group_id

Line 1942: ,HR_ORGANIZATION_INFORMATION hoi2

1938: IS
1939: SELECT hsc.segment12
1940: FROM HR_ORGANIZATION_UNITS o1
1941: ,HR_ORGANIZATION_INFORMATION hoi1
1942: ,HR_ORGANIZATION_INFORMATION hoi2
1943: ,PER_ALL_ASSIGNMENTS_F paa
1944: ,HR_SOFT_CODING_KEYFLEX hsc
1945: WHERE o1.business_group_id =l_business_group_id
1946: and o1.organization_id = hoi1.organization_id

Line 1961: , HR_ORGANIZATION_INFORMATION hoi1

1957:
1958: CURSOR csr_le IS
1959: SELECT hoi3.organization_id
1960: FROM HR_ORGANIZATION_UNITS o1
1961: , HR_ORGANIZATION_INFORMATION hoi1
1962: , HR_ORGANIZATION_INFORMATION hoi2
1963: , HR_ORGANIZATION_INFORMATION hoi3
1964: WHERE o1.business_group_id =l_business_group_id
1965: AND hoi1.organization_id = o1.organization_id

Line 1962: , HR_ORGANIZATION_INFORMATION hoi2

1958: CURSOR csr_le IS
1959: SELECT hoi3.organization_id
1960: FROM HR_ORGANIZATION_UNITS o1
1961: , HR_ORGANIZATION_INFORMATION hoi1
1962: , HR_ORGANIZATION_INFORMATION hoi2
1963: , HR_ORGANIZATION_INFORMATION hoi3
1964: WHERE o1.business_group_id =l_business_group_id
1965: AND hoi1.organization_id = o1.organization_id
1966: AND hoi1.organization_id = p_organization_id

Line 1963: , HR_ORGANIZATION_INFORMATION hoi3

1959: SELECT hoi3.organization_id
1960: FROM HR_ORGANIZATION_UNITS o1
1961: , HR_ORGANIZATION_INFORMATION hoi1
1962: , HR_ORGANIZATION_INFORMATION hoi2
1963: , HR_ORGANIZATION_INFORMATION hoi3
1964: WHERE o1.business_group_id =l_business_group_id
1965: AND hoi1.organization_id = o1.organization_id
1966: AND hoi1.organization_id = p_organization_id
1967: AND hoi1.org_information1 = 'FI_LOCAL_UNIT'

Line 2045: ,HR_ORGANIZATION_INFORMATION hoi1

2041: CURSOR get_rpt_asg ( p_le NUMBER )
2042: IS
2043: SELECT hsc.segment12
2044: FROM HR_ORGANIZATION_UNITS o1
2045: ,HR_ORGANIZATION_INFORMATION hoi1
2046: ,HR_ORGANIZATION_INFORMATION hoi2
2047: ,PER_ALL_ASSIGNMENTS_F paa
2048: ,HR_SOFT_CODING_KEYFLEX hsc
2049: WHERE o1.business_group_id =l_business_group_id

Line 2046: ,HR_ORGANIZATION_INFORMATION hoi2

2042: IS
2043: SELECT hsc.segment12
2044: FROM HR_ORGANIZATION_UNITS o1
2045: ,HR_ORGANIZATION_INFORMATION hoi1
2046: ,HR_ORGANIZATION_INFORMATION hoi2
2047: ,PER_ALL_ASSIGNMENTS_F paa
2048: ,HR_SOFT_CODING_KEYFLEX hsc
2049: WHERE o1.business_group_id =l_business_group_id
2050: and o1.organization_id = hoi1.organization_id

Line 2066: , HR_ORGANIZATION_INFORMATION hoi1

2062:
2063: CURSOR csr_le IS
2064: SELECT hoi3.organization_id
2065: FROM HR_ORGANIZATION_UNITS o1
2066: , HR_ORGANIZATION_INFORMATION hoi1
2067: , HR_ORGANIZATION_INFORMATION hoi2
2068: , HR_ORGANIZATION_INFORMATION hoi3
2069: WHERE o1.business_group_id =l_business_group_id
2070: AND hoi1.organization_id = o1.organization_id

Line 2067: , HR_ORGANIZATION_INFORMATION hoi2

2063: CURSOR csr_le IS
2064: SELECT hoi3.organization_id
2065: FROM HR_ORGANIZATION_UNITS o1
2066: , HR_ORGANIZATION_INFORMATION hoi1
2067: , HR_ORGANIZATION_INFORMATION hoi2
2068: , HR_ORGANIZATION_INFORMATION hoi3
2069: WHERE o1.business_group_id =l_business_group_id
2070: AND hoi1.organization_id = o1.organization_id
2071: AND hoi1.organization_id = p_segment2

Line 2068: , HR_ORGANIZATION_INFORMATION hoi3

2064: SELECT hoi3.organization_id
2065: FROM HR_ORGANIZATION_UNITS o1
2066: , HR_ORGANIZATION_INFORMATION hoi1
2067: , HR_ORGANIZATION_INFORMATION hoi2
2068: , HR_ORGANIZATION_INFORMATION hoi3
2069: WHERE o1.business_group_id =l_business_group_id
2070: AND hoi1.organization_id = o1.organization_id
2071: AND hoi1.organization_id = p_segment2
2072: AND hoi1.org_information1 = 'FI_LOCAL_UNIT'