APPS.BEN_ENROLMENT_REQUIREMENTS dependencies on BEN_PGM_F

Line 562: ,p_pgm_rec in ben_pgm_f%rowtype

558: ,p_pl_rec in ben_pl_f%rowtype
559: ,p_ptip_id in number
560: ,p_ptip_rec in ben_ptip_f%rowtype
561: ,p_pgm_id in number
562: ,p_pgm_rec in ben_pgm_f%rowtype
563: ,p_ler_id in number
564: ,p_business_group_id in number
565: ,p_effective_date in date
566: ,p_dflt_enrt_cd out nocopy varchar2

Line 1425: l_pgm_rec ben_pgm_f%ROWTYPE;

1421: --
1422: l_result_flag VARCHAR2(30);
1423: l_crnt_pl_enrt_cvg_strt_dt DATE;
1424: l_crnt_opt_cvg_strt_dt DATE;
1425: l_pgm_rec ben_pgm_f%ROWTYPE;
1426: l_jurisdiction_code VARCHAR2(30);
1427: --
1428: l_lf_evt_ocrd_dt DATE := NVL(p_lf_evt_ocrd_dt, p_effective_date);
1429: l_lf_evt_ocrd_dt_1 DATE := l_lf_evt_ocrd_dt -

Line 2685: l_pgm_rec ben_pgm_f%ROWTYPE;

2681: l_mx_ordr_num ben_oipl_f.ordr_num%TYPE;
2682: l_enrd_ordr_num NUMBER;
2683: l_level VARCHAR2(30);
2684: l_plan_rec ben_pl_f%ROWTYPE;
2685: l_pgm_rec ben_pgm_f%ROWTYPE;
2686: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;
2687: l_pen_rec ben_prtt_enrt_rslt_f%ROWTYPE;
2688: l_pl_typ_esd DATE;
2689: l_pl_typ_eed DATE;

Line 3490: from ben_pgm_f pgm

3486: -- following requery logic added for bug 1394507 - 9 cursors
3487: --
3488: cursor c_pgm_requery(p_id number,p_ed date) is
3489: select 'Y'
3490: from ben_pgm_f pgm
3491: where pgm_id=p_id and
3492: business_group_id=p_business_group_id and
3493: p_ed between effective_start_date and effective_end_date
3494: ;

Line 8839: ,p_pgm_rec in ben_pgm_f%rowtype

8835: ,p_pl_rec in ben_pl_f%rowtype
8836: ,p_ptip_id in number
8837: ,p_ptip_rec in ben_ptip_f%rowtype
8838: ,p_pgm_id in number
8839: ,p_pgm_rec in ben_pgm_f%rowtype
8840: ,p_ler_id in number
8841: ,p_business_group_id in number
8842: ,p_effective_date in date
8843: ,p_dflt_enrt_cd out nocopy varchar2

Line 9554: l_pgm_rec ben_pgm_f%rowtype;

9550: l_use_dflt_flag varchar2(30);
9551: l_oipl_rec ben_oipl_f%rowtype;
9552: l_empty_oipl ben_oipl_f%rowtype;
9553: l_plan_rec ben_pl_f%rowtype;
9554: l_pgm_rec ben_pgm_f%rowtype;
9555: l_empty_pgm ben_pgm_f%rowtype;
9556: l_plip_rec ben_plip_f%rowtype;
9557: l_empty_plip ben_plip_f%rowtype;
9558: l_ptip_rec ben_ptip_f%rowtype;

Line 9555: l_empty_pgm ben_pgm_f%rowtype;

9551: l_oipl_rec ben_oipl_f%rowtype;
9552: l_empty_oipl ben_oipl_f%rowtype;
9553: l_plan_rec ben_pl_f%rowtype;
9554: l_pgm_rec ben_pgm_f%rowtype;
9555: l_empty_pgm ben_pgm_f%rowtype;
9556: l_plip_rec ben_plip_f%rowtype;
9557: l_empty_plip ben_plip_f%rowtype;
9558: l_ptip_rec ben_ptip_f%rowtype;
9559: l_empty_ptip ben_ptip_f%rowtype;