[Home] [Help]
APPS.PQP_GB_OSP_FUNCTIONS dependencies on HR_PATTERN_PURPOSE_USAGES
Line 862: ,hr_pattern_purpose_usages ppu
858: ) IS
859: SELECT cu.purpose_usage_id
860: ,cu.primary_key_value
861: FROM hr_calendar_usages cu
862: ,hr_pattern_purpose_usages ppu
863: WHERE ppu.pattern_purpose = 'QUALIFYING PATTERN'
864: AND ppu.entity_name = p_entity_name
865: AND cu.purpose_usage_id = ppu.purpose_usage_id
866: AND cu.primary_key_value = p_primary_key_value