DBA Data[Home] [Help]

APPS.HRSUMREP dependencies on HR_SUMMARY_RESTRICTION_TYPE

Line 90: , hr_summary_restriction_type srt

86: , vru.restriction_usage_id
87: , srt.name
88: from hr_summary_valid_restriction vrt
89: , hr_summary_restriction_usage vru
90: , hr_summary_restriction_type srt
91: where vrt.valid_restriction_id = vru.valid_restriction_id
92: and vru.item_type_usage_id = p_item_type_usage_id
93: and vrt.restriction_type_id = srt.restriction_type_id
94: and srt.name <> 'USER_PERSON_TYPE';

Line 555: , hr_summary_restriction_type srt

551: , vru.restriction_usage_id
552: , srt.name
553: from hr_summary_valid_restriction vrt
554: , hr_summary_restriction_usage vru
555: , hr_summary_restriction_type srt
556: where vrt.valid_restriction_id = vru.valid_restriction_id
557: and vru.item_type_usage_id = p_item_type_usage_id
558: and vrt.restriction_type_id = srt.restriction_type_id
559: and srt.name <> 'USER_PERSON_TYPE';