DBA Data[Home] [Help]

APPS.HR_PERSON_TYPE_USAGE_INFO dependencies on PAY_RESTRICTION_VALUES

Line 744: from pay_restriction_values prv

740: and ((p_customized_restriction_id is null)
741: or (p_customized_restriction_id is not null
742: and (exists
743: (select null
744: from pay_restriction_values prv
745: where prv.customized_restriction_id = p_customized_restriction_id
746: and prv.restriction_code = 'PERSON_ACTION'
747: and prv.value = pff.result)
748: or not exists

Line 750: from pay_restriction_values prv2

746: and prv.restriction_code = 'PERSON_ACTION'
747: and prv.value = pff.result)
748: or not exists
749: (select null
750: from pay_restriction_values prv2
751: where prv2.customized_restriction_id = p_customized_restriction_id
752: and prv2.restriction_code = 'PERSON_ACTION'))))
753: order by 2;
754: