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.PER_DIF_STMT_REPORT dependencies on HR_GENERAL

Line 284: decode(serv.actual_termination_date, hr_general.end_of_time, null, to_char(serv.actual_termination_date, 'dd-Mon-yy')),

280: to_char(per.original_date_of_hire, 'dd-Mon-yy'),
281: 'emp_hdr_adj_svc_date',
282: null, -- adjusted service date
283: 'emp_hdr_term_date',
284: decode(serv.actual_termination_date, hr_general.end_of_time, null, to_char(serv.actual_termination_date, 'dd-Mon-yy')),
285: 'emp_hdr_coll_aggr',
286: col_agr.name,
287: 'emp_hdr_asg_catg',
288: hr_general.decode_lookup('EMP_CAT', asg.employment_category),

Line 288: hr_general.decode_lookup('EMP_CAT', asg.employment_category),

284: decode(serv.actual_termination_date, hr_general.end_of_time, null, to_char(serv.actual_termination_date, 'dd-Mon-yy')),
285: 'emp_hdr_coll_aggr',
286: col_agr.name,
287: 'emp_hdr_asg_catg',
288: hr_general.decode_lookup('EMP_CAT', asg.employment_category),
289: asg.assignment_id,
290: asg.payroll_id
291: from per_all_people_f per,
292: per_addresses per_addr,

Line 321: decode(ctr.effective_end_date, hr_general.end_of_time, null,to_char(ctr.effective_end_date, 'dd-Mon-yy')) ctr_hdr_end,

317: --
318: -- Cursor for contract details in header
319: Cursor csr_ctr_hdr_details is
320: select to_char(ctr.effective_start_date, 'dd-Mon-yy') ctr_hdr_start,
321: decode(ctr.effective_end_date, hr_general.end_of_time, null,to_char(ctr.effective_end_date, 'dd-Mon-yy')) ctr_hdr_end,
322: hr_general.decode_lookup('CONTRACT_TYPE',ctr.type) ctr_hdr_type,
323: hr_general.decode_lookup('FR_CONTRACT_CATEGORY',ctr_information2) ctr_hdr_category,
324: decode(ctr.ctr_information12, 'HOUR', ctr.ctr_information11, to_char(asg.normal_hours)) ctr_hdr_hours
325: from per_contracts_f ctr,

Line 322: hr_general.decode_lookup('CONTRACT_TYPE',ctr.type) ctr_hdr_type,

318: -- Cursor for contract details in header
319: Cursor csr_ctr_hdr_details is
320: select to_char(ctr.effective_start_date, 'dd-Mon-yy') ctr_hdr_start,
321: decode(ctr.effective_end_date, hr_general.end_of_time, null,to_char(ctr.effective_end_date, 'dd-Mon-yy')) ctr_hdr_end,
322: hr_general.decode_lookup('CONTRACT_TYPE',ctr.type) ctr_hdr_type,
323: hr_general.decode_lookup('FR_CONTRACT_CATEGORY',ctr_information2) ctr_hdr_category,
324: decode(ctr.ctr_information12, 'HOUR', ctr.ctr_information11, to_char(asg.normal_hours)) ctr_hdr_hours
325: from per_contracts_f ctr,
326: per_all_assignments_f asg

Line 323: hr_general.decode_lookup('FR_CONTRACT_CATEGORY',ctr_information2) ctr_hdr_category,

319: Cursor csr_ctr_hdr_details is
320: select to_char(ctr.effective_start_date, 'dd-Mon-yy') ctr_hdr_start,
321: decode(ctr.effective_end_date, hr_general.end_of_time, null,to_char(ctr.effective_end_date, 'dd-Mon-yy')) ctr_hdr_end,
322: hr_general.decode_lookup('CONTRACT_TYPE',ctr.type) ctr_hdr_type,
323: hr_general.decode_lookup('FR_CONTRACT_CATEGORY',ctr_information2) ctr_hdr_category,
324: decode(ctr.ctr_information12, 'HOUR', ctr.ctr_information11, to_char(asg.normal_hours)) ctr_hdr_hours
325: from per_contracts_f ctr,
326: per_all_assignments_f asg
327: where asg.person_id = p_emp_id

Line 344: decode(ent.effective_end_date, hr_general.end_of_time,null, to_char(ent.effective_end_date, 'dd-Mon-yy'))

340: acc.accrual_plan_name ,
341: 'acc_hdr_enrol_start',
342: to_char(ent.effective_start_date, 'dd-Mon-yy') ,
343: 'acc_hdr_enrol_end',
344: decode(ent.effective_end_date, hr_general.end_of_time,null, to_char(ent.effective_end_date, 'dd-Mon-yy'))
345: from pay_accrual_plans acc,
346: pay_element_entries_f ent,
347: per_all_assignments_f asg
348: where acc.accrual_plan_id = p_accrual_plan_id

Line 411: hr_general.decode_lookup('FR_TRAINING_LEAVE_CATEGORY',abs.abs_information1) abs_trg_catg,

407: Cursor csr_dif_abs_details is
408: select to_char(abs.date_start, 'dd-Mon-yy') abs_start,
409: to_char(abs.date_end, 'dd-Mon-yy') abs_end,
410: abs.absence_hours abs_duration,
411: hr_general.decode_lookup('FR_TRAINING_LEAVE_CATEGORY',abs.abs_information1) abs_trg_catg,
412: abs.abs_information2 abs_course,
413: po.vendor_name abs_trg_prov,
414: hr_general.decode_lookup('FR_TRAINING_TYPE',abs.abs_information4) abs_trg_type,
415: abs.abs_information17 abs_reference,

Line 414: hr_general.decode_lookup('FR_TRAINING_TYPE',abs.abs_information4) abs_trg_type,

410: abs.absence_hours abs_duration,
411: hr_general.decode_lookup('FR_TRAINING_LEAVE_CATEGORY',abs.abs_information1) abs_trg_catg,
412: abs.abs_information2 abs_course,
413: po.vendor_name abs_trg_prov,
414: hr_general.decode_lookup('FR_TRAINING_TYPE',abs.abs_information4) abs_trg_type,
415: abs.abs_information17 abs_reference,
416: hr_general.decode_lookup('FR_LEGAL_TRG_CATG',abs.abs_information19) abs_leg_catg,
417: abs.abs_information20 abs_out_wkg_hrs,
418: decode(abs.date_projected_start, null, 'N', 'Y') abs_proj_yn

Line 416: hr_general.decode_lookup('FR_LEGAL_TRG_CATG',abs.abs_information19) abs_leg_catg,

412: abs.abs_information2 abs_course,
413: po.vendor_name abs_trg_prov,
414: hr_general.decode_lookup('FR_TRAINING_TYPE',abs.abs_information4) abs_trg_type,
415: abs.abs_information17 abs_reference,
416: hr_general.decode_lookup('FR_LEGAL_TRG_CATG',abs.abs_information19) abs_leg_catg,
417: abs.abs_information20 abs_out_wkg_hrs,
418: decode(abs.date_projected_start, null, 'N', 'Y') abs_proj_yn
419: from per_absence_attendances abs,
420: per_absence_attendance_types abt,

Line 439: hr_general.decode_lookup('ADD_SUBTRACT',ncr.add_or_subtract) add_or_subtract

435: select ele.element_name adj_element,
436: to_char(pee.effective_start_date, 'dd-Mon-yy') adj_start,
437: to_char(pee.effective_end_date, 'dd-Mon-yy') adj_end,
438: round(fnd_number.canonical_to_number(pev.screen_entry_value)*fnd_number.canonical_to_number(ncr.add_or_subtract), 2) adj_hours,
439: hr_general.decode_lookup('ADD_SUBTRACT',ncr.add_or_subtract) add_or_subtract
440: from pay_accrual_plans pap,
441: pay_net_calculation_rules ncr,
442: pay_element_entries_f pee,
443: pay_element_entry_values_f pev,