eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PCP_BUS dependencies on BEN_PL_F

Line 662: l_svgs_pl_flag ben_pl_f.svgs_pl_flag%type;

658: ( p_pl_id in number
659: , p_effective_date in date) is
660:
661: l_proc varchar2(72) := g_package|| ' chk_pl_pcp_record';
662: l_svgs_pl_flag ben_pl_f.svgs_pl_flag%type;
663: l_imptd_incm_calc_cd ben_pl_f.imptd_incm_calc_cd%type;
664: l_invk_flx_cr_pl_flag ben_pl_f.invk_flx_cr_pl_flag%type;
665: l_invk_dcln_prtn_pl_flag ben_pl_f.invk_dcln_prtn_pl_flag%type;
666:

Line 663: l_imptd_incm_calc_cd ben_pl_f.imptd_incm_calc_cd%type;

659: , p_effective_date in date) is
660:
661: l_proc varchar2(72) := g_package|| ' chk_pl_pcp_record';
662: l_svgs_pl_flag ben_pl_f.svgs_pl_flag%type;
663: l_imptd_incm_calc_cd ben_pl_f.imptd_incm_calc_cd%type;
664: l_invk_flx_cr_pl_flag ben_pl_f.invk_flx_cr_pl_flag%type;
665: l_invk_dcln_prtn_pl_flag ben_pl_f.invk_dcln_prtn_pl_flag%type;
666:
667:

Line 664: l_invk_flx_cr_pl_flag ben_pl_f.invk_flx_cr_pl_flag%type;

660:
661: l_proc varchar2(72) := g_package|| ' chk_pl_pcp_record';
662: l_svgs_pl_flag ben_pl_f.svgs_pl_flag%type;
663: l_imptd_incm_calc_cd ben_pl_f.imptd_incm_calc_cd%type;
664: l_invk_flx_cr_pl_flag ben_pl_f.invk_flx_cr_pl_flag%type;
665: l_invk_dcln_prtn_pl_flag ben_pl_f.invk_dcln_prtn_pl_flag%type;
666:
667:
668: --cursor to check the values in svgs_pl_flag, imptd_incm_calc_cd, invk_flx_cr_pl_flag

Line 665: l_invk_dcln_prtn_pl_flag ben_pl_f.invk_dcln_prtn_pl_flag%type;

661: l_proc varchar2(72) := g_package|| ' chk_pl_pcp_record';
662: l_svgs_pl_flag ben_pl_f.svgs_pl_flag%type;
663: l_imptd_incm_calc_cd ben_pl_f.imptd_incm_calc_cd%type;
664: l_invk_flx_cr_pl_flag ben_pl_f.invk_flx_cr_pl_flag%type;
665: l_invk_dcln_prtn_pl_flag ben_pl_f.invk_dcln_prtn_pl_flag%type;
666:
667:
668: --cursor to check the values in svgs_pl_flag, imptd_incm_calc_cd, invk_flx_cr_pl_flag
669: cursor c1 is

Line 671: from ben_pl_f

667:
668: --cursor to check the values in svgs_pl_flag, imptd_incm_calc_cd, invk_flx_cr_pl_flag
669: cursor c1 is
670: select svgs_pl_flag, imptd_incm_calc_cd, invk_flx_cr_pl_flag, invk_dcln_prtn_pl_flag
671: from ben_pl_f
672: Where pl_id = p_pl_id
673: and p_effective_date between effective_start_date and
674: effective_end_date;
675: