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.

[Home] [Help]

APPS.HR_FI_VALIDATE_PKG dependencies on HR_ORGANIZATION_UNITS

Line 304: l_business_group_id hr_organization_units.business_group_id%TYPE;

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

Line 336: FROM hr_organization_units

332:
333: CURSOR getbgid
334: IS
335: SELECT business_group_id
336: FROM hr_organization_units
337: WHERE organization_id = p_organization_id;
338:
339: CURSOR orglocalunit
340: IS

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

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

Line 1151: FROM hr_organization_units

1147:
1148: CURSOR getbgid
1149: IS
1150: SELECT business_group_id
1151: FROM hr_organization_units
1152: where organization_id = l_organization_id;
1153:
1154: CURSOR getorgid
1155: 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 1948: l_business_group_id hr_organization_units.business_group_id%TYPE;

1944: l_yes_or_no VARCHAR2(10);
1945: l_count NUMBER ;
1946:
1947: UNIQUE_RPT_ASG EXCEPTION ;
1948: l_business_group_id hr_organization_units.business_group_id%TYPE;
1949: l_le hr_organization_units.organization_id%type;
1950:
1951: CURSOR getbgid
1952: IS

Line 1949: l_le hr_organization_units.organization_id%type;

1945: l_count NUMBER ;
1946:
1947: UNIQUE_RPT_ASG EXCEPTION ;
1948: l_business_group_id hr_organization_units.business_group_id%TYPE;
1949: l_le hr_organization_units.organization_id%type;
1950:
1951: CURSOR getbgid
1952: IS
1953: SELECT business_group_id

Line 1954: FROM hr_organization_units

1950:
1951: CURSOR getbgid
1952: IS
1953: SELECT business_group_id
1954: FROM hr_organization_units
1955: WHERE organization_id = p_organization_id;
1956:
1957: CURSOR get_rpt_asg ( p_le NUMBER )
1958: IS

Line 1960: FROM HR_ORGANIZATION_UNITS o1

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

Line 1980: FROM HR_ORGANIZATION_UNITS o1

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

Line 2051: l_business_group_id hr_organization_units.business_group_id%TYPE;

2047: l_person_id NUMBER;
2048: l_count NUMBER;
2049: l_yes_or_no VARCHAR2(10);
2050: UNIQUE_RPT_ASG EXCEPTION ;
2051: l_business_group_id hr_organization_units.business_group_id%TYPE;
2052: l_le hr_organization_units.organization_id%type;
2053:
2054: CURSOR getbgid
2055: IS

Line 2052: l_le hr_organization_units.organization_id%type;

2048: l_count NUMBER;
2049: l_yes_or_no VARCHAR2(10);
2050: UNIQUE_RPT_ASG EXCEPTION ;
2051: l_business_group_id hr_organization_units.business_group_id%TYPE;
2052: l_le hr_organization_units.organization_id%type;
2053:
2054: CURSOR getbgid
2055: IS
2056: SELECT business_group_id

Line 2064: FROM HR_ORGANIZATION_UNITS o1

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

Line 2085: FROM HR_ORGANIZATION_UNITS o1

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

Line 2184: l_internal_external_flag hr_organization_units.INTERNAL_EXTERNAL_FLAG%type;

2180: (P_ORGANIZATION_ID IN NUMBER
2181: ,P_ORG_INFORMATION1 IN VARCHAR2
2182: )IS
2183:
2184: l_internal_external_flag hr_organization_units.INTERNAL_EXTERNAL_FLAG%type;
2185: EXT_COMP_EXCEPTION exception;
2186: PEN_PROV_EXCEPTION exception;
2187: ACC_PROV_EXCEPTION exception;
2188:

Line 2196: FROM HR_ORGANIZATION_UNITS

2192:
2193: CURSOR get_int_or_ext_flag
2194: IS
2195: SELECT INTERNAL_EXTERNAL_FLAG
2196: FROM HR_ORGANIZATION_UNITS
2197: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID;
2198:
2199: BEGIN
2200: --