APPS.BEN_EXTRACT_SEED dependencies on BEN_PL_F

Line 430: from ben_pl_f

426: and input_value_id = p_val;
427:
428:
429: cursor ce is select name
430: from ben_pl_f
431: where business_group_id = p_business_group_id
432: and trunc(sysdate) between nvl(effective_start_date,trunc(sysdate))
433: and nvl(effective_end_date,trunc(sysdate))
434: and pl_id = p_val;

Line 471: from ben_pl_f

467: and pgm_id = p_val;
468:
469:
470: cursor cj is select name
471: from ben_pl_f
472: where business_group_id = p_business_group_id
473: and trunc(sysdate) between nvl(effective_start_date,trunc(sysdate))
474: and nvl(effective_end_date,trunc(sysdate))
475: and pl_id = p_val;

Line 1197: from ben_pl_f

1193: and element_name = p_parent_meaning);
1194:
1195:
1196: cursor ce is select pl_id
1197: from ben_pl_f
1198: where business_group_id = p_business_group_id
1199: and trunc(sysdate) between nvl(effective_start_date,trunc(sysdate))
1200: and nvl(effective_end_date,trunc(sysdate))
1201: and name = p_meaning ;

Line 1236: from ben_pl_f

1232: and name = p_meaning ;
1233:
1234:
1235: cursor cj is select pl_id
1236: from ben_pl_f
1237: where business_group_id = p_business_group_id
1238: and trunc(sysdate) between nvl(effective_start_date,trunc(sysdate))
1239: and nvl(effective_end_date,trunc(sysdate))
1240: and name = p_meaning ;

Line 1485: ben_pl_f pl,

1481:
1482: cursor c_enb is
1483: select ENRT_PERD_ID
1484: from ben_enrt_perd enp ,
1485: ben_pl_f pl,
1486: ben_popl_enrt_typ_cycl_f pet
1487: where to_char(enp.strt_dt, 'DD-MON-RRRR') || ' - ' || to_char( enp.end_dt, 'DD-MON-RRRR') = p_meaning
1488: and pl.name = p_parent_meaning
1489: and pl.pl_id = pet.pl_id