APPS.BEN_EXTRACT_SEED dependencies on BEN_EXT_CRIT_TYP

Line 68: ben_ext_crit_typ ect

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'
72: ;

Line 750: and lookup_type = 'BEN_EXT_CRIT_TYP'

746: CURSOR Cai IS
747: select MEANING
748: from HR_LOOKUPS
749: where LOOKUP_CODE = p_crit_typ_cd
750: and lookup_type = 'BEN_EXT_CRIT_TYP'
751: and substr(lookup_code, 1, 1) = 'C'
752: and lookup_code not in ('CBU')
753: and trunc(sysdate) between
754: nvl(start_date_active, trunc(sysdate))

Line 1511: and lookup_type = 'BEN_EXT_CRIT_TYP'

1507: CURSOR Cai IS
1508: select lookup_code
1509: from HR_LOOKUPS
1510: where LOOKUP_CODE = p_crit_typ_cd
1511: and lookup_type = 'BEN_EXT_CRIT_TYP'
1512: and substr(lookup_code, 1, 1) = 'C'
1513: and lookup_code not in ('CBU')
1514: and trunc(sysdate) between
1515: nvl(start_date_active, trunc(sysdate))

Line 3940: FROM ben_ext_crit_typ

3936: END;
3937: BEGIN
3938: SELECT 'Y'
3939: INTO l_temp
3940: FROM ben_ext_crit_typ
3941: WHERE ext_crit_prfl_id = l_ext_prfl_id
3942: AND crit_typ_cd = p_type_code
3943: AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1)
3944: AND NVL(legislation_code,'~NVL~') = NVL(l_legislation_code,'~NVL~');

Line 4060: p_err_msg => 'Criteria value not found : '||hr_general.decode_lookup('BEN_EXT_CRIT_TYP',l_code )||' : '||l_meaning,

4056: -- if the concurrent manger does the job log the message
4057: if g_business_group_id is not null and fnd_global.conc_request_id <> -1 then
4058: write_err
4059: (p_err_num => null,
4060: p_err_msg => 'Criteria value not found : '||hr_general.decode_lookup('BEN_EXT_CRIT_TYP',l_code )||' : '||l_meaning,
4061: p_typ_cd => 'E' ,
4062: p_business_group_id => l_new_business_group_id
4063: );
4064: return ;

Line 4066: raise_application_error(-20001,'Criteria value not found : '||hr_general.decode_lookup('BEN_EXT_CRIT_TYP',l_code)||' : '

4062: p_business_group_id => l_new_business_group_id
4063: );
4064: return ;
4065: else
4066: raise_application_error(-20001,'Criteria value not found : '||hr_general.decode_lookup('BEN_EXT_CRIT_TYP',l_code)||' : '
4067: ||l_meaning||':');
4068: end if ;
4069: END IF;
4070:

Line 4105: FROM ben_ext_crit_typ

4101: END;
4102: BEGIN
4103: SELECT ext_crit_typ_id
4104: INTO l_ext_crit_typ_id
4105: FROM ben_ext_crit_typ
4106: WHERE ext_crit_prfl_id = l_ext_prfl_id
4107: AND crit_typ_cd = p_TYPE_CODE
4108: AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1)
4109: AND NVL(legislation_code,'~NVL~') = NVL(l_legislation_code,'~NVL~');

Line 4272: p_err_msg => 'Criteria value not found : '||hr_general.decode_lookup('BEN_EXT_CRIT_TYP',l_code)||' : '||l_meaning,

4268: -- if the concurrent manger does the job log the message
4269: if g_business_group_id is not null and fnd_global.conc_request_id <> -1 then
4270: write_err
4271: (p_err_num => null,
4272: p_err_msg => 'Criteria value not found : '||hr_general.decode_lookup('BEN_EXT_CRIT_TYP',l_code)||' : '||l_meaning,
4273: p_typ_cd => 'E' ,
4274: p_business_group_id => l_new_business_group_id
4275: );
4276: return ;

Line 4278: raise_application_error(-20001,'Criteria value not found : '||hr_general.decode_lookup('BEN_EXT_CRIT_TYP',l_code)||' : '

4274: p_business_group_id => l_new_business_group_id
4275: );
4276: return ;
4277: else
4278: raise_application_error(-20001,'Criteria value not found : '||hr_general.decode_lookup('BEN_EXT_CRIT_TYP',l_code)||' : '
4279: ||l_meaning||':');
4280: end if ;
4281:
4282: END IF;

Line 4301: FROM ben_ext_crit_typ

4297:
4298: -- if more then one criteria defined how do we differentiat them - tilak
4299: SELECT ext_crit_typ_id
4300: INTO l_ext_crit_typ_id
4301: FROM ben_ext_crit_typ
4302: WHERE ext_crit_prfl_id = l_ext_prfl_id
4303: AND crit_typ_cd = p_type_code
4304: AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1)
4305: AND NVL(legislation_code,'~NVL~') = NVL(l_legislation_code,'~NVL~');