DBA Data[Home] [Help]

APPS.HR_INDEX_CHECK dependencies on HR_GENERAL

Line 127: IF hr_general.chk_application_id(c1.application_id) = 'TRUE' THEN

123: END LOOP;
124: ELSIF p_prod = 'ALL' THEN
125: -- Find all products
126: FOR c1 in csr_find_applications LOOP
127: IF hr_general.chk_application_id(c1.application_id) = 'TRUE' THEN
128: IF c1.application_short_name = 'PER' THEN
129: FOR c1 IN csr_find_per_indexes(l_per_owner) LOOP
130: p_list(l_list).index_name := c1.index_name;
131: p_list(l_list).table_name := c1.table_name;

Line 601: IF hr_general.chk_application_id(c1.application_id) = 'TRUE' THEN

597: END LOOP;
598: ELSIF p_prod = 'ALL' THEN
599: -- Find all products
600: FOR c1 in csr_find_applications LOOP
601: IF hr_general.chk_application_id(c1.application_id) = 'TRUE' THEN
602: IF c1.application_short_name = 'PER' THEN
603: FOR c1 IN csr_find_per_indexes(l_per_owner) LOOP
604: p_list(l_list).index_name := c1.index_name;
605: p_list(l_list).table_name := c1.table_name;