APPS.BEN_EXTRACT_SEED dependencies on BEN_EXT_CRIT_PRFL

Line 3799: FROM ben_ext_crit_prfl

3795:
3796: BEGIN
3797: SELECT ext_crit_prfl_id
3798: INTO l_ext_prfl_id
3799: FROM ben_ext_crit_prfl
3800: WHERE name = p_profile_name
3801: AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1)
3802: AND NVL(legislation_code,'~NVL~') = NVL(l_legislation_code,'~NVL~');
3803: EXCEPTION

Line 3873: FROM ben_ext_crit_prfl

3869:
3870: BEGIN
3871: SELECT ext_crit_prfl_id
3872: INTO l_ext_prfl_id
3873: FROM ben_ext_crit_prfl
3874: WHERE name = p_profile_name
3875: AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1)
3876: AND NVL(legislation_code,'~NVL~') = NVL(l_legislation_code,'~NVL~');
3877: EXCEPTION

Line 4038: FROM ben_ext_crit_prfl

4034:
4035: BEGIN
4036: SELECT ext_crit_prfl_id
4037: INTO l_ext_prfl_id
4038: FROM ben_ext_crit_prfl
4039: WHERE name = p_profile_name
4040: AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1)
4041: AND NVL(legislation_code,'~NVL~') = NVL(l_legislation_code,'~NVL~');
4042: EXCEPTION

Line 4232: FROM ben_ext_crit_prfl

4228:
4229: BEGIN
4230: SELECT ext_crit_prfl_id
4231: INTO l_ext_prfl_id
4232: FROM ben_ext_crit_prfl
4233: WHERE name = p_profile_name
4234: AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1)
4235: AND NVL(legislation_code,'~NVL~') = NVL(l_legislation_code,'~NVL~');
4236: EXCEPTION

Line 4433: FROM ben_ext_crit_prfl

4429: if p_profile_name is not null then
4430: BEGIN
4431: SELECT ext_crit_prfl_id
4432: INTO l_ext_prfl_id
4433: FROM ben_ext_crit_prfl
4434: WHERE name = p_profile_name
4435: AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1)
4436: AND NVL(legislation_code,'~NVL~') = NVL(l_legislation_code,'~NVL~');
4437: EXCEPTION