APPS.HR_CAU_BUS dependencies on HR_PATTERN_PURPOSE_USAGES

Line 199: from hr_pattern_purpose_usages

195: --
196: -- Get the purpose of the calendar pattern
197: --
198: select pattern_purpose
199: from hr_pattern_purpose_usages
200: where purpose_usage_id = p_purpose_usage_id;
201: --
202: procedure check_parameters is
203: --

Line 268: from hr_pattern_purpose_usages PPU1,

264: -- Get the next level up the hierarchy of defaulting
265: --
266: select cau.purpose_usage_id,
267: cau.primary_key_value
268: from hr_pattern_purpose_usages PPU1,
269: hr_calendar_usages CAU
270: where ppu1.pattern_purpose = (
271: select ppu2.pattern_purpose
272: from hr_pattern_purpose_usages PPU2

Line 272: from hr_pattern_purpose_usages PPU2

268: from hr_pattern_purpose_usages PPU1,
269: hr_calendar_usages CAU
270: where ppu1.pattern_purpose = (
271: select ppu2.pattern_purpose
272: from hr_pattern_purpose_usages PPU2
273: where ppu2.purpose_usage_id = p_purpose_usage_id
274: and ppu1.hierarchy_level < ppu2.hierarchy_level)
275: and cau.purpose_usage_id = ppu1.purpose_usage_id
276: and p_start_date between cau.start_date and cau.end_date

Line 425: from hr_pattern_purpose_usages

421: --
422: -- Get the entity name for the pattern purpose usage
423: --
424: select entity_name
425: from hr_pattern_purpose_usages
426: where purpose_usage_id = p_purpose_usage_id;
427: --
428: l_dummy integer (1) := null;
429: l_entity_name varchar2 (30);