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 6212: l_pl_typ_name ben_pl_typ_f.name%type := null;

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

Line 6216: from ben_pl_typ_f ptp

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

Line 6268: l_pl_typ_id ben_pl_typ_f.pl_typ_id%type;

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

Line 6593: l_pl_typ_name ben_pl_typ_f.name%type;

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

Line 7306: l_pl_typ_name ben_pl_typ_f.name%type;

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

Line 7309: l_pl_typ_id ben_pl_typ_f.pl_typ_id%type;

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