APPS.BEN_COMP_OBJECT_LIST dependencies on BEN_COMP_OBJ_CACHE_ROW

Line 729: select ben_comp_obj_cache_row_s.nextval

725: l_seqnextval number;
726: --
727: cursor c_getseq
728: is
729: select ben_comp_obj_cache_row_s.nextval
730: from sys.dual;
731:
732: --
733: BEGIN

Line 841: INSERT INTO ben_comp_obj_cache_row

837: --
838: if l_comp_obj_cache_row_id_va.count > 0 then
839: --
840: FORALL i IN l_comp_obj_cache_row_id_va.FIRST .. l_comp_obj_cache_row_id_va.LAST
841: INSERT INTO ben_comp_obj_cache_row
842: (comp_obj_cache_row_id
843: ,comp_obj_cache_id
844: ,pl_id
845: ,pgm_id

Line 931: delete from ben_comp_obj_cache_row ccr

927: if l_coc_id_va.count > 0
928: then
929: --
930: forall ccrelenum in l_coc_id_va.first..l_coc_id_va.last
931: delete from ben_comp_obj_cache_row ccr
932: where ccr.comp_obj_cache_id = l_coc_id_va(ccrelenum);
933: --
934: end if;
935: --

Line 939: FROM ben_comp_obj_cache_row cjr

935: --
936:
937: /*
938: DELETE
939: FROM ben_comp_obj_cache_row cjr
940: WHERE EXISTS(SELECT NULL
941: FROM ben_comp_obj_cache cjc
942: WHERE cjc.comp_obj_cache_id = cjr.comp_obj_cache_id
943: AND cjc.business_group_id = p_business_group_id

Line 957: FROM ben_comp_obj_cache_row cjr;

953: --
954: ELSE
955: --
956: DELETE
957: FROM ben_comp_obj_cache_row cjr;
958: --
959: DELETE
960: FROM ben_comp_obj_cache;
961: --

Line 1739: FROM ben_comp_obj_cache_row bcocr

1735: cursor c_unres_cache_only IS
1736: select distinct alws_unrstrctd_enrt_flag
1737: from ben_pgm_f
1738: where pgm_id in ( SELECT distinct bcocr.pgm_id
1739: FROM ben_comp_obj_cache_row bcocr
1740: WHERE bcocr.comp_obj_cache_id = l_comp_obj_cache_id )
1741: order by 1;
1742: --
1743: l_unres_cache_only varchar2(1) ;

Line 1749: FROM ben_comp_obj_cache_row bcocr

1745: cursor c_unres_cache_plnip_only IS
1746: select distinct alws_unrstrctd_enrt_flag
1747: from ben_pl_f
1748: where pl_id in ( SELECT distinct bcocr.pl_id
1749: FROM ben_comp_obj_cache_row bcocr
1750: WHERE bcocr.comp_obj_cache_id = l_comp_obj_cache_id
1751: and bcocr.pl_nip = 'Y' )
1752: order by 1;
1753: --