APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_PRTN_ELIG_F

Line 240: -- START OF BEN_PRTN_ELIG_F ----------------------

236: --and trt.where_clause = upper(c_parent_table_name) ;
237: -- trt.table_alias = c_parent_table_alias ;
238: ---
239: ---------------------------------------------------------------
240: -- START OF BEN_PRTN_ELIG_F ----------------------
241: ---------------------------------------------------------------
242: cursor c_epa_from_parent(c_pgm_id number,c_ptip_id number,c_plip_id number,
243: c_pl_id number,c_oipl_id number) is
244: select distinct prtn_elig_id

Line 245: from BEN_PRTN_ELIG_F

241: ---------------------------------------------------------------
242: cursor c_epa_from_parent(c_pgm_id number,c_ptip_id number,c_plip_id number,
243: c_pl_id number,c_oipl_id number) is
244: select distinct prtn_elig_id
245: from BEN_PRTN_ELIG_F
246: where (c_pgm_id is not null and pgm_id = c_pgm_id ) or
247: (c_ptip_id is not null and ptip_id = c_ptip_id ) or
248: (c_plip_id is not null and plip_id = c_plip_id ) or
249: (c_pl_id is not null and pl_id = c_pl_id ) or

Line 255: from BEN_PRTN_ELIG_F epa

251: --
252: cursor c_epa(c_prtn_elig_id number,c_mirror_src_entity_result_id number,
253: c_table_alias varchar2 ) is
254: select epa.*
255: from BEN_PRTN_ELIG_F epa
256: where epa.prtn_elig_id = c_prtn_elig_id
257: -- and epa.business_group_id = p_business_group_id
258: and not exists (
259: select /* */ null

Line 266: -- and trt.where_clause = 'BEN_PRTN_ELIG_F'

262: where copy_entity_txn_id = p_copy_entity_txn_id
263: -- and trt.table_route_id = cpe.table_route_id
264: and ( -- c_mirror_src_entity_result_id is null or
265: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
266: -- and trt.where_clause = 'BEN_PRTN_ELIG_F'
267: and cpe.table_alias = c_table_alias
268: and information1 = c_prtn_elig_id
269: -- and information4 = epa.business_group_id
270: and information2 = epa.effective_start_date

Line 276: -- END OF BEN_PRTN_ELIG_F ----------------------

272: );
273: l_prtn_elig_id number(15);
274: l_out_epa_result_id number(15);
275: ---------------------------------------------------------------
276: -- END OF BEN_PRTN_ELIG_F ----------------------
277: ---------------------------------------------------------------
278: ---------------------------------------------------------------
279: -- START OF BEN_PRTN_ELIG_PRFL_F ----------------------
280: ---------------------------------------------------------------

Line 363: l_parent_rec BEN_PRTN_ELIG_F%ROWTYPE;

359: l_mndtry_flag ben_prtn_elig_prfl_f.mndtry_flag%type;
360:
361: TYPE rt_ref_csr_typ IS REF CURSOR;
362: c_parent_rec rt_ref_csr_typ;
363: l_parent_rec BEN_PRTN_ELIG_F%ROWTYPE;
364: l_Sql Varchar2(2000) := NULL;
365: l_Bind_Value Ben_Pgm_F.Pgm_Id%TYPE := NULL;
366: l_parent_prtn_elig_id number;
367:

Line 393: -- START OF BEN_PRTN_ELIG_F ----------------------

389: end if;
390: --End Bug 5059695
391:
392: ---------------------------------------------------------------
393: -- START OF BEN_PRTN_ELIG_F ----------------------
394: ---------------------------------------------------------------
395: --
396: If p_pgm_id is NOT NULL then
397:

Line 398: l_Sql := 'select distinct prtn_elig_id from BEN_PRTN_ELIG_F where pgm_id = :pgm_id';

394: ---------------------------------------------------------------
395: --
396: If p_pgm_id is NOT NULL then
397:
398: l_Sql := 'select distinct prtn_elig_id from BEN_PRTN_ELIG_F where pgm_id = :pgm_id';
399:
400: l_Bind_Value := p_Pgm_id;
401:
402: Elsif p_ptip_id is NOT NULL then

Line 404: l_sql := 'select distinct prtn_elig_id from BEN_PRTN_ELIG_F where ptip_id = :ptip_id';

400: l_Bind_Value := p_Pgm_id;
401:
402: Elsif p_ptip_id is NOT NULL then
403:
404: l_sql := 'select distinct prtn_elig_id from BEN_PRTN_ELIG_F where ptip_id = :ptip_id';
405:
406: l_Bind_Value := p_ptip_id;
407:
408: Elsif p_plip_id is NOT NULL then

Line 410: l_sql := 'select distinct prtn_elig_id from BEN_PRTN_ELIG_F where plip_id = :plip_id';

406: l_Bind_Value := p_ptip_id;
407:
408: Elsif p_plip_id is NOT NULL then
409:
410: l_sql := 'select distinct prtn_elig_id from BEN_PRTN_ELIG_F where plip_id = :plip_id';
411:
412: l_Bind_Value := p_plip_id;
413:
414: Elsif p_pl_id is NOT NULL then

Line 416: l_sql := 'select distinct prtn_elig_id from BEN_PRTN_ELIG_F where pl_id = :pl_id';

412: l_Bind_Value := p_plip_id;
413:
414: Elsif p_pl_id is NOT NULL then
415:
416: l_sql := 'select distinct prtn_elig_id from BEN_PRTN_ELIG_F where pl_id = :pl_id';
417:
418: l_Bind_Value := p_pl_id;
419:
420: Elsif P_oipl_id is NOT NULL then

Line 422: l_sql := 'select distinct prtn_elig_id from BEN_PRTN_ELIG_F where Oipl_Id = :Oipl_Id';

418: l_Bind_Value := p_pl_id;
419:
420: Elsif P_oipl_id is NOT NULL then
421:
422: l_sql := 'select distinct prtn_elig_id from BEN_PRTN_ELIG_F where Oipl_Id = :Oipl_Id';
423:
424: l_Bind_Value := P_oipl_id;
425: Else
426:

Line 483: p_parent_entity_result_id => null, -- Hide BEN_PRTN_ELIG_F for HGrid

479: p_copy_entity_result_id => l_copy_entity_result_id,
480: p_copy_entity_txn_id => p_copy_entity_txn_id,
481: p_result_type_cd => l_result_type_cd,
482: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
483: p_parent_entity_result_id => null, -- Hide BEN_PRTN_ELIG_F for HGrid
484: p_number_of_copies => l_number_of_copies,
485: p_table_route_id => l_table_route_id,
486: P_TABLE_ALIAS => 'EPA',
487: p_information1 => l_epa_rec.prtn_elig_id,

Line 902: -- END OF BEN_PRTN_ELIG_F ----------------------

898: ---------------------------------------------------------------
899: hr_utility.set_location('end of pe',10);
900: end loop;
901: ---------------------------------------------------------------
902: -- END OF BEN_PRTN_ELIG_F ----------------------
903: ---------------------------------------------------------------
904: hr_utility.set_location('out of routine',10);
905: end ;
906: --