DBA Data[Home] [Help]

APPS.BEN_EXTRACT_SEED dependencies on BEN_RPTG_GRP_V

Line 490: from ben_rptg_grp_v

486: and nvl(effective_end_date,trunc(sysdate))
487: and pl_id = p_val;
488: /*
489: cursor cf is select name
490: from ben_rptg_grp_v
491: WHERE nvl(business_group_id,nvl(p_business_group_id,-1))
492: = nvl(p_business_group_id,-1)
493: and rptg_grp_id = p_val;
494: */

Line 531: from ben_rptg_grp_v

527: and nvl(effective_end_date,trunc(sysdate))
528: and pl_id = p_val;
529:
530: cursor ck is select name
531: from ben_rptg_grp_v
532: where business_group_id = p_business_group_id
533: and rptg_grp_id = p_val;
534:
535:

Line 1257: from ben_rptg_grp_v

1253: and nvl(effective_end_date,trunc(sysdate))
1254: and name = p_meaning ;
1255: /*
1256: cursor cf is select name
1257: from ben_rptg_grp_v
1258: where business_group_id = p_business_group_id
1259: and rptg_grp_id = p_val_1;
1260: */
1261:

Line 1296: from ben_rptg_grp_v

1292: and nvl(effective_end_date,trunc(sysdate))
1293: and name = p_meaning ;
1294:
1295: cursor ck is select rptg_grp_id
1296: from ben_rptg_grp_v
1297: where business_group_id = p_business_group_id
1298: and name = p_meaning ;
1299:
1300: cursor cl is select lookup_code