APPS.HR_PO_INFO dependencies on ALL_TAB_COLUMNS

Line 126: FROM all_tab_columns dd

122: -- Check if the PO columns are on the HR assignments tables.
123: --
124: SELECT count(dd.column_name)
125: INTO l_count
126: FROM all_tab_columns dd
127: WHERE dd.table_name = 'PER_ALL_ASSIGNMENTS_F'
128: AND (dd.column_name = 'VENDOR_ID' OR
129: dd.column_name = 'VENDOR_SITE_ID' OR
130: dd.column_name = 'PO_HEADER_ID' OR

Line 142: FROM all_tab_columns dd

138: -- Check if VENDOR_ID column exist in the HR assignments table
139: --
140: SELECT count(dd.column_name)
141: INTO l_count
142: FROM all_tab_columns dd
143: WHERE dd.table_name = 'PER_ALL_ASSIGNMENTS_F'
144: AND dd.column_name = 'VENDOR_ID'
145: AND rownum < 2
146: AND dd.owner = l_per_owner; -- 3512537