DBA Data[Home] [Help]

APPS.HRSUMREP dependencies on HR_SUMMARY_KEY_TYPE_USAGE

Line 75: from hr_summary_key_type_usage ktu

71: cursor c_get_key_type_usage(p_item_type_usage_id number) is
72: select kty.name
73: , kty.key_function
74: , kty.key_type_id
75: from hr_summary_key_type_usage ktu
76: , hr_summary_valid_key_type vkt
77: , hr_summary_key_type kty
78: where kty.key_type_id = vkt.key_type_id
79: and ktu.valid_key_type_id = vkt.valid_key_type_id

Line 540: from hr_summary_key_type_usage ktu

536: cursor c_get_key_type_usage(p_item_type_usage_id number) is
537: select kty.name
538: , kty.key_function
539: , kty.key_type_id
540: from hr_summary_key_type_usage ktu
541: , hr_summary_valid_key_type vkt
542: , hr_summary_key_type kty
543: where kty.key_type_id = vkt.key_type_id
544: and ktu.valid_key_type_id = vkt.valid_key_type_id