APPS.BEN_PLAN_DESIGN_TXNS_API dependencies on PER_SEC_PROFILE_ASSIGNMENTS_V

Line 2314: from per_sec_profile_assignments_v

2310: --
2311: /* Bug 3170928 Changes
2312: cursor c_get_sec_prf_bg_id(p_user_id number) is
2313: select distinct(business_group_id) business_group_id
2314: from per_sec_profile_assignments_v
2315: where user_id = p_user_id
2316: and trunc(sysdate) between START_DATE
2317: and nvl(END_DATE, trunc(sysdate));
2318: */

Line 2321: from per_sec_profile_assignments_v

2317: and nvl(END_DATE, trunc(sysdate));
2318: */
2319: cursor c_get_sec_prf_bg_id(p_user_id number) is
2320: select distinct(business_group_id) business_group_id
2321: from per_sec_profile_assignments_v
2322: where user_id = p_user_id
2323: and trunc(sysdate) between START_DATE
2324: and nvl(END_DATE, trunc(sysdate))
2325: and business_group_id is not null ;