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 PER_ALL_PEOPLE_F

Line 159: (full_name per_all_people_f.full_name%TYPE,

155: l_ref_csr t_ref_cursor;
156: --
157: /* Bulk fetches from dynamic cursors not supported in 8.1.7; use a record: */
158: TYPE t_rec is RECORD
159: (full_name per_all_people_f.full_name%TYPE,
160: order_name per_all_people_f.order_name%TYPE,
161: emp_num per_all_people_f.employee_number%TYPE,
162: trn_start date,
163: trn_end date,

Line 160: order_name per_all_people_f.order_name%TYPE,

156: --
157: /* Bulk fetches from dynamic cursors not supported in 8.1.7; use a record: */
158: TYPE t_rec is RECORD
159: (full_name per_all_people_f.full_name%TYPE,
160: order_name per_all_people_f.order_name%TYPE,
161: emp_num per_all_people_f.employee_number%TYPE,
162: trn_start date,
163: trn_end date,
164: class_name ota_events_tl.title%TYPE,

Line 161: emp_num per_all_people_f.employee_number%TYPE,

157: /* Bulk fetches from dynamic cursors not supported in 8.1.7; use a record: */
158: TYPE t_rec is RECORD
159: (full_name per_all_people_f.full_name%TYPE,
160: order_name per_all_people_f.order_name%TYPE,
161: emp_num per_all_people_f.employee_number%TYPE,
162: trn_start date,
163: trn_end date,
164: class_name ota_events_tl.title%TYPE,
165: plan_name ota_training_plans.name%TYPE,

Line 682: per_all_people_f per

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,
682: per_all_people_f per
683: where org_comp.organization_id = :p_company_id
684: and org_comp.date_from <= :p_year_end
685: and (org_comp.date_to is null or
686: org_comp.date_to >= :p_year_start)

Line 949: per_all_people_f per

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
950: WHERE comp.organization_id = :p_company_id
951: AND comp.date_from <= :p_year_end
952: AND (comp.date_to IS NULL OR
953: comp.date_to >= :p_year_start)

Line 999: per_all_people_f per,

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,
1001: per_absence_attendance_types pabt,
1002: per_contracts_f con,
1003: pay_input_values_f piv,

Line 1086: per_all_people_f PER,

1082: per_time_periods PTP,
1083: ota_training_plan_costs TPC,
1084: ota_tp_measurement_types TMT,
1085: ota_delegate_bookings ODB,
1086: per_all_people_f PER,
1087: ota_events EVT,
1088: per_all_assignments_f ass,
1089: per_jobs job,
1090: per_contracts_f con

Line 1152: per_all_people_f per

1148: pay_element_entries_f ent,
1149: pay_accrual_plans acc,
1150: pay_input_values_f piv,
1151: pay_sub_classification_rules_f sub_class,
1152: per_all_people_f per
1153: WHERE comp.organization_id = :p_company_id
1154: AND comp.date_from <= :p_year_end
1155: AND (comp.date_to IS NULL OR
1156: comp.date_to >= :p_year_start)

Line 1384: per_all_people_f per,

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
1387: WHERE comp.organization_id = :p_company_id
1388: AND comp.date_from <= :p_year_end

Line 1548: per_all_people_f per,

1544: per_time_periods ptp,
1545: ota_training_plan_costs tp_cost,
1546: ota_training_plan_costs tp_cost_hrs,
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

Line 1585: per_all_people_f per,

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,
1588: hr_lookups hlu_legal,
1589: hr_organization_information bg_info

Line 1783: per_all_people_f per

1779: ota_tp_measurement_types meas_type,
1780: ota_delegate_bookings delegate,
1781: ota_events event,
1782: ota_events_tl event_tl,
1783: per_all_people_f per
1784: WHERE comp.organization_id = :p_company_id
1785: AND comp.date_from <= :p_end_year
1786: AND (comp.date_to IS NULL OR
1787: comp.date_to >= :p_start_year) '

Line 1821: per_all_people_f per,

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
1824: WHERE comp.organization_id = :p_company_id
1825: AND comp.date_from <= :p_year_end

Line 2194: per_all_people_f PER

2190: per_time_periods PTP,
2191: ota_training_plan_costs TPC,
2192: ota_tp_measurement_types TMT,
2193: ota_delegate_bookings ODB,
2194: per_all_people_f PER
2195: where comp.organization_id = :p_company_id
2196: and comp.date_from <= :p_year_end
2197: and (comp.date_to is null or
2198: comp.date_to >= :p_year_start) '

Line 2231: per_all_people_f per,

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,
2234: hr_organization_information bg_info
2235: where comp.organization_id = :p_company_id

Line 2547: per_all_people_f PER

2543: per_time_periods PTP,
2544: ota_training_plan_costs TPC,
2545: ota_tp_measurement_types TMT,
2546: ota_delegate_bookings ODB,
2547: per_all_people_f PER
2548: where comp.organization_id = :p_company_id
2549: and comp.date_from <= :p_year_end
2550: and (comp.date_to is null or
2551: comp.date_to >= :p_year_start) '

Line 2585: per_all_people_f per,

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,
2588: po_vendors ota_pv,
2589: hr_organization_information bg_info

Line 2841: per_all_people_f PER,

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

Line 2892: per_all_people_f per,

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,
2895: hr_lookups leavecat,
2896: hr_lookups legalcat,