DBA Data[Home] [Help]

APPS.BEN_EXTRACT_SEED dependencies on BEN_RPTG_GRP_V

Line 437: from ben_rptg_grp_v

433: and nvl(effective_end_date,trunc(sysdate))
434: and pl_id = p_val;
435: /*
436: cursor cf is select name
437: from ben_rptg_grp_v
438: WHERE nvl(business_group_id,nvl(p_business_group_id,-1))
439: = nvl(p_business_group_id,-1)
440: and rptg_grp_id = p_val;
441: */

Line 478: from ben_rptg_grp_v

474: and nvl(effective_end_date,trunc(sysdate))
475: and pl_id = p_val;
476:
477: cursor ck is select name
478: from ben_rptg_grp_v
479: where business_group_id = p_business_group_id
480: and rptg_grp_id = p_val;
481:
482:

Line 1204: from ben_rptg_grp_v

1200: and nvl(effective_end_date,trunc(sysdate))
1201: and name = p_meaning ;
1202: /*
1203: cursor cf is select name
1204: from ben_rptg_grp_v
1205: where business_group_id = p_business_group_id
1206: and rptg_grp_id = p_val_1;
1207: */
1208:

Line 1243: from ben_rptg_grp_v

1239: and nvl(effective_end_date,trunc(sysdate))
1240: and name = p_meaning ;
1241:
1242: cursor ck is select rptg_grp_id
1243: from ben_rptg_grp_v
1244: where business_group_id = p_business_group_id
1245: and name = p_meaning ;
1246:
1247: cursor cl is select lookup_code