APPS.BEN_EXTRACT_SEED dependencies on BEN_EXT_CRIT_CMBN

Line 27: from ben_ext_crit_cmbn

23: cursor c2 (p_ext_crit_val_id number) is
24: select ext_crit_cmbn_id ,
25: object_version_number ,
26: LEGISLATION_CODE
27: from ben_ext_crit_cmbn
28: where ext_crit_val_id = p_ext_crit_val_id
29: ;
30:
31: l_proc varchar2(100) := 'BEN_EXT_SEED.delete_crit_adv_conditon' ;

Line 43: BEN_ext_crit_cmbn_API.delete_ext_crit_cmbn

39:
40: for k in c2(i.ext_crit_val_id)
41: Loop
42: --- celete adv crit combn values
43: BEN_ext_crit_cmbn_API.delete_ext_crit_cmbn
44: (p_validate => FALSE
45: ,p_EXT_CRIT_CMBN_ID => k.EXT_CRIT_CMBN_ID
46: ,p_LEGISLATION_CODE => k.LEGISLATION_CODE
47: ,p_OBJECT_VERSION_NUMBER => l_OBJECT_VERSION_NUMBER

Line 4283: FROM ben_ext_crit_cmbn

4279: END;
4280: BEGIN
4281: SELECT 'Y'
4282: INTO l_temp
4283: FROM ben_ext_crit_cmbn
4284: WHERE ext_crit_val_id = l_ext_crit_val_id
4285: AND crit_typ_cd = p_crit_typ_cd
4286: and oper_cd = p_oper_cd
4287: AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1)