APPS.BEN_TCS_STMT_VALID_HRCHY dependencies on BEN_TCS_ALL_OBJECTS_IN_CAT

Line 36: FROM ben_tcs_all_objects_in_cat stmt_all_obj

32:
33: CURSOR c_cat_subcat (v_cat_id IN NUMBER)
34: IS
35: SELECT subcat_id
36: FROM ben_tcs_all_objects_in_cat stmt_all_obj
37: WHERE stmt_all_obj.cat_id = v_cat_id AND subcat_id IS NOT NULL;
38:
39: CURSOR c_cat_item (v_cat_id IN NUMBER)
40: IS

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)

Line 50: FROM ben_tcs_all_objects_in_cat stmt_all_obj

46:
47: CURSOR c_cat_parent (v_cat_id IN NUMBER)
48: IS
49: SELECT cat_id , row_in_cat_id ,all_objects_in_cat_id
50: FROM ben_tcs_all_objects_in_cat stmt_all_obj
51: WHERE stmt_all_obj.subcat_id = v_cat_id;
52:
53: CURSOR c_cat_hrchy (v_cat_id IN NUMBER, v_stmt_id NUMBER , v_period_id NUMBER)
54: IS