APPS.BEN_EXTRACT_SEED dependencies on BEN_CM_TYP_F

Line 402: cursor ca is SELECT name from ben_cm_typ_f

398: = nvl(p_business_group_id,-1)
399: and active_flag = 'Y'
400: and person_type_id = p_val;
401:
402: cursor ca is SELECT name from ben_cm_typ_f
403: WHERE nvl(business_group_id,nvl(p_business_group_id,-1))
404: = nvl(p_business_group_id,-1)
405: and cm_typ_id = p_val;
406:

Line 1165: cursor ca is SELECT cm_typ_id from ben_cm_typ_f

1161: = nvl(p_business_group_id,-1)
1162: and active_flag = 'Y'
1163: and user_person_type = p_meaning;
1164:
1165: cursor ca is SELECT cm_typ_id from ben_cm_typ_f
1166: WHERE nvl(business_group_id ,nvl(p_business_group_id,-1))
1167: = nvl(p_business_group_id,-1)
1168: and name = p_meaning ;
1169: