APPS.BEN_PLAN_DESIGN_TXNS_API dependencies on BEN_PL_F

Line 388: where tr.table_alias = 'PLN' and where_clause = 'BEN_PL_F' ;

384: --
385: cursor c_pln_tr is
386: select table_route_id
387: from pqh_table_route tr
388: where tr.table_alias = 'PLN' and where_clause = 'BEN_PL_F' ;
389: --
390: l_table_route_id number ;
391: l_ret varchar2(1000);
392: --

Line 999: and trt.where_clause = 'BEN_PL_F'

995: pqh_table_route trt
996: where cer.information1 = c_pl_id
997: and cer.copy_entity_txn_id = c_copy_entity_txn_id
998: and cer.table_route_id = trt.table_route_id
999: and trt.where_clause = 'BEN_PL_F'
1000: and trt.from_clause = 'OAB'
1001: and exists ( select /*+ INDEX ( cer1, ben_copy_entity_results_fk1) */ null from
1002: ben_copy_entity_results cer1
1003: where cer1.mirror_src_entity_result_id = cer.copy_entity_result_id

Line 1062: l_table_name := 'BEN_PL_F';

1058: if p_information8 is not null then -- Top level record
1059: if p_information8 = 'PGM' then
1060: l_table_name := 'BEN_PGM_F';
1061: else
1062: l_table_name := 'BEN_PL_F';
1063: end if;
1064:
1065: for r_non_dsply_recs in c_non_dsply_recs
1066: (p_information1,

Line 1431: ben_pl_f bp,

1427: select
1428: bp.name name,
1429: bp.pl_id id
1430: FROM
1431: ben_pl_f bp,
1432: ben_pl_typ_f bpt
1433: WHERE
1434: bp.pl_id = bp.group_pl_id
1435: and bp.name = cv_name

Line 2001: elsif (l_table_route_name = 'BEN_PL_F') then

1997: , p_target_id2 =>l_ret.information180
1998: );
1999: --
2000: end loop;
2001: elsif (l_table_route_name = 'BEN_PL_F') then
2002: --
2003: for l_ret in c_source_data (p_table_route_id)
2004: loop
2005: --

Line 2255: --'BEN_PL_F',

2251: select table_route_id
2252: from pqh_table_route
2253: where table_route_id = p_table_route_id
2254: and where_clause in('BEN_HRS_WKD_IN_PERD_FCTR',
2255: --'BEN_PL_F',
2256: --'BEN_OPT_F',
2257: --'BEN_POPL_ORG_F',
2258: 'BEN_COMP_LVL_FCTR',
2259: 'BEN_ENRT_PERD'); -- Bug No 4498668