APPS.OTFR2483 dependencies on HR_LOOKUPS

Line 167: leave_cat hr_lookups.meaning%TYPE,

163: trn_end date,
164: class_name ota_events_tl.title%TYPE,
165: plan_name ota_training_plans.name%TYPE,
166: supplier po_vendors.vendor_name%TYPE,
167: leave_cat hr_lookups.meaning%TYPE,
168: legal_cat hr_lookups.meaning%TYPE,
169: act_hrs_chr varchar2(150),
170: out_hrs_chr varchar2(150),
171: chr1 varchar2(150),

Line 168: legal_cat hr_lookups.meaning%TYPE,

164: class_name ota_events_tl.title%TYPE,
165: plan_name ota_training_plans.name%TYPE,
166: supplier po_vendors.vendor_name%TYPE,
167: leave_cat hr_lookups.meaning%TYPE,
168: legal_cat hr_lookups.meaning%TYPE,
169: act_hrs_chr varchar2(150),
170: out_hrs_chr varchar2(150),
171: chr1 varchar2(150),
172: num1 number,

Line 677: from hr_lookups hlu

673: to_number(hlu.lookup_code) num,
674: to_date(''01''||hlu.lookup_code||:p_year,''DDMMYYYY'') start_date,
675: last_day(to_date(''01''||hlu.lookup_code||:p_year,''DDMMYYYY''))
676: end_date
677: from hr_lookups hlu
678: where lookup_type = ''MONTH_OF_YEAR'') month,
679: per_contracts_f ctr,
680: hr_soft_coding_keyflex scl,
681: per_periods_of_service pos,

Line 1551: hr_lookups hlu_legal

1547: ota_delegate_bookings delegate,
1548: per_all_people_f per,
1549: ota_events evt,
1550: ota_events_tl evt_tl,
1551: hr_lookups hlu_legal
1552: WHERE comp.organization_id = :p_company_id
1553: AND comp.date_from <= :p_end_year
1554: AND (comp.date_to IS NULL OR
1555: comp.date_to >= :p_start_year) '

Line 1588: hr_lookups hlu_legal,

1584: per_all_assignments_f ass,
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

Line 2842: hr_lookups HLK_tmt,

2838: ota_tp_measurement_types TMT,
2839: ota_delegate_bookings ODB,
2840: ota_events EVT,
2841: per_all_people_f PER,
2842: hr_lookups HLK_tmt,
2843: hr_lookups HLK_lcat,
2844: ota_events_tl evt_tl
2845: where comp.organization_id = :p_company_id
2846: and comp.date_from <= :p_end_year

Line 2843: hr_lookups HLK_lcat,

2839: ota_delegate_bookings ODB,
2840: ota_events EVT,
2841: per_all_people_f PER,
2842: hr_lookups HLK_tmt,
2843: hr_lookups HLK_lcat,
2844: ota_events_tl evt_tl
2845: where comp.organization_id = :p_company_id
2846: and comp.date_from <= :p_end_year
2847: and (comp.date_to is null or

Line 2895: hr_lookups leavecat,

2891: per_all_assignments_f ass,
2892: per_all_people_f per,
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

Line 2896: hr_lookups legalcat,

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