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 PER_CONTRACTS_F

Line 325: from per_contracts_f ctr,

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
328: and asg.effective_start_date <= p_date_to
329: and asg.effective_end_date >= p_date_from

Line 332: from per_contracts_f

328: and asg.effective_start_date <= p_date_to
329: and asg.effective_end_date >= p_date_from
330: and asg.contract_id(+) = ctr.contract_id
331: and ctr.effective_end_date =(select greatest(effective_end_date)
332: from per_contracts_f
333: where contract_id= ctr.contract_id
334: and effective_end_date >= p_date_from)
335: and ctr_information_category(+) = 'FR';
336: --

Line 397: per_contracts_f ctr

393: substr(hruserdt.get_table_value(p_business_group_id, 'FR_CIPDZ', 'CIPDZ',nvl(asg.employment_category,'FR'),p_date_from),1,1) asg_catg,
394: asg.payroll_id payroll_id,
395: decode(ctr.ctr_information12, 'HOUR', fnd_number.canonical_to_number(ctr.ctr_information11), asg.normal_hours) wkg_hours
396: from per_all_assignments_f asg,
397: per_contracts_f ctr
398: where asg.person_id= p_emp_id
399: and asg.effective_end_date >= p_date_from
400: and asg.effective_start_date <= p_date_to
401: and asg.contract_id = ctr.contract_id