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_UNITS

Line 299: l_business_group_id hr_organization_units.business_group_id%TYPE;

295: l_warning VARCHAR2(50);
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:

Line 331: FROM hr_organization_units

327:
328: CURSOR getbgid
329: IS
330: SELECT business_group_id
331: FROM hr_organization_units
332: WHERE organization_id = p_organization_id;
333:
334: CURSOR orglocalunit
335: IS

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 1107: l_business_group_id hr_organization_units.business_group_id%TYPE;

1103: l_return VARCHAR2(50);
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;

Line 1137: FROM hr_organization_units

1133:
1134: CURSOR getbgid
1135: IS
1136: SELECT business_group_id
1137: FROM hr_organization_units
1138: where organization_id = l_organization_id;
1139:
1140: CURSOR getorgid
1141: 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 1928: l_business_group_id hr_organization_units.business_group_id%TYPE;

1924: l_yes_or_no VARCHAR2(10);
1925: l_count NUMBER ;
1926:
1927: UNIQUE_RPT_ASG EXCEPTION ;
1928: l_business_group_id hr_organization_units.business_group_id%TYPE;
1929: l_le hr_organization_units.organization_id%type;
1930:
1931: CURSOR getbgid
1932: IS

Line 1929: l_le hr_organization_units.organization_id%type;

1925: l_count NUMBER ;
1926:
1927: UNIQUE_RPT_ASG EXCEPTION ;
1928: l_business_group_id hr_organization_units.business_group_id%TYPE;
1929: l_le hr_organization_units.organization_id%type;
1930:
1931: CURSOR getbgid
1932: IS
1933: SELECT business_group_id

Line 1934: FROM hr_organization_units

1930:
1931: CURSOR getbgid
1932: IS
1933: SELECT business_group_id
1934: FROM hr_organization_units
1935: WHERE organization_id = p_organization_id;
1936:
1937: CURSOR get_rpt_asg ( p_le NUMBER )
1938: IS

Line 1940: FROM HR_ORGANIZATION_UNITS o1

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

Line 1960: FROM HR_ORGANIZATION_UNITS o1

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

Line 2031: l_business_group_id hr_organization_units.business_group_id%TYPE;

2027: l_person_id NUMBER;
2028: l_count NUMBER;
2029: l_yes_or_no VARCHAR2(10);
2030: UNIQUE_RPT_ASG EXCEPTION ;
2031: l_business_group_id hr_organization_units.business_group_id%TYPE;
2032: l_le hr_organization_units.organization_id%type;
2033:
2034: CURSOR getbgid
2035: IS

Line 2032: l_le hr_organization_units.organization_id%type;

2028: l_count NUMBER;
2029: l_yes_or_no VARCHAR2(10);
2030: UNIQUE_RPT_ASG EXCEPTION ;
2031: l_business_group_id hr_organization_units.business_group_id%TYPE;
2032: l_le hr_organization_units.organization_id%type;
2033:
2034: CURSOR getbgid
2035: IS
2036: SELECT business_group_id

Line 2044: FROM HR_ORGANIZATION_UNITS o1

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

Line 2065: FROM HR_ORGANIZATION_UNITS o1

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

Line 2164: l_internal_external_flag hr_organization_units.INTERNAL_EXTERNAL_FLAG%type;

2160: (P_ORGANIZATION_ID IN NUMBER
2161: ,P_ORG_INFORMATION1 IN VARCHAR2
2162: )IS
2163:
2164: l_internal_external_flag hr_organization_units.INTERNAL_EXTERNAL_FLAG%type;
2165: EXT_COMP_EXCEPTION exception;
2166: PEN_PROV_EXCEPTION exception;
2167: ACC_PROV_EXCEPTION exception;
2168:

Line 2176: FROM HR_ORGANIZATION_UNITS

2172:
2173: CURSOR get_int_or_ext_flag
2174: IS
2175: SELECT INTERNAL_EXTERNAL_FLAG
2176: FROM HR_ORGANIZATION_UNITS
2177: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID;
2178:
2179: BEGIN
2180: --