APPS.BEN_EXTRACT_SEED dependencies on BEN_EXT_CRIT_VAL

Line 67: from ben_ext_crit_val ecv ,

63: cursor c1 is
64: select ecv.ext_crit_val_id ,
65: ecv.object_version_number ,
66: ecv.LEGISLATION_CODE
67: from ben_ext_crit_val ecv ,
68: ben_ext_crit_typ ect
69: where ect.ext_crit_prfl_id = p_ext_crit_prfl_id
70: and ect.ext_crit_typ_id = ecv.ext_crit_typ_id
71: and ect.crit_typ_cd = 'ADV'

Line 106: BEN_ext_crit_val_API.delete_ext_crit_val

102: );
103:
104: End Loop ;
105: --- delete the criteria values
106: BEN_ext_crit_val_API.delete_ext_crit_val
107: (p_validate => FALSE
108: ,p_EXT_CRIT_VAL_ID => I.EXT_CRIT_VAL_ID
109: ,p_LEGISLATION_CODE => I.LEGISLATION_CODE
110: ,p_OBJECT_VERSION_NUMBER => l_OBJECT_VERSION_NUMBER

Line 4118: FROM ben_ext_crit_val

4114: BEGIN
4115: if p_type_code <> 'ADV' then
4116: SELECT 'Y'
4117: INTO l_temp
4118: FROM ben_ext_crit_val
4119: WHERE ext_crit_typ_id = l_ext_crit_typ_id
4120: AND val_1 = l_value
4121: AND nvl(val_2,'~NVL~') = NVL(l_value2,'~NVL~')
4122: AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1)

Line 4131: FROM ben_ext_crit_val

4127: Declare
4128:
4129: cursor c1 is
4130: SELECT 'Y'
4131: FROM ben_ext_crit_val
4132: WHERE ext_crit_typ_id = l_ext_crit_typ_id
4133: AND val_1 = l_value
4134: AND nvl(val_2,'~NVL~') = NVL(l_value2,'~NVL~')
4135: AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1)

Line 4317: FROM ben_ext_crit_val

4313: /*
4314: -- how do we differentiate whne more then one criteria val - tilak
4315: SELECT ext_crit_val_id
4316: INTO l_ext_crit_val_id
4317: FROM ben_ext_crit_val
4318: WHERE ext_crit_typ_id = l_ext_crit_typ_id
4319: --AND val_1 = p_val
4320: AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1)
4321: AND NVL(legislation_code,'~NVL~') = NVL(l_legislation_code,'~NVL~');