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.OTFR2483 dependencies on HR_ORGANIZATION_INFORMATION

Line 451: hr_organization_information comp_2483_info,

447: trunc(least(nvl(comp.date_to,l_year_end),l_year_end),'MM')),
448: greatest(comp.date_from,l_year_start))) comp_active_mths_in_yr
449: from
450: hr_all_organization_units comp,
451: hr_organization_information comp_2483_info,
452: hr_all_organization_units tax_office,
453: hr_locations_all tax_office_loc,
454: hr_all_organization_units_TL comp_tl,
455: hr_locations_all comp_loc,

Line 456: hr_organization_information comp_info,

452: hr_all_organization_units tax_office,
453: hr_locations_all tax_office_loc,
454: hr_all_organization_units_TL comp_tl,
455: hr_locations_all comp_loc,
456: hr_organization_information comp_info,
457: hr_organization_information HQ_info
458: where comp.organization_id = p_company_id
459: and comp.date_from <= l_year_end
460: and (comp.date_to is null or

Line 457: hr_organization_information HQ_info

453: hr_locations_all tax_office_loc,
454: hr_all_organization_units_TL comp_tl,
455: hr_locations_all comp_loc,
456: hr_organization_information comp_info,
457: hr_organization_information HQ_info
458: where comp.organization_id = p_company_id
459: and comp.date_from <= l_year_end
460: and (comp.date_to is null or
461: comp.date_to >= l_year_start)

Line 478: from hr_organization_information tng_cntrib

474: l_header_rec csr_header%ROWTYPE;
475: --
476: cursor csr_comp_training_contrib_info(p_effective_date_chr varchar2) is
477: select org_information3 reduction_chr
478: from hr_organization_information tng_cntrib
479: where tng_cntrib.organization_id = p_company_id
480: and tng_cntrib.org_information_context = 'FR_COMP_TRAINING_CONTRIB'
481: and p_effective_date_chr between tng_cntrib.org_information1
482: and nvl(tng_cntrib.org_information2

Line 670: hr_organization_information org_info_estab,

666: fnd_number.canonical_to_number(org_info_estab.org_information4)
667: ,1 /*I or D*/) mth_count
668: from hr_all_organization_units org_comp,
669: hr_all_organization_units org_estab,
670: hr_organization_information org_info_estab,
671: per_all_assignments_f ass,
672: (select
673: to_number(hlu.lookup_code) num,
674: to_date(''01''||hlu.lookup_code||:p_year,''DDMMYYYY'') start_date,

Line 944: hr_organization_information estab_info,

940: ,to_number(NULL) dif_trn_id
941: ,to_number(NULL) dif_hrs
942: ,to_number(NULL) dif_bal
943: FROM hr_all_organization_units comp,
944: hr_organization_information estab_info,
945: hr_all_organization_units estab,
946: per_all_assignments_f ass,
947: per_jobs job,
948: per_periods_of_service ppos,

Line 995: hr_organization_information estab_info,

991: ,decode(pabs.abs_information1
992: ,''OTHER'',nvl(pabs.absence_hours,0))) dif_hrs
993: ,to_number(NULL) dif_bal
994: FROM hr_all_organization_units comp,
995: hr_organization_information estab_info,
996: hr_all_organization_units estab,
997: per_all_assignments_f ass,
998: per_jobs job,
999: per_all_people_f per,

Line 1079: hr_organization_information tp_org_info,

1075: ,to_number(NULL) dif_hrs
1076: ,to_number(NULL) dif_bal
1077: from
1078: hr_all_organization_units comp,
1079: hr_organization_information tp_org_info,
1080: hr_all_organization_units org,
1081: ota_training_plans TP,
1082: per_time_periods PTP,
1083: ota_training_plan_costs TPC,

Line 1144: hr_organization_information estab_info,

1140: ass.payroll_id,
1141: comp.business_group_id,
1142: :p_comp_end) dif_bal
1143: FROM hr_all_organization_units comp,
1144: hr_organization_information estab_info,
1145: hr_all_organization_units estab,
1146: per_all_assignments_f ass,
1147: per_jobs job,
1148: pay_element_entries_f ent,

Line 1381: hr_organization_information estab_info,

1377: ORDER BY 1,3,4,5 desc';
1378: end if; -- debug or PDF
1379: l_sql := L_SELECT_OUTER||L_SELECT_INNER1||'FROM
1380: hr_all_organization_units comp,
1381: hr_organization_information estab_info,
1382: hr_all_organization_units estab,
1383: per_all_assignments_f ass,
1384: per_all_people_f per,
1385: per_absence_attendances pabs,

Line 1541: hr_organization_information tp_org_info,

1537: ORDER BY 1,3,4,5 desc';
1538: end if; -- debug or PDF
1539: l_sql := L_SELECT_OUTER||L_SELECT_INNER1||'FROM
1540: hr_all_organization_units comp,
1541: hr_organization_information tp_org_info,
1542: hr_all_organization_units org,
1543: ota_training_plans tp,
1544: per_time_periods ptp,
1545: ota_training_plan_costs tp_cost,

Line 1582: hr_organization_information estab_info,

1578: AND hlu_legal.lookup_code(+) = tp_cost_hrs.tp_cost_information3
1579: UNION ALL
1580: '||L_SELECT_INNER2||'FROM
1581: hr_all_organization_units COMP,
1582: hr_organization_information estab_info,
1583: hr_all_organization_units estab,
1584: per_all_assignments_f ass,
1585: per_all_people_f per,
1586: per_absence_attendances pabs,

Line 1589: hr_organization_information bg_info

1585: per_all_people_f per,
1586: per_absence_attendances pabs,
1587: per_absence_attendance_types pabt,
1588: hr_lookups hlu_legal,
1589: hr_organization_information bg_info
1590: WHERE comp.organization_id = :p_company_id
1591: AND comp.date_from <= :p_year_end
1592: AND (comp.date_to IS NULL OR
1593: comp.date_to >= :p_year_start)

Line 1774: hr_organization_information tp_org_info,

1770: --
1771: end if; -- p_detail_section = 'NA'
1772: l_sql := L_SELECT_OUTER||L_SELECT_INNER1||'FROM
1773: hr_all_organization_units comp,
1774: hr_organization_information tp_org_info,
1775: hr_all_organization_units org,
1776: ota_training_plans tp,
1777: per_time_periods ptp,
1778: ota_training_plan_costs tp_cost,

Line 1818: hr_organization_information estab_info,

1814: AND event_tl.language(+) = userenv (''LANG'')
1815: UNION ALL
1816: '||L_SELECT_INNER2||'FROM
1817: hr_all_organization_units COMP,
1818: hr_organization_information estab_info,
1819: hr_all_organization_units estab,
1820: per_all_assignments_f ass,
1821: per_all_people_f per,
1822: per_absence_attendances pabs,

Line 2187: hr_organization_information tp_org_info,

2183: order by 2 NULLS FIRST,3 NULLS FIRST,4 NULLS FIRST,6,7';
2184: end if; -- p_detail_section = 'NA'
2185: l_sql := L_SELECT_OUTER||L_SELECT_INNER1||' from
2186: hr_all_organization_units comp,
2187: hr_organization_information tp_org_info,
2188: hr_all_organization_units org,
2189: ota_training_plans TP,
2190: per_time_periods PTP,
2191: ota_training_plan_costs TPC,

Line 2228: hr_organization_information estab_info,

2224: and :p_comp_end between PER.effective_start_date(+)
2225: AND PER.effective_end_date (+) '||
2226: L_GROUP_INNER1||' UNION ALL '||L_SELECT_INNER2||' from
2227: hr_all_organization_units comp,
2228: hr_organization_information estab_info,
2229: hr_all_organization_units estab,
2230: per_all_assignments_f ass,
2231: per_all_people_f per,
2232: per_absence_attendances pabs,

Line 2234: hr_organization_information bg_info

2230: per_all_assignments_f ass,
2231: per_all_people_f per,
2232: per_absence_attendances pabs,
2233: per_absence_attendance_types pabt,
2234: hr_organization_information bg_info
2235: where comp.organization_id = :p_company_id
2236: and comp.date_from <= :p_year_end
2237: and (comp.date_to is null or
2238: comp.date_to >= :p_year_start)

Line 2540: hr_organization_information tp_org_info,

2536: order by 2 NULLS FIRST,3 NULLS FIRST ,4 NULLS FIRST,6 NULLS FIRST,8';
2537: end if; -- p_detail_section = 'NA'
2538: l_sql := L_SELECT_OUTER||L_SELECT_INNER1||' from
2539: hr_all_organization_units comp,
2540: hr_organization_information tp_org_info,
2541: hr_all_organization_units org,
2542: ota_training_plans TP,
2543: per_time_periods PTP,
2544: ota_training_plan_costs TPC,

Line 2582: hr_organization_information estab_info,

2578: and :p_comp_end between PER.effective_start_date(+)
2579: AND PER.effective_end_date (+) '||
2580: L_GROUP_INNER1||'UNION ALL '||L_SELECT_INNER2||' from
2581: hr_all_organization_units comp,
2582: hr_organization_information estab_info,
2583: hr_all_organization_units estab,
2584: per_all_assignments_f ass,
2585: per_all_people_f per,
2586: per_absence_attendances pabs,

Line 2589: hr_organization_information bg_info

2585: per_all_people_f per,
2586: per_absence_attendances pabs,
2587: per_absence_attendance_types pabt,
2588: po_vendors ota_pv,
2589: hr_organization_information bg_info
2590: where comp.organization_id = :p_company_id
2591: and comp.date_from <= :p_year_end
2592: and (comp.date_to is null or
2593: comp.date_to >= :p_year_start)

Line 2832: hr_organization_information tp_org_info,

2828: order by 1,2,4,5,6,8';
2829: end if; -- p_detail_section = 'NA'
2830: l_sql := L_SELECT_OUTER||L_SELECT_INNER1||' from
2831: hr_all_organization_units comp,
2832: hr_organization_information tp_org_info,
2833: hr_all_organization_units org,
2834: ota_training_plans TP,
2835: per_time_periods PTP,
2836: ota_training_plan_costs TPC_sal,

Line 2889: hr_organization_information estab_info,

2885: and EVT_tl.event_id = EVT.event_id
2886: and EVT_tl.language = userenv(''LANG'')
2887: UNION ALL '||L_SELECT_INNER2||' from
2888: hr_all_organization_units comp,
2889: hr_organization_information estab_info,
2890: hr_all_organization_units estab,
2891: per_all_assignments_f ass,
2892: per_all_people_f per,
2893: per_absence_attendances pabs,

Line 2897: hr_organization_information bg_info

2893: per_absence_attendances pabs,
2894: per_absence_attendance_types pabt,
2895: hr_lookups leavecat,
2896: hr_lookups legalcat,
2897: hr_organization_information bg_info
2898: where comp.organization_id = :p_company_id
2899: and comp.date_from <= :p_end_year
2900: and (comp.date_to is null or
2901: comp.date_to >= :p_start_year)

Line 3122: hr_organization_information tp_org_info,

3118: order by tp.name';
3119: end if; -- p_detail_section = 'NA'
3120: l_sql := L_SELECT_OUTER||' from
3121: hr_all_organization_units comp,
3122: hr_organization_information tp_org_info,
3123: hr_all_organization_units org,
3124: ota_training_plans TP,
3125: per_time_periods PTP,
3126: ota_training_plan_costs TPC