APPS.BEN_PEN_BUS dependencies on BEN_PGM_F

Line 410: p_business_group_id ben_pgm_f.business_group_id%type,

406:
407: g_mx_dpnt_pct_prtt_lf integer := 0;
408: g_mx_sps_pct_prtt_lf integer := 0;
409: cursor g_c_pgm (p_effective_date date,
410: p_business_group_id ben_pgm_f.business_group_id%type,
411: p_pgm_id ben_pgm_f.pgm_id%type
412: ) is
413: select pgm_id, name,
414: MX_DPNT_PCT_PRTT_LF_AMT,

Line 411: p_pgm_id ben_pgm_f.pgm_id%type

407: g_mx_dpnt_pct_prtt_lf integer := 0;
408: g_mx_sps_pct_prtt_lf integer := 0;
409: cursor g_c_pgm (p_effective_date date,
410: p_business_group_id ben_pgm_f.business_group_id%type,
411: p_pgm_id ben_pgm_f.pgm_id%type
412: ) is
413: select pgm_id, name,
414: MX_DPNT_PCT_PRTT_LF_AMT,
415: MX_SPS_PCT_PRTT_LF_AMT,

Line 417: from ben_pgm_f

413: select pgm_id, name,
414: MX_DPNT_PCT_PRTT_LF_AMT,
415: MX_SPS_PCT_PRTT_LF_AMT,
416: COORD_CVG_FOR_ALL_PLS_FLG
417: from ben_pgm_f
418: where pgm_id = p_pgm_id
419: and business_group_id = p_business_group_id
420: and p_effective_date between
421: effective_start_date and effective_end_date