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_ALL_ORGANIZATION_UNITS

Line 450: hr_all_organization_units comp,

446: least(nvl(comp.date_to,l_year_end),l_year_end),
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,

Line 452: hr_all_organization_units tax_office,

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,
456: hr_organization_information comp_info,

Line 454: hr_all_organization_units_TL comp_tl,

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,
456: hr_organization_information comp_info,
457: hr_organization_information HQ_info
458: where comp.organization_id = p_company_id

Line 668: from hr_all_organization_units org_comp,

664: ,''M''),
665: ''M'') /
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

Line 669: hr_all_organization_units org_estab,

665: ''M'') /
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,

Line 943: FROM hr_all_organization_units comp,

939: ,to_number(NULL) trn_hrs
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,

Line 945: hr_all_organization_units estab,

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,
949: per_all_people_f per

Line 994: FROM hr_all_organization_units comp,

990: ,NULL,TO_NUMBER(NULL)
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,

Line 996: hr_all_organization_units estab,

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,
1000: per_absence_attendances pabs,

Line 1078: hr_all_organization_units comp,

1074: ,to_number(NULL) dif_trn_id
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,

Line 1080: hr_all_organization_units org,

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,
1084: ota_tp_measurement_types TMT,

Line 1143: FROM hr_all_organization_units comp,

1139: acc.accrual_plan_id,
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,

Line 1145: hr_all_organization_units estab,

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,
1149: pay_accrual_plans acc,

Line 1380: hr_all_organization_units comp,

1376: L_ORDER_BY := '
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,

Line 1382: hr_all_organization_units estab,

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,
1386: per_absence_attendance_types pabt

Line 1540: hr_all_organization_units comp,

1536: L_ORDER_BY := '
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,

Line 1542: hr_all_organization_units org,

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,
1546: ota_training_plan_costs tp_cost_hrs,

Line 1581: hr_all_organization_units COMP,

1577: AND hlu_legal.lookup_type(+) = ''FR_LEGAL_TRG_CATG''
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,

Line 1583: hr_all_organization_units estab,

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,
1587: per_absence_attendance_types pabt,

Line 1773: hr_all_organization_units comp,

1769: ORDER BY 1, 3, 4, 5 DESC, 6, 7';
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,

Line 1775: hr_all_organization_units org,

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,
1779: ota_tp_measurement_types meas_type,

Line 1817: hr_all_organization_units COMP,

1813: AND event_tl.event_id(+) = event.event_id
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,

Line 1819: hr_all_organization_units estab,

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,
1823: per_absence_attendance_types pabt

Line 2186: hr_all_organization_units comp,

2182: L_ORDER_BY := '
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,

Line 2188: hr_all_organization_units org,

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,
2192: ota_tp_measurement_types TMT,

Line 2227: hr_all_organization_units comp,

2223: and ODB.delegate_person_id = PER.person_id(+)
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,

Line 2229: hr_all_organization_units estab,

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,
2233: per_absence_attendance_types pabt,

Line 2539: hr_all_organization_units comp,

2535: L_ORDER_BY := '
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,

Line 2541: hr_all_organization_units org,

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,
2545: ota_tp_measurement_types TMT,

Line 2581: hr_all_organization_units comp,

2577: and ODB.delegate_person_id = PER.person_id(+)
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,

Line 2583: hr_all_organization_units estab,

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,
2587: per_absence_attendance_types pabt,

Line 2831: hr_all_organization_units comp,

2827: L_ORDER_BY := '
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,

Line 2833: hr_all_organization_units org,

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,
2837: ota_training_plan_costs TPC_hrs,

Line 2888: hr_all_organization_units comp,

2884: and hlk_lcat.lookup_code(+) = TPC_hrs.tp_cost_information3
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,

Line 2890: hr_all_organization_units estab,

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,
2894: per_absence_attendance_types pabt,

Line 3121: hr_all_organization_units comp,

3117: L_ORDER_BY := '
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,

Line 3123: hr_all_organization_units org,

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
3127: where comp.organization_id = :p_company_id