APPS.BEN_EXTRACT_SEED dependencies on BEN_PGM_F

Line 516: from ben_pgm_f

512: and ler_id = p_val;
513:
514:
515: cursor ci is select name
516: from ben_pgm_f
517: where business_group_id = p_business_group_id
518: and trunc(sysdate) between nvl(effective_start_date,trunc(sysdate))
519: and nvl(effective_end_date,trunc(sysdate))
520: and pgm_id = p_val;

Line 1281: from ben_pgm_f

1277: and ler_id = p_val_1;
1278:
1279:
1280: cursor ci is select pgm_id
1281: from ben_pgm_f
1282: where business_group_id = p_business_group_id
1283: and trunc(sysdate) between nvl(effective_start_date,trunc(sysdate))
1284: and nvl(effective_end_date,trunc(sysdate))
1285: and name = p_meaning ;