APPS.BEN_PEN_BUS dependencies on BEN_PGM_F

Line 398: p_business_group_id ben_pgm_f.business_group_id%type,

394:
395: g_mx_dpnt_pct_prtt_lf integer := 0;
396: g_mx_sps_pct_prtt_lf integer := 0;
397: cursor g_c_pgm (p_effective_date date,
398: p_business_group_id ben_pgm_f.business_group_id%type,
399: p_pgm_id ben_pgm_f.pgm_id%type
400: ) is
401: select pgm_id, name,
402: MX_DPNT_PCT_PRTT_LF_AMT,

Line 399: p_pgm_id ben_pgm_f.pgm_id%type

395: g_mx_dpnt_pct_prtt_lf integer := 0;
396: g_mx_sps_pct_prtt_lf integer := 0;
397: cursor g_c_pgm (p_effective_date date,
398: p_business_group_id ben_pgm_f.business_group_id%type,
399: p_pgm_id ben_pgm_f.pgm_id%type
400: ) is
401: select pgm_id, name,
402: MX_DPNT_PCT_PRTT_LF_AMT,
403: MX_SPS_PCT_PRTT_LF_AMT,

Line 405: from ben_pgm_f

401: select pgm_id, name,
402: MX_DPNT_PCT_PRTT_LF_AMT,
403: MX_SPS_PCT_PRTT_LF_AMT,
404: COORD_CVG_FOR_ALL_PLS_FLG
405: from ben_pgm_f
406: where pgm_id = p_pgm_id
407: and business_group_id = p_business_group_id
408: and p_effective_date between
409: effective_start_date and effective_end_date