APPS.BEN_EXTRACT_SEED dependencies on BEN_PL_F

Line 483: from ben_pl_f

479: and input_value_id = p_val;
480:
481:
482: cursor ce is select name
483: from ben_pl_f
484: where business_group_id = p_business_group_id
485: and trunc(sysdate) between nvl(effective_start_date,trunc(sysdate))
486: and nvl(effective_end_date,trunc(sysdate))
487: and pl_id = p_val;

Line 524: from ben_pl_f

520: and pgm_id = p_val;
521:
522:
523: cursor cj is select name
524: from ben_pl_f
525: where business_group_id = p_business_group_id
526: and trunc(sysdate) between nvl(effective_start_date,trunc(sysdate))
527: and nvl(effective_end_date,trunc(sysdate))
528: and pl_id = p_val;

Line 1250: from ben_pl_f

1246: and element_name = p_parent_meaning);
1247:
1248:
1249: cursor ce is select pl_id
1250: from ben_pl_f
1251: where business_group_id = p_business_group_id
1252: and trunc(sysdate) between nvl(effective_start_date,trunc(sysdate))
1253: and nvl(effective_end_date,trunc(sysdate))
1254: and name = p_meaning ;

Line 1289: from ben_pl_f

1285: and name = p_meaning ;
1286:
1287:
1288: cursor cj is select pl_id
1289: from ben_pl_f
1290: where business_group_id = p_business_group_id
1291: and trunc(sysdate) between nvl(effective_start_date,trunc(sysdate))
1292: and nvl(effective_end_date,trunc(sysdate))
1293: and name = p_meaning ;

Line 1538: ben_pl_f pl,

1534:
1535: cursor c_enb is
1536: select ENRT_PERD_ID
1537: from ben_enrt_perd enp ,
1538: ben_pl_f pl,
1539: ben_popl_enrt_typ_cycl_f pet
1540: where to_char(enp.strt_dt, 'DD-MON-RRRR') || ' - ' || to_char( enp.end_dt, 'DD-MON-RRRR') = p_meaning
1541: and pl.name = p_parent_meaning
1542: and pl.pl_id = pet.pl_id