APPS.BEN_COMP_OBJECT_LIST dependencies on BEN_COMP_OBJ_CACHE

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

731:
732: --
733: BEGIN
734: --
735: INSERT INTO ben_comp_obj_cache
736: (
737: comp_obj_cache_id
738: ,effective_date
739: ,business_group_id

Line 748: ben_comp_obj_cache_s.nextval

744: ,no_programs
745: ,no_plans
746: ,pl_typ_id)
747: VALUES(
748: ben_comp_obj_cache_s.nextval
749: ,p_effective_date
750: ,p_business_group_id
751: ,SYSDATE
752: ,p_mode

Line 765: from ben_comp_obj_cache

761: --
762: COMMIT;
763: --
764: select count(*) into l_count
765: from ben_comp_obj_cache
766: where business_group_id = p_business_group_id
767: and effective_date = p_effective_date;
768:
769: IF ben_manage_life_events.g_cache_proc_object.COUNT > 0 THEN

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

905: ,c_eff_date date
906: )
907: is
908: select coc.comp_obj_cache_id
909: from ben_comp_obj_cache coc
910: where coc.business_group_id = c_bgp_id
911: and coc.effective_date = c_eff_date
912: and coc.mode_cd = p_mode; --bug 7700173
913: --

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

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

Line 949: FROM ben_comp_obj_cache

945: );
946: --
947: */
948: DELETE
949: FROM ben_comp_obj_cache
950: WHERE business_group_id = p_business_group_id
951: AND effective_date = p_effective_date
952: AND mode_cd = p_mode ; --bug 7700173
953: --

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

956: DELETE
957: FROM ben_comp_obj_cache_row cjr;
958: --
959: DELETE
960: FROM ben_comp_obj_cache;
961: --
962: END IF;
963: --
964: COMMIT;

Line 1701: FROM ben_comp_obj_cache

1697: ,pl_id
1698: ,no_programs
1699: ,no_plans
1700: ,pl_typ_id
1701: FROM ben_comp_obj_cache
1702: WHERE business_group_id = c_business_group_id
1703: AND effective_date = c_effective_date
1704: AND mode_cd = p_mode; --bug 7700173
1705: --

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