APPS.BEN_COMP_OBJECT_LIST dependencies on BEN_COMP_OBJ_CACHE_ROW

Line 719: select ben_comp_obj_cache_row_s.nextval

715: l_seqnextval number;
716: --
717: cursor c_getseq
718: is
719: select ben_comp_obj_cache_row_s.nextval
720: from sys.dual;
721:
722: --
723: BEGIN

Line 831: INSERT INTO ben_comp_obj_cache_row

827: --
828: if l_comp_obj_cache_row_id_va.count > 0 then
829: --
830: FORALL i IN l_comp_obj_cache_row_id_va.FIRST .. l_comp_obj_cache_row_id_va.LAST
831: INSERT INTO ben_comp_obj_cache_row
832: (comp_obj_cache_row_id
833: ,comp_obj_cache_id
834: ,pl_id
835: ,pgm_id

Line 917: delete from ben_comp_obj_cache_row ccr

913: if l_coc_id_va.count > 0
914: then
915: --
916: forall ccrelenum in l_coc_id_va.first..l_coc_id_va.last
917: delete from ben_comp_obj_cache_row ccr
918: where ccr.comp_obj_cache_id = l_coc_id_va(ccrelenum);
919: --
920: end if;
921: --

Line 925: FROM ben_comp_obj_cache_row cjr

921: --
922:
923: /*
924: DELETE
925: FROM ben_comp_obj_cache_row cjr
926: WHERE EXISTS(SELECT NULL
927: FROM ben_comp_obj_cache cjc
928: WHERE cjc.comp_obj_cache_id = cjr.comp_obj_cache_id
929: AND cjc.business_group_id = p_business_group_id

Line 942: FROM ben_comp_obj_cache_row cjr;

938: --
939: ELSE
940: --
941: DELETE
942: FROM ben_comp_obj_cache_row cjr;
943: --
944: DELETE
945: FROM ben_comp_obj_cache;
946: --

Line 1722: FROM ben_comp_obj_cache_row bcocr

1718: cursor c_unres_cache_only IS
1719: select distinct alws_unrstrctd_enrt_flag
1720: from ben_pgm_f
1721: where pgm_id in ( SELECT distinct bcocr.pgm_id
1722: FROM ben_comp_obj_cache_row bcocr
1723: WHERE bcocr.comp_obj_cache_id = l_comp_obj_cache_id )
1724: order by 1;
1725: --
1726: l_unres_cache_only varchar2(1) ;

Line 1732: FROM ben_comp_obj_cache_row bcocr

1728: cursor c_unres_cache_plnip_only IS
1729: select distinct alws_unrstrctd_enrt_flag
1730: from ben_pl_f
1731: where pl_id in ( SELECT distinct bcocr.pl_id
1732: FROM ben_comp_obj_cache_row bcocr
1733: WHERE bcocr.comp_obj_cache_id = l_comp_obj_cache_id
1734: and bcocr.pl_nip = 'Y' )
1735: order by 1;
1736: --