APPS.PQP_GB_OSP_FUNCTIONS dependencies on HR_CALENDAR_USAGES

Line 515: -- ,hr_calendar_usages hcu

511: -- ,exception_name
512: -- ,exception_start_time exception_start_date
513: -- ,exception_end_time exception_end_date
514: --FROM hr_calendars hc
515: -- ,hr_calendar_usages hcu
516: -- ,hr_exception_usages heu
517: -- ,hr_pattern_exceptions hpe
518: --WHERE hc.pattern_id = p_pattern_id
519: --AND hc.calendar_id = hcu.calendar_id

Line 534: -- ,hr_calendar_usages hcu

530: -- ,exception_name
531: -- ,exception_start_time exception_start_date
532: -- ,exception_end_time exception_end_date
533: --FROM hr_calendars hc
534: -- ,hr_calendar_usages hcu
535: -- ,hr_exception_usages heu
536: -- ,hr_pattern_exceptions hpe
537: --WHERE hc.pattern_id = p_pattern_id
538: --AND purpose_usage_id = 1

Line 589: -- FROM hr_calendar_usages hcu, hr_calendars hc

585: -- ) IS
586: -- SELECT pattern_id
587: -- ,start_date
588: -- ,end_date
589: -- FROM hr_calendar_usages hcu, hr_calendars hc
590: -- WHERE primary_key_value = p_person_id
591: -- AND purpose_usage_id = 2
592: -- AND hcu.calendar_id = hc.calendar_id;
593: --

Line 861: FROM hr_calendar_usages cu

857: ,p_effective_date IN DATE
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