APPS.HRSUMREP dependencies on HR_SUMMARY_KEY_TYPE

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 77: , hr_summary_key_type kty

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
80: and ktu.item_type_usage_id = p_item_type_usage_id;
81: --

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

Line 542: , hr_summary_key_type kty

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
545: and ktu.item_type_usage_id = p_item_type_usage_id;
546: --