APPS.BEN_COMP_OBJECT_LIST dependencies on BEN_COMP_OBJ_CACHE

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 725: INSERT INTO ben_comp_obj_cache

721:
722: --
723: BEGIN
724: --
725: INSERT INTO ben_comp_obj_cache
726: (
727: comp_obj_cache_id
728: ,effective_date
729: ,business_group_id

Line 738: ben_comp_obj_cache_s.nextval

734: ,no_programs
735: ,no_plans
736: ,pl_typ_id)
737: VALUES(
738: ben_comp_obj_cache_s.nextval
739: ,p_effective_date
740: ,p_business_group_id
741: ,SYSDATE
742: ,p_mode

Line 755: from ben_comp_obj_cache

751: --
752: COMMIT;
753: --
754: select count(*) into l_count
755: from ben_comp_obj_cache
756: where business_group_id = p_business_group_id
757: and effective_date = p_effective_date;
758:
759: IF ben_manage_life_events.g_cache_proc_object.COUNT > 0 THEN

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 896: from ben_comp_obj_cache coc

892: ,c_eff_date date
893: )
894: is
895: select coc.comp_obj_cache_id
896: from ben_comp_obj_cache coc
897: where coc.business_group_id = c_bgp_id
898: and coc.effective_date = c_eff_date;
899: --
900: BEGIN

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 927: FROM ben_comp_obj_cache cjc

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
930: AND cjc.effective_date = p_effective_date
931: );

Line 935: FROM ben_comp_obj_cache

931: );
932: --
933: */
934: DELETE
935: FROM ben_comp_obj_cache
936: WHERE business_group_id = p_business_group_id
937: AND effective_date = p_effective_date;
938: --
939: ELSE

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 945: FROM ben_comp_obj_cache;

941: DELETE
942: FROM ben_comp_obj_cache_row cjr;
943: --
944: DELETE
945: FROM ben_comp_obj_cache;
946: --
947: END IF;
948: --
949: COMMIT;

Line 1685: FROM ben_comp_obj_cache

1681: ,pl_id
1682: ,no_programs
1683: ,no_plans
1684: ,pl_typ_id
1685: FROM ben_comp_obj_cache
1686: WHERE business_group_id = c_business_group_id
1687: AND effective_date = c_effective_date;
1688: --
1689: CURSOR c_chgpgm(

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: --