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.OTA_FR_TRG_SUM dependencies on PER_ALL_PEOPLE_F

Line 110: person_id per_all_people_f.person_id%TYPE,

106: c_ref_cur ref_cur;
107:
108: TYPE rec IS RECORD
109: (
110: person_id per_all_people_f.person_id%TYPE,
111: employee_number per_all_people_f.employee_number%TYPE,
112: full_name per_all_people_f.full_name%TYPE
113: );
114:

Line 111: employee_number per_all_people_f.employee_number%TYPE,

107:
108: TYPE rec IS RECORD
109: (
110: person_id per_all_people_f.person_id%TYPE,
111: employee_number per_all_people_f.employee_number%TYPE,
112: full_name per_all_people_f.full_name%TYPE
113: );
114:
115:

Line 112: full_name per_all_people_f.full_name%TYPE

108: TYPE rec IS RECORD
109: (
110: person_id per_all_people_f.person_id%TYPE,
111: employee_number per_all_people_f.employee_number%TYPE,
112: full_name per_all_people_f.full_name%TYPE
113: );
114:
115:
116: cursor c_asg_amendments is

Line 158: per_all_people_f pef,

154: open c_ref_cur for -- ASG 1
155: 'select distinct paf.person_id person_id ,pef.employee_number employee_number,pef.full_name full_name
156: from per_all_assignments_f paf,
157: hr_assignment_sets hs,
158: per_all_people_f pef,
159: per_periods_of_service ppos
160: where hs.assignment_set_id=:p_assignment_set_id
161: and nvl(hs.payroll_id,paf.payroll_id)=paf.payroll_id
162: and hs.business_group_id=paf.business_group_id

Line 196: per_all_people_f pef,

192: open c_ref_cur for
193: 'select distinct paf.person_id person_id ,pef.employee_number employee_number,pef.full_name full_name
194: from per_all_assignments_f paf,
195: hr_assignment_sets hs,
196: per_all_people_f pef,
197: per_periods_of_service ppos
198: where hs.assignment_set_id=:p_assignment_set_id
199: and hs.business_group_id=paf.business_group_id
200: and nvl(hs.payroll_id,paf.payroll_id)=paf.payroll_id

Line 233: per_all_people_f pef,

229: open c_ref_cur for
230: 'select distinct paf.person_id ,pef.employee_number employee_number,pef.full_name full_name
231: from per_all_assignments_f paf,
232: hr_assignment_sets hs,
233: per_all_people_f pef,
234: per_periods_of_service ppos
235: where hs.assignment_set_id=:p_assignment_set_id
236: and hs.business_group_id=paf.business_group_id
237: and nvl(hs.payroll_id,paf.payroll_id)=paf.payroll_id

Line 270: from per_all_people_f pap,

266: else
267:
268: open c_ref_cur for
269: 'Select DISTINCT pap.person_id person_id,pap.employee_number employee_number,pap.full_name full_name
270: from per_all_people_f pap,
271: per_all_assignments_f paa,
272: hr_all_organization_units hao,
273: hr_organization_information hoi,
274: per_periods_of_service ppos

Line 358: from per_all_people_f papf,

354: hla2.address_line_1||' '||hla2.address_line_2||' '||hla2.address_line_3||' '||
355: hla2.region_2||' '||hla2.region_3||' '||hla2.postal_code||' '||hla2.town_or_city||' '||
356: hla2.region_1||' '||hla2.country||' '||hla2.telephone_number_1||' '||hla2.telephone_number_2||' '||
357: hla2.telephone_number_3 COM_ADDRESS
358: from per_all_people_f papf,
359: per_addresses pa,
360: per_all_assignments_f paaf,
361: per_periods_of_service ppos,
362: per_contracts_f pcf,

Line 423: from per_all_people_f papf,

419: end) C_W_L_CAT,--Legal category
420: fnd_number.canonical_to_number(otpc.tp_cost_information4) C_W_O_HR , --Hours Outside working
421: decode(otmt.tp_measurement_code,'FR_ACTUAL_HOURS',nvl(otpc.amount,0),
422: nvl(fnd_number.canonical_to_number(otpc.tp_cost_information3),0))C_W_TOT_HR --Total Hours
423: from per_all_people_f papf,
424: ota_delegate_bookings odb,
425: ota_booking_status_types obst,
426: ota_events oevent,
427: ota_events_tl oeventl,

Line 454: from per_all_people_f papf,

450: sum(fnd_number.canonical_to_number(nvl(otpc.tp_cost_information4,0))) W_TOT_OUT_WK_HR,
451: decode(otmt.tp_measurement_code,'FR_ACTUAL_HOURS',
452: otpc.tp_cost_information3,
453: ' ') LEGAL_CATG --i)JOB_ADAPT ii) JOB_EVOL , iii)COMP_DEV
454: from per_all_people_f papf,
455: ota_delegate_bookings odb,
456: ota_training_plan_costs otpc,
457: ota_tp_measurement_types otmt,
458: ota_events oevent

Line 497: from per_all_people_f papf,

493: end C_O_L_CAT, ---Legal Category
494: fnd_number.canonical_to_number(nvl(paa.ABS_INFORMATION20,0)) C_O_O_HR, --Hours Outside Working Hours
495: OTA_FR_TRG_SUM.get_lookup_value('FR_TRAINING_SUBSIDY_TYPE',paa.ABS_INFORMATION5) SUBSI_TYPE, --Subsidized Type
496: hfov.name SUBSI_ORG --Subsidizing Organization
497: from per_all_people_f papf,
498: per_absence_attendances paa,
499: per_absence_attendance_types paat,
500: po_vendors pv,
501: HR_FR_OPCA_V hfov

Line 522: from per_all_people_f papf,

518: cursor c_emp_o_trg_tot is
519: Select sum(fnd_number.canonical_to_number(nvl(paa.ABSENCE_HOURS,0))) O_TOT_HOURS ,
520: sum(fnd_number.canonical_to_number(nvl(paa.ABS_INFORMATION20,0))) O_TOT_OUT_WK_HR,
521: (paa.ABS_INFORMATION19) LEGAL_CATG --i)JOB_ADAPT ii) JOB_EVOL , iii)COMP_DEV
522: from per_all_people_f papf,
523: per_absence_attendances paa
524: where papf.person_id=l_p_person_id
525: and papf.person_id=paa.person_id
526: and papf.business_group_id=paa.business_group_id