APPS.BEN_EXTRACT_SEED dependencies on BEN_EXT_CRIT_PRFL

Line 3855: FROM ben_ext_crit_prfl

3851:
3852: BEGIN
3853: SELECT ext_crit_prfl_id
3854: INTO l_ext_prfl_id
3855: FROM ben_ext_crit_prfl
3856: WHERE name = p_profile_name
3857: AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1)
3858: AND NVL(legislation_code,'~NVL~') = NVL(l_legislation_code,'~NVL~');
3859: EXCEPTION

Line 3929: FROM ben_ext_crit_prfl

3925:
3926: BEGIN
3927: SELECT ext_crit_prfl_id
3928: INTO l_ext_prfl_id
3929: FROM ben_ext_crit_prfl
3930: WHERE name = p_profile_name
3931: AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1)
3932: AND NVL(legislation_code,'~NVL~') = NVL(l_legislation_code,'~NVL~');
3933: EXCEPTION

Line 4094: FROM ben_ext_crit_prfl

4090:
4091: BEGIN
4092: SELECT ext_crit_prfl_id
4093: INTO l_ext_prfl_id
4094: FROM ben_ext_crit_prfl
4095: WHERE name = p_profile_name
4096: AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1)
4097: AND NVL(legislation_code,'~NVL~') = NVL(l_legislation_code,'~NVL~');
4098: EXCEPTION

Line 4288: FROM ben_ext_crit_prfl

4284:
4285: BEGIN
4286: SELECT ext_crit_prfl_id
4287: INTO l_ext_prfl_id
4288: FROM ben_ext_crit_prfl
4289: WHERE name = p_profile_name
4290: AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1)
4291: AND NVL(legislation_code,'~NVL~') = NVL(l_legislation_code,'~NVL~');
4292: EXCEPTION

Line 4489: FROM ben_ext_crit_prfl

4485: if p_profile_name is not null then
4486: BEGIN
4487: SELECT ext_crit_prfl_id
4488: INTO l_ext_prfl_id
4489: FROM ben_ext_crit_prfl
4490: WHERE name = p_profile_name
4491: AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1)
4492: AND NVL(legislation_code,'~NVL~') = NVL(l_legislation_code,'~NVL~');
4493: EXCEPTION