DBA Data[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