APPS.BEN_PLAN_DESIGN_PROGRAM_MODULE dependencies on BEN_PL_TYP_F

Line 852: -- START OF BEN_PL_TYP_F ----------------------

848: ---------------------------------------------------------------
849: -- END OF BEN_OPTIP_F ----------------------
850: ---------------------------------------------------------------
851: ---------------------------------------------------------------
852: -- START OF BEN_PL_TYP_F ----------------------
853: ---------------------------------------------------------------
854: cursor c_ptp_from_parent(c_PTIP_ID number) is
855: select distinct pl_typ_id
856: from BEN_PTIP_F

Line 862: -- END OF BEN_PL_TYP_F ----------------------

858: --
859: l_pl_typ_id number(15);
860: l_out_ptp_result_id number(15);
861: ---------------------------------------------------------------
862: -- END OF BEN_PL_TYP_F ----------------------
863: ---------------------------------------------------------------
864: -- Added to Fetch Lookup Meaning for Program Type
865: cursor c_lookup_meaning(c_lookup_code in varchar2,c_lookup_type in varchar2) is
866: select hl.meaning

Line 2844: -- START OF BEN_PL_TYP_F ----------------------

2840: -- START OF BEN_ELIG_TO_PRTE_RSN_F ----------------------
2841: ---------------------------------------------------------------
2842: --
2843: ---------------------------------------------------------------
2844: -- START OF BEN_PL_TYP_F ----------------------
2845: ---------------------------------------------------------------
2846: --
2847: for l_parent_rec in c_ptp_from_parent(l_PTIP_ID) loop
2848: ben_plan_design_plan_module.create_pl_typ_result

Line 2861: -- END OF BEN_PL_TYP_F ----------------------

2857: ,p_parent_entity_result_id => NULL -- Hide PTP for HGrid
2858: );
2859: end loop;
2860: ---------------------------------------------------------------
2861: -- END OF BEN_PL_TYP_F ----------------------
2862: ---------------------------------------------------------------
2863: for l_parent_rec in c_peo1_from_parent(l_PTIP_ID) loop
2864: --
2865: l_mirror_src_entity_result_id := l_out_ctp_result_id ;

Line 6211: l_pl_typ_name ben_pl_typ_f.name%type := null;

6207: p_pl_typ_id in number
6208: ,p_effective_date in date
6209: ) return varchar2 is
6210:
6211: l_pl_typ_name ben_pl_typ_f.name%type := null;
6212:
6213: cursor c_pl_typ_name is
6214: select ptp.name
6215: from ben_pl_typ_f ptp

Line 6215: from ben_pl_typ_f ptp

6211: l_pl_typ_name ben_pl_typ_f.name%type := null;
6212:
6213: cursor c_pl_typ_name is
6214: select ptp.name
6215: from ben_pl_typ_f ptp
6216: where ptp.pl_typ_id = p_pl_typ_id
6217: and p_effective_date between ptp.effective_start_date
6218: and ptp.effective_end_date;
6219:

Line 6267: l_pl_typ_id ben_pl_typ_f.pl_typ_id%type;

6263: and p_effective_date between ctp.effective_start_date
6264: and ctp.effective_end_date;
6265:
6266: l_pgm_id ben_pgm_f.pgm_id%type;
6267: l_pl_typ_id ben_pl_typ_f.pl_typ_id%type;
6268: l_ptip_name varchar2(500);
6269:
6270: begin
6271:

Line 6592: l_pl_typ_name ben_pl_typ_f.name%type;

6588: ,p_pl_typ_id in number
6589: ,p_effective_date in date
6590: ) return varchar2 is
6591:
6592: l_pl_typ_name ben_pl_typ_f.name%type;
6593: l_opt_name ben_opt_f.name%type;
6594:
6595: begin
6596: l_opt_name := get_opt_name(p_opt_id,p_effective_date);

Line 7305: l_pl_typ_name ben_pl_typ_f.name%type;

7301: where cop.oipl_id = p_oipl_id
7302: and p_effective_date between cop.effective_start_date
7303: and cop.effective_end_date;
7304:
7305: l_pl_typ_name ben_pl_typ_f.name%type;
7306: l_opt_name ben_opt_f.name%type;
7307: l_pl_name ben_pl_f.name%type;
7308: l_pl_typ_id ben_pl_typ_f.pl_typ_id%type;
7309: l_opt_id ben_opt_f.opt_id%type;

Line 7308: l_pl_typ_id ben_pl_typ_f.pl_typ_id%type;

7304:
7305: l_pl_typ_name ben_pl_typ_f.name%type;
7306: l_opt_name ben_opt_f.name%type;
7307: l_pl_name ben_pl_f.name%type;
7308: l_pl_typ_id ben_pl_typ_f.pl_typ_id%type;
7309: l_opt_id ben_opt_f.opt_id%type;
7310: l_pl_id ben_pl_f.pl_id%type;
7311:
7312: begin