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.HXC_PREFERENCE_EVALUATION dependencies on PER_PERSON_TYPES

Line 303: per_person_types typ,

299: /*Cursor Modified By Mithun for CWK Terminate Bug*/
300: CURSOR c_person_type_hierarchies(p_resource_id IN NUMBER,p_evaluation_date IN DATE) IS
301: SELECT hrr.pref_hierarchy_id , hrr.rule_evaluation_order
302: FROM hxc_resource_rules hrr,
303: per_person_types typ,
304: per_person_type_usages_f ptu
305: WHERE hrr.resource_type='PERSON'
306: AND p_evaluation_date between hrr.start_date and hrr.end_date
307: AND hrr.eligibility_criteria_type = 'PERSON_TYPE'

Line 1708: per_person_types typ,

1704: SELECT hrr.pref_hierarchy_id , hrr.rule_evaluation_order, hrr.start_date, hrr.end_date,
1705: ptu.effective_start_date elig_start_date,
1706: ptu.effective_end_date elig_end_date
1707: FROM hxc_resource_rules hrr,
1708: per_person_types typ,
1709: per_person_type_usages_f ptu
1710: WHERE hrr.resource_type='PERSON'
1711: and p_start_evaluation_date <= hrr.end_date
1712: and hrr.start_date <= p_end_evaluation_date

Line 3159: FROM per_person_types typ

3155: where organization_id = pa.organization_id))
3156: AND hrr.eligibility_criteria_type = ''ROLLUP'' )
3157: OR ( HXC_PREFERENCE_EVALUATION.check_number(hrr.eligibility_criteria_id)
3158: in ( SELECT typ.person_type_id
3159: FROM per_person_types typ
3160: ,per_person_type_usages_f ptu
3161: WHERE typ.system_person_type IN (''EMP'',''EX_EMP'',''EMP_APL'',''EX_EMP_APL'',''CWK'',''EX_CWK'')
3162: AND typ.person_type_id = ptu.person_type_id
3163: AND :evaluation_date BETWEEN ptu.effective_start_date AND ptu.effective_end_date