APPS.BEN_EXTRACT_SEED dependencies on BEN_PGM_F

Line 463: from ben_pgm_f

459: and ler_id = p_val;
460:
461:
462: cursor ci is select name
463: from ben_pgm_f
464: where business_group_id = p_business_group_id
465: and trunc(sysdate) between nvl(effective_start_date,trunc(sysdate))
466: and nvl(effective_end_date,trunc(sysdate))
467: and pgm_id = p_val;

Line 1228: from ben_pgm_f

1224: and ler_id = p_val_1;
1225:
1226:
1227: cursor ci is select pgm_id
1228: from ben_pgm_f
1229: where business_group_id = p_business_group_id
1230: and trunc(sysdate) between nvl(effective_start_date,trunc(sysdate))
1231: and nvl(effective_end_date,trunc(sysdate))
1232: and name = p_meaning ;