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.HR_PERSON_TYPE_USAGE_INFO dependencies on PAY_RESTRICTION_VALUES

Line 813: from pay_restriction_values prv

809: and ((p_customized_restriction_id is null)
810: or (p_customized_restriction_id is not null
811: and (exists
812: (select null
813: from pay_restriction_values prv
814: where prv.customized_restriction_id = p_customized_restriction_id
815: and prv.restriction_code = 'PERSON_ACTION'
816: and prv.value = pff.result)
817: or not exists

Line 819: from pay_restriction_values prv2

815: and prv.restriction_code = 'PERSON_ACTION'
816: and prv.value = pff.result)
817: or not exists
818: (select null
819: from pay_restriction_values prv2
820: where prv2.customized_restriction_id = p_customized_restriction_id
821: and prv2.restriction_code = 'PERSON_ACTION'))))
822: order by 2;
823: