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_ORG_STRUCTURE_ELEMENTS

Line 195: per_org_structure_elements pose

191: AND (
192: ((HXC_PREFERENCE_EVALUATION.check_number(substr(hrr.eligibility_criteria_id,instr(hrr.eligibility_criteria_id,'-',1,1)+1)) in
193: (SELECT pose.organization_id_parent
194: FROM
195: per_org_structure_elements pose
196: start with organization_id_child = pa.organization_id
197: and pose.org_structure_version_id=
198: HXC_PREFERENCE_EVALUATION.return_version_id(HXC_PREFERENCE_EVALUATION.check_number(substr(hrr.eligibility_criteria_id,1,instr(hrr.eligibility_criteria_id,'-',1,1)-1)),
199: hrr.eligibility_criteria_type)

Line 1507: per_org_structure_elements pose

1503: AND hrr.eligibility_criteria_type = 'ORGANIZATION')
1504: OR ((HXC_PREFERENCE_EVALUATION.check_number(substr(hrr.eligibility_criteria_id,instr(hrr.eligibility_criteria_id,'-',1,1)+1)) in
1505: (SELECT pose.organization_id_parent
1506: FROM
1507: per_org_structure_elements pose
1508: start with organization_id_child = pa.organization_id
1509: and pose.org_structure_version_id=
1510: HXC_PREFERENCE_EVALUATION.return_version_id(HXC_PREFERENCE_EVALUATION.check_number(substr(hrr.eligibility_criteria_id,1,instr(hrr.eligibility_criteria_id,'-',1,1)-1)),
1511: hrr.eligibility_criteria_type)

Line 1567: per_org_structure_elements pose

1563: AND hrr.eligibility_criteria_type = 'ORGANIZATION')
1564: OR ((HXC_PREFERENCE_EVALUATION.check_number(substr(hrr.eligibility_criteria_id,instr(hrr.eligibility_criteria_id,'-',1,1)+1)) in
1565: (SELECT pose.organization_id_parent
1566: FROM
1567: per_org_structure_elements pose
1568: start with organization_id_child = pa.organization_id
1569: and pose.org_structure_version_id=
1570: HXC_PREFERENCE_EVALUATION.return_version_id(HXC_PREFERENCE_EVALUATION.check_number(substr(hrr.eligibility_criteria_id,1,instr(hrr.eligibility_criteria_id,'-',1,1)-1)),
1571: hrr.eligibility_criteria_type)

Line 3143: per_org_structure_elements pose

3139: AND hrr.eligibility_criteria_type = ''ORGANIZATION'')
3140: OR ((HXC_PREFERENCE_EVALUATION.check_number(substr(hrr.eligibility_criteria_id,instr(hrr.eligibility_criteria_id,''-'',1,1)+1)) in
3141: (SELECT pose.organization_id_parent
3142: FROM
3143: per_org_structure_elements pose
3144: start with organization_id_child = pa.organization_id
3145: and pose.org_structure_version_id=
3146: HXC_PREFERENCE_EVALUATION.return_version_id(HXC_PREFERENCE_EVALUATION.check_number(substr(hrr.eligibility_criteria_id,1,instr(hrr.eligibility_criteria_id,''-'',1,1)-1)),
3147: hrr.eligibility_criteria_type)