APPS.BEN_TCS_STMT_VALID_HRCHY dependencies on BEN_TCS_COL_IN_CAT

Line 43: FROM ben_tcs_all_objects_in_cat stmt_all_obj, ben_tcs_col_in_cat col_cat

39: CURSOR c_cat_item (v_cat_id IN NUMBER)
40: IS
41: SELECT stmt_all_obj.item_id, col_cat.contributor_type_cd cntr_cd ,stmt_all_obj.all_objects_in_cat_id obj_id,
42: stmt_all_obj.row_in_cat_id row_id
43: FROM ben_tcs_all_objects_in_cat stmt_all_obj, ben_tcs_col_in_cat col_cat
44: WHERE stmt_all_obj.cat_id = v_cat_id AND item_id IS NOT NULL
45: AND col_cat.col_in_cat_id = stmt_all_obj.col_in_cat_id;
46:
47: CURSOR c_cat_parent (v_cat_id IN NUMBER)