DBA Data[Home] [Help]

APPS.HR_EXU_BUS dependencies on HR_PATTERN_PURPOSES

Line 103: hr_pattern_purposes hpp

99: select '1'
100: from hr_calendar_usages hcu,
101: hr_calendars hc,
102: hr_patterns hp,
103: hr_pattern_purposes hpp
104: where hcu.calendar_usage_id = p_calendar_usage_id
105: and hcu.calendar_id = hc.calendar_id
106: and hc.pattern_id = hp.pattern_id
107: and hp.pattern_id = hpp.pattern_id