APPS.BEN_TCS_STMT_PROCESS dependencies on BEN_TCS_CAT_SUBCAT_HRCHY

Line 352: FROM ben_tcs_cat_subcat_hrchy

348:
349: CURSOR c_cat_hrchy_val(v_period_id IN NUMBER)
350: IS
351: SELECT row_in_cat_id row_cat_id
352: FROM ben_tcs_cat_subcat_hrchy
353: WHERE stmt_perd_id = v_period_id
354: AND lvl_num = 1;
355:
356: cat_hrchy_val_rec c_cat_hrchy_val%ROWTYPE;

Line 361: FROM ben_tcs_cat_item_hrchy item ,ben_tcs_cat_subcat_hrchy cat

357:
358: CURSOR c_row_cat_id( row_id IN NUMBER , v_period_id IN NUMBER)
359: IS
360: SELECT distinct nvl(item.stmt_perd_id,cat.stmt_perd_id )row_cat_id
361: FROM ben_tcs_cat_item_hrchy item ,ben_tcs_cat_subcat_hrchy cat
362: WHERE (item.row_in_cat_id =row_id
363: AND item.lvl_num =1
364: AND item.stmt_perd_id <> v_period_id )
365: OR( cat.row_in_cat_id =row_id

Line 507: FROM ben_tcs_cat_subcat_hrchy

503:
504: IF( cat_id_found ='Y')THEN
505:
506: DELETE
507: FROM ben_tcs_cat_subcat_hrchy
508: WHERE sub_cat_id =subcat_hrchy_values(i).subcat_id
509: AND stmt_perd_id = subcat_hrchy_values(i).perd_id ;
510: END IF;
511: END LOOP;

Line 526: INSERT INTO ben_tcs_cat_subcat_hrchy

522: END IF;
523: END LOOP;
524:
525: IF( cat_id_found ='Y')THEN
526: INSERT INTO ben_tcs_cat_subcat_hrchy
527: (stmt_id, cat_id,
528: sub_cat_id,
529: lvl_num,row_in_cat_id ,stmt_perd_id
530: )

Line 599: FROM ben_tcs_cat_subcat_hrchy

595: WHERE stmt_perd_id = l_rep_rec(i).PERIOD_ID;
596:
597: hr_utility.set_location('Deleting Subcat Hrchy for period' || l_rep_rec(i).PERIOD_ID ,64);
598: DELETE
599: FROM ben_tcs_cat_subcat_hrchy
600: WHERE stmt_perd_id = l_rep_rec(i).PERIOD_ID;
601:
602: FOR j IN 1..row_in_cat.COUNT
603: LOOP