APPS.HR_EXU_BUS dependencies on HR_PATTERN_CONSTRUCTIONS

Line 141: from hr_pattern_constructions hpc1,

137: l_proc varchar2(72) := g_package||'Excep_is_Qual_Non_Qual';
138:
139: cursor c2 is
140: select '1'
141: from hr_pattern_constructions hpc1,
142: hr_pattern_exceptions hpe1
143: where hpc1.pattern_id = hpe1.pattern_id
144: and hpe1.exception_id = p_exception_id
145: and not ( hpc1.availability = 'QUALIFYING'

Line 149: from hr_pattern_constructions hpc2,

145: and not ( hpc1.availability = 'QUALIFYING'
146: or hpc1.availability = 'NON QUALIFYING')
147: UNION ALL
148: select '1'
149: from hr_pattern_constructions hpc2,
150: hr_pattern_constructions hpc3,
151: hr_pattern_exceptions hpe2
152: where hpc2.component_pattern_id = hpc3.pattern_id
153: and hpc2.pattern_id = hpe2.pattern_id

Line 150: hr_pattern_constructions hpc3,

146: or hpc1.availability = 'NON QUALIFYING')
147: UNION ALL
148: select '1'
149: from hr_pattern_constructions hpc2,
150: hr_pattern_constructions hpc3,
151: hr_pattern_exceptions hpe2
152: where hpc2.component_pattern_id = hpc3.pattern_id
153: and hpc2.pattern_id = hpe2.pattern_id
154: and hpe2.exception_id = p_exception_id