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_PLAN_DESIGN_TXNS_API dependencies on PQH_TABLE_ROUTE

Line 387: from pqh_table_route tr

383: l_legislation_code varchar2(150);
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);

Line 911: from pqh_table_route

907: ,p_table_route_id in number) is
908:
909: cursor c_table_name is
910: select where_clause
911: from pqh_table_route
912: where table_route_id = p_table_route_id;
913:
914: l_table_name pqh_table_route.where_clause%type;
915: begin

Line 914: l_table_name pqh_table_route.where_clause%type;

910: select where_clause
911: from pqh_table_route
912: where table_route_id = p_table_route_id;
913:
914: l_table_name pqh_table_route.where_clause%type;
915: begin
916:
917: open c_table_name;
918: fetch c_table_name into l_table_name;

Line 980: pqh_table_route trt

976: --
977: cursor c_child_exists_for_pgm(c_pgm_id varchar2,c_copy_entity_txn_id number ) is
978: select null
979: from ben_copy_entity_results cer,
980: pqh_table_route trt
981: where cer.information1 = c_pgm_id
982: and cer.copy_entity_txn_id = c_copy_entity_txn_id
983: and cer.table_route_id = trt.table_route_id
984: and trt.where_clause = 'BEN_PGM_F'

Line 995: pqh_table_route trt

991: --
992: cursor c_child_exists_for_pl(c_pl_id varchar2,c_copy_entity_txn_id number ) is
993: select null
994: from ben_copy_entity_results cer,
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'

Line 1021: pqh_table_route trt

1017: c_table_name in varchar2,
1018: c_copy_entity_txn_id in number) is
1019: select cer.copy_entity_result_id,cer.object_version_number
1020: from ben_copy_entity_results cer,
1021: pqh_table_route trt
1022: where cer.information1 = c_information1
1023: and trt.where_clause = c_table_name
1024: and cer.copy_entity_txn_id = c_copy_entity_txn_id
1025: and cer.table_route_id = trt.table_route_id

Line 1028: l_table_name pqh_table_route.where_clause%type;

1024: and cer.copy_entity_txn_id = c_copy_entity_txn_id
1025: and cer.table_route_id = trt.table_route_id
1026: and cer.result_type_cd <> 'DISPLAY' ;
1027:
1028: l_table_name pqh_table_route.where_clause%type;
1029:
1030: begin
1031: --
1032: hr_utility.set_location(' Entering :'||l_proc, 10);

Line 1285: from pqh_table_route

1281: (information180 is not null and information176 is null));
1282: --
1283: cursor c_table_name (p_table_route_id number)is
1284: select WHERE_CLAUSE
1285: from pqh_table_route
1286: where table_route_id = p_table_route_id;
1287:
1288: --
1289: cursor c_AssignmentSetIdNameLovVO(p_source_name1 varchar2) is

Line 1561: l_table_route_name pqh_table_route.WHERE_CLAUSE%type;

1557: between Date_from and nvl(Date_to, trunc(cv_effective_date) )
1558: and business_group_id + 0 = p_target_business_group_id
1559: and gra.name = p_source_name1;
1560: --
1561: l_table_route_name pqh_table_route.WHERE_CLAUSE%type;
1562: --
1563: l_effective_date1 date;
1564: l_effective_date2 date;
1565: begin

Line 2252: from pqh_table_route

2248:
2249: --
2250: cursor c_mapping_required_table(p_table_route_id number)is
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',

Line 2263: from pqh_table_route

2259: 'BEN_ENRT_PERD'); -- Bug No 4498668
2260: --
2261: cursor c_table_name (p_table_route_id number) is
2262: select display_name
2263: from pqh_table_route
2264: where table_route_id = p_table_route_id;
2265:
2266: l_table_name pqh_table_route.display_name%type;
2267: begin

Line 2266: l_table_name pqh_table_route.display_name%type;

2262: select display_name
2263: from pqh_table_route
2264: where table_route_id = p_table_route_id;
2265:
2266: l_table_name pqh_table_route.display_name%type;
2267: begin
2268: if(p_mapping_info = 'CompletedInfo') then
2269: --
2270: open is_maping_completed(p_entity_txn_id ,p_table_route_id );

Line 2468: from pqh_table_route_vl trt

2464:
2465: cursor c_table_route is
2466: select table_alias
2467: ,display_name
2468: from pqh_table_route_vl trt
2469: where trt.table_alias in
2470: ('PGM', 'PLN', 'OPT', 'PTP', 'EAT'
2471: ,'BNB', 'CLF', 'HWF', 'AGF', 'LSF'
2472: ,'PFF', 'CLA', 'REG', 'BNR', 'BPP'

Line 2515: -- pqh_table_route tre

2511: cursor c_items_to_ignore_count(c_copy_entity_txn_id in number) is
2512: select count(1) from (
2513: select distinct information1,information2,information3,cer.table_route_id
2514: from ben_copy_entity_results cer
2515: -- pqh_table_route tre
2516: where copy_entity_txn_id = c_copy_entity_txn_id
2517: and number_of_copies = 1
2518: and cer.table_alias = 'EAT'
2519: -- and cer.table_route_id = tre.table_route_id

Line 2528: l_pgm_label pqh_table_route_vl.display_name%type;

2524: l_reused_count number;
2525: l_not_copied_count number;
2526: l_items_to_ignore_count number;
2527:
2528: l_pgm_label pqh_table_route_vl.display_name%type;
2529: l_pln_label pqh_table_route_vl.display_name%type;
2530: l_opt_label pqh_table_route_vl.display_name%type;
2531: l_ptp_label pqh_table_route_vl.display_name%type;
2532: l_eat_label pqh_table_route_vl.display_name%type;

Line 2529: l_pln_label pqh_table_route_vl.display_name%type;

2525: l_not_copied_count number;
2526: l_items_to_ignore_count number;
2527:
2528: l_pgm_label pqh_table_route_vl.display_name%type;
2529: l_pln_label pqh_table_route_vl.display_name%type;
2530: l_opt_label pqh_table_route_vl.display_name%type;
2531: l_ptp_label pqh_table_route_vl.display_name%type;
2532: l_eat_label pqh_table_route_vl.display_name%type;
2533: l_bnb_label pqh_table_route_vl.display_name%type;

Line 2530: l_opt_label pqh_table_route_vl.display_name%type;

2526: l_items_to_ignore_count number;
2527:
2528: l_pgm_label pqh_table_route_vl.display_name%type;
2529: l_pln_label pqh_table_route_vl.display_name%type;
2530: l_opt_label pqh_table_route_vl.display_name%type;
2531: l_ptp_label pqh_table_route_vl.display_name%type;
2532: l_eat_label pqh_table_route_vl.display_name%type;
2533: l_bnb_label pqh_table_route_vl.display_name%type;
2534: l_clf_label pqh_table_route_vl.display_name%type;

Line 2531: l_ptp_label pqh_table_route_vl.display_name%type;

2527:
2528: l_pgm_label pqh_table_route_vl.display_name%type;
2529: l_pln_label pqh_table_route_vl.display_name%type;
2530: l_opt_label pqh_table_route_vl.display_name%type;
2531: l_ptp_label pqh_table_route_vl.display_name%type;
2532: l_eat_label pqh_table_route_vl.display_name%type;
2533: l_bnb_label pqh_table_route_vl.display_name%type;
2534: l_clf_label pqh_table_route_vl.display_name%type;
2535: l_hwf_label pqh_table_route_vl.display_name%type;

Line 2532: l_eat_label pqh_table_route_vl.display_name%type;

2528: l_pgm_label pqh_table_route_vl.display_name%type;
2529: l_pln_label pqh_table_route_vl.display_name%type;
2530: l_opt_label pqh_table_route_vl.display_name%type;
2531: l_ptp_label pqh_table_route_vl.display_name%type;
2532: l_eat_label pqh_table_route_vl.display_name%type;
2533: l_bnb_label pqh_table_route_vl.display_name%type;
2534: l_clf_label pqh_table_route_vl.display_name%type;
2535: l_hwf_label pqh_table_route_vl.display_name%type;
2536: l_agf_label pqh_table_route_vl.display_name%type;

Line 2533: l_bnb_label pqh_table_route_vl.display_name%type;

2529: l_pln_label pqh_table_route_vl.display_name%type;
2530: l_opt_label pqh_table_route_vl.display_name%type;
2531: l_ptp_label pqh_table_route_vl.display_name%type;
2532: l_eat_label pqh_table_route_vl.display_name%type;
2533: l_bnb_label pqh_table_route_vl.display_name%type;
2534: l_clf_label pqh_table_route_vl.display_name%type;
2535: l_hwf_label pqh_table_route_vl.display_name%type;
2536: l_agf_label pqh_table_route_vl.display_name%type;
2537: l_lsf_label pqh_table_route_vl.display_name%type;

Line 2534: l_clf_label pqh_table_route_vl.display_name%type;

2530: l_opt_label pqh_table_route_vl.display_name%type;
2531: l_ptp_label pqh_table_route_vl.display_name%type;
2532: l_eat_label pqh_table_route_vl.display_name%type;
2533: l_bnb_label pqh_table_route_vl.display_name%type;
2534: l_clf_label pqh_table_route_vl.display_name%type;
2535: l_hwf_label pqh_table_route_vl.display_name%type;
2536: l_agf_label pqh_table_route_vl.display_name%type;
2537: l_lsf_label pqh_table_route_vl.display_name%type;
2538: l_pff_label pqh_table_route_vl.display_name%type;

Line 2535: l_hwf_label pqh_table_route_vl.display_name%type;

2531: l_ptp_label pqh_table_route_vl.display_name%type;
2532: l_eat_label pqh_table_route_vl.display_name%type;
2533: l_bnb_label pqh_table_route_vl.display_name%type;
2534: l_clf_label pqh_table_route_vl.display_name%type;
2535: l_hwf_label pqh_table_route_vl.display_name%type;
2536: l_agf_label pqh_table_route_vl.display_name%type;
2537: l_lsf_label pqh_table_route_vl.display_name%type;
2538: l_pff_label pqh_table_route_vl.display_name%type;
2539: l_cla_label pqh_table_route_vl.display_name%type;

Line 2536: l_agf_label pqh_table_route_vl.display_name%type;

2532: l_eat_label pqh_table_route_vl.display_name%type;
2533: l_bnb_label pqh_table_route_vl.display_name%type;
2534: l_clf_label pqh_table_route_vl.display_name%type;
2535: l_hwf_label pqh_table_route_vl.display_name%type;
2536: l_agf_label pqh_table_route_vl.display_name%type;
2537: l_lsf_label pqh_table_route_vl.display_name%type;
2538: l_pff_label pqh_table_route_vl.display_name%type;
2539: l_cla_label pqh_table_route_vl.display_name%type;
2540: l_reg_label pqh_table_route_vl.display_name%type;

Line 2537: l_lsf_label pqh_table_route_vl.display_name%type;

2533: l_bnb_label pqh_table_route_vl.display_name%type;
2534: l_clf_label pqh_table_route_vl.display_name%type;
2535: l_hwf_label pqh_table_route_vl.display_name%type;
2536: l_agf_label pqh_table_route_vl.display_name%type;
2537: l_lsf_label pqh_table_route_vl.display_name%type;
2538: l_pff_label pqh_table_route_vl.display_name%type;
2539: l_cla_label pqh_table_route_vl.display_name%type;
2540: l_reg_label pqh_table_route_vl.display_name%type;
2541: l_bnr_label pqh_table_route_vl.display_name%type;

Line 2538: l_pff_label pqh_table_route_vl.display_name%type;

2534: l_clf_label pqh_table_route_vl.display_name%type;
2535: l_hwf_label pqh_table_route_vl.display_name%type;
2536: l_agf_label pqh_table_route_vl.display_name%type;
2537: l_lsf_label pqh_table_route_vl.display_name%type;
2538: l_pff_label pqh_table_route_vl.display_name%type;
2539: l_cla_label pqh_table_route_vl.display_name%type;
2540: l_reg_label pqh_table_route_vl.display_name%type;
2541: l_bnr_label pqh_table_route_vl.display_name%type;
2542: l_bpp_label pqh_table_route_vl.display_name%type;

Line 2539: l_cla_label pqh_table_route_vl.display_name%type;

2535: l_hwf_label pqh_table_route_vl.display_name%type;
2536: l_agf_label pqh_table_route_vl.display_name%type;
2537: l_lsf_label pqh_table_route_vl.display_name%type;
2538: l_pff_label pqh_table_route_vl.display_name%type;
2539: l_cla_label pqh_table_route_vl.display_name%type;
2540: l_reg_label pqh_table_route_vl.display_name%type;
2541: l_bnr_label pqh_table_route_vl.display_name%type;
2542: l_bpp_label pqh_table_route_vl.display_name%type;
2543: l_ler_label pqh_table_route_vl.display_name%type;

Line 2540: l_reg_label pqh_table_route_vl.display_name%type;

2536: l_agf_label pqh_table_route_vl.display_name%type;
2537: l_lsf_label pqh_table_route_vl.display_name%type;
2538: l_pff_label pqh_table_route_vl.display_name%type;
2539: l_cla_label pqh_table_route_vl.display_name%type;
2540: l_reg_label pqh_table_route_vl.display_name%type;
2541: l_bnr_label pqh_table_route_vl.display_name%type;
2542: l_bpp_label pqh_table_route_vl.display_name%type;
2543: l_ler_label pqh_table_route_vl.display_name%type;
2544: l_psl_label pqh_table_route_vl.display_name%type;

Line 2541: l_bnr_label pqh_table_route_vl.display_name%type;

2537: l_lsf_label pqh_table_route_vl.display_name%type;
2538: l_pff_label pqh_table_route_vl.display_name%type;
2539: l_cla_label pqh_table_route_vl.display_name%type;
2540: l_reg_label pqh_table_route_vl.display_name%type;
2541: l_bnr_label pqh_table_route_vl.display_name%type;
2542: l_bpp_label pqh_table_route_vl.display_name%type;
2543: l_ler_label pqh_table_route_vl.display_name%type;
2544: l_psl_label pqh_table_route_vl.display_name%type;
2545: l_elp_label pqh_table_route_vl.display_name%type;

Line 2542: l_bpp_label pqh_table_route_vl.display_name%type;

2538: l_pff_label pqh_table_route_vl.display_name%type;
2539: l_cla_label pqh_table_route_vl.display_name%type;
2540: l_reg_label pqh_table_route_vl.display_name%type;
2541: l_bnr_label pqh_table_route_vl.display_name%type;
2542: l_bpp_label pqh_table_route_vl.display_name%type;
2543: l_ler_label pqh_table_route_vl.display_name%type;
2544: l_psl_label pqh_table_route_vl.display_name%type;
2545: l_elp_label pqh_table_route_vl.display_name%type;
2546: l_dce_label pqh_table_route_vl.display_name%type;

Line 2543: l_ler_label pqh_table_route_vl.display_name%type;

2539: l_cla_label pqh_table_route_vl.display_name%type;
2540: l_reg_label pqh_table_route_vl.display_name%type;
2541: l_bnr_label pqh_table_route_vl.display_name%type;
2542: l_bpp_label pqh_table_route_vl.display_name%type;
2543: l_ler_label pqh_table_route_vl.display_name%type;
2544: l_psl_label pqh_table_route_vl.display_name%type;
2545: l_elp_label pqh_table_route_vl.display_name%type;
2546: l_dce_label pqh_table_route_vl.display_name%type;
2547: l_gos_label pqh_table_route_vl.display_name%type;

Line 2544: l_psl_label pqh_table_route_vl.display_name%type;

2540: l_reg_label pqh_table_route_vl.display_name%type;
2541: l_bnr_label pqh_table_route_vl.display_name%type;
2542: l_bpp_label pqh_table_route_vl.display_name%type;
2543: l_ler_label pqh_table_route_vl.display_name%type;
2544: l_psl_label pqh_table_route_vl.display_name%type;
2545: l_elp_label pqh_table_route_vl.display_name%type;
2546: l_dce_label pqh_table_route_vl.display_name%type;
2547: l_gos_label pqh_table_route_vl.display_name%type;
2548: l_bng_label pqh_table_route_vl.display_name%type;

Line 2545: l_elp_label pqh_table_route_vl.display_name%type;

2541: l_bnr_label pqh_table_route_vl.display_name%type;
2542: l_bpp_label pqh_table_route_vl.display_name%type;
2543: l_ler_label pqh_table_route_vl.display_name%type;
2544: l_psl_label pqh_table_route_vl.display_name%type;
2545: l_elp_label pqh_table_route_vl.display_name%type;
2546: l_dce_label pqh_table_route_vl.display_name%type;
2547: l_gos_label pqh_table_route_vl.display_name%type;
2548: l_bng_label pqh_table_route_vl.display_name%type;
2549: l_pdl_label pqh_table_route_vl.display_name%type;

Line 2546: l_dce_label pqh_table_route_vl.display_name%type;

2542: l_bpp_label pqh_table_route_vl.display_name%type;
2543: l_ler_label pqh_table_route_vl.display_name%type;
2544: l_psl_label pqh_table_route_vl.display_name%type;
2545: l_elp_label pqh_table_route_vl.display_name%type;
2546: l_dce_label pqh_table_route_vl.display_name%type;
2547: l_gos_label pqh_table_route_vl.display_name%type;
2548: l_bng_label pqh_table_route_vl.display_name%type;
2549: l_pdl_label pqh_table_route_vl.display_name%type;
2550: l_sva_label pqh_table_route_vl.display_name%type;

Line 2547: l_gos_label pqh_table_route_vl.display_name%type;

2543: l_ler_label pqh_table_route_vl.display_name%type;
2544: l_psl_label pqh_table_route_vl.display_name%type;
2545: l_elp_label pqh_table_route_vl.display_name%type;
2546: l_dce_label pqh_table_route_vl.display_name%type;
2547: l_gos_label pqh_table_route_vl.display_name%type;
2548: l_bng_label pqh_table_route_vl.display_name%type;
2549: l_pdl_label pqh_table_route_vl.display_name%type;
2550: l_sva_label pqh_table_route_vl.display_name%type;
2551: l_cpl_label pqh_table_route_vl.display_name%type;

Line 2548: l_bng_label pqh_table_route_vl.display_name%type;

2544: l_psl_label pqh_table_route_vl.display_name%type;
2545: l_elp_label pqh_table_route_vl.display_name%type;
2546: l_dce_label pqh_table_route_vl.display_name%type;
2547: l_gos_label pqh_table_route_vl.display_name%type;
2548: l_bng_label pqh_table_route_vl.display_name%type;
2549: l_pdl_label pqh_table_route_vl.display_name%type;
2550: l_sva_label pqh_table_route_vl.display_name%type;
2551: l_cpl_label pqh_table_route_vl.display_name%type;
2552: l_cbp_label pqh_table_route_vl.display_name%type;

Line 2549: l_pdl_label pqh_table_route_vl.display_name%type;

2545: l_elp_label pqh_table_route_vl.display_name%type;
2546: l_dce_label pqh_table_route_vl.display_name%type;
2547: l_gos_label pqh_table_route_vl.display_name%type;
2548: l_bng_label pqh_table_route_vl.display_name%type;
2549: l_pdl_label pqh_table_route_vl.display_name%type;
2550: l_sva_label pqh_table_route_vl.display_name%type;
2551: l_cpl_label pqh_table_route_vl.display_name%type;
2552: l_cbp_label pqh_table_route_vl.display_name%type;
2553: l_cpt_label pqh_table_route_vl.display_name%type;

Line 2550: l_sva_label pqh_table_route_vl.display_name%type;

2546: l_dce_label pqh_table_route_vl.display_name%type;
2547: l_gos_label pqh_table_route_vl.display_name%type;
2548: l_bng_label pqh_table_route_vl.display_name%type;
2549: l_pdl_label pqh_table_route_vl.display_name%type;
2550: l_sva_label pqh_table_route_vl.display_name%type;
2551: l_cpl_label pqh_table_route_vl.display_name%type;
2552: l_cbp_label pqh_table_route_vl.display_name%type;
2553: l_cpt_label pqh_table_route_vl.display_name%type;
2554: l_fff_label pqh_table_route_vl.display_name%type;

Line 2551: l_cpl_label pqh_table_route_vl.display_name%type;

2547: l_gos_label pqh_table_route_vl.display_name%type;
2548: l_bng_label pqh_table_route_vl.display_name%type;
2549: l_pdl_label pqh_table_route_vl.display_name%type;
2550: l_sva_label pqh_table_route_vl.display_name%type;
2551: l_cpl_label pqh_table_route_vl.display_name%type;
2552: l_cbp_label pqh_table_route_vl.display_name%type;
2553: l_cpt_label pqh_table_route_vl.display_name%type;
2554: l_fff_label pqh_table_route_vl.display_name%type;
2555: l_abr_label pqh_table_route_vl.display_name%type;

Line 2552: l_cbp_label pqh_table_route_vl.display_name%type;

2548: l_bng_label pqh_table_route_vl.display_name%type;
2549: l_pdl_label pqh_table_route_vl.display_name%type;
2550: l_sva_label pqh_table_route_vl.display_name%type;
2551: l_cpl_label pqh_table_route_vl.display_name%type;
2552: l_cbp_label pqh_table_route_vl.display_name%type;
2553: l_cpt_label pqh_table_route_vl.display_name%type;
2554: l_fff_label pqh_table_route_vl.display_name%type;
2555: l_abr_label pqh_table_route_vl.display_name%type;
2556: l_apr_label pqh_table_route_vl.display_name%type;

Line 2553: l_cpt_label pqh_table_route_vl.display_name%type;

2549: l_pdl_label pqh_table_route_vl.display_name%type;
2550: l_sva_label pqh_table_route_vl.display_name%type;
2551: l_cpl_label pqh_table_route_vl.display_name%type;
2552: l_cbp_label pqh_table_route_vl.display_name%type;
2553: l_cpt_label pqh_table_route_vl.display_name%type;
2554: l_fff_label pqh_table_route_vl.display_name%type;
2555: l_abr_label pqh_table_route_vl.display_name%type;
2556: l_apr_label pqh_table_route_vl.display_name%type;
2557: l_vpf_label pqh_table_route_vl.display_name%type;

Line 2554: l_fff_label pqh_table_route_vl.display_name%type;

2550: l_sva_label pqh_table_route_vl.display_name%type;
2551: l_cpl_label pqh_table_route_vl.display_name%type;
2552: l_cbp_label pqh_table_route_vl.display_name%type;
2553: l_cpt_label pqh_table_route_vl.display_name%type;
2554: l_fff_label pqh_table_route_vl.display_name%type;
2555: l_abr_label pqh_table_route_vl.display_name%type;
2556: l_apr_label pqh_table_route_vl.display_name%type;
2557: l_vpf_label pqh_table_route_vl.display_name%type;
2558: l_ccm_label pqh_table_route_vl.display_name%type;

Line 2555: l_abr_label pqh_table_route_vl.display_name%type;

2551: l_cpl_label pqh_table_route_vl.display_name%type;
2552: l_cbp_label pqh_table_route_vl.display_name%type;
2553: l_cpt_label pqh_table_route_vl.display_name%type;
2554: l_fff_label pqh_table_route_vl.display_name%type;
2555: l_abr_label pqh_table_route_vl.display_name%type;
2556: l_apr_label pqh_table_route_vl.display_name%type;
2557: l_vpf_label pqh_table_route_vl.display_name%type;
2558: l_ccm_label pqh_table_route_vl.display_name%type;
2559: l_acp_label pqh_table_route_vl.display_name%type;

Line 2556: l_apr_label pqh_table_route_vl.display_name%type;

2552: l_cbp_label pqh_table_route_vl.display_name%type;
2553: l_cpt_label pqh_table_route_vl.display_name%type;
2554: l_fff_label pqh_table_route_vl.display_name%type;
2555: l_abr_label pqh_table_route_vl.display_name%type;
2556: l_apr_label pqh_table_route_vl.display_name%type;
2557: l_vpf_label pqh_table_route_vl.display_name%type;
2558: l_ccm_label pqh_table_route_vl.display_name%type;
2559: l_acp_label pqh_table_route_vl.display_name%type;
2560: l_egl_label pqh_table_route_vl.display_name%type; /* Bug 4169120 Rate By Criteria */

Line 2557: l_vpf_label pqh_table_route_vl.display_name%type;

2553: l_cpt_label pqh_table_route_vl.display_name%type;
2554: l_fff_label pqh_table_route_vl.display_name%type;
2555: l_abr_label pqh_table_route_vl.display_name%type;
2556: l_apr_label pqh_table_route_vl.display_name%type;
2557: l_vpf_label pqh_table_route_vl.display_name%type;
2558: l_ccm_label pqh_table_route_vl.display_name%type;
2559: l_acp_label pqh_table_route_vl.display_name%type;
2560: l_egl_label pqh_table_route_vl.display_name%type; /* Bug 4169120 Rate By Criteria */
2561:

Line 2558: l_ccm_label pqh_table_route_vl.display_name%type;

2554: l_fff_label pqh_table_route_vl.display_name%type;
2555: l_abr_label pqh_table_route_vl.display_name%type;
2556: l_apr_label pqh_table_route_vl.display_name%type;
2557: l_vpf_label pqh_table_route_vl.display_name%type;
2558: l_ccm_label pqh_table_route_vl.display_name%type;
2559: l_acp_label pqh_table_route_vl.display_name%type;
2560: l_egl_label pqh_table_route_vl.display_name%type; /* Bug 4169120 Rate By Criteria */
2561:
2562: l_selected_for_copy_lbl fnd_new_messages.message_text%type;

Line 2559: l_acp_label pqh_table_route_vl.display_name%type;

2555: l_abr_label pqh_table_route_vl.display_name%type;
2556: l_apr_label pqh_table_route_vl.display_name%type;
2557: l_vpf_label pqh_table_route_vl.display_name%type;
2558: l_ccm_label pqh_table_route_vl.display_name%type;
2559: l_acp_label pqh_table_route_vl.display_name%type;
2560: l_egl_label pqh_table_route_vl.display_name%type; /* Bug 4169120 Rate By Criteria */
2561:
2562: l_selected_for_copy_lbl fnd_new_messages.message_text%type;
2563: l_created_objects_lbl fnd_new_messages.message_text%type;

Line 2560: l_egl_label pqh_table_route_vl.display_name%type; /* Bug 4169120 Rate By Criteria */

2556: l_apr_label pqh_table_route_vl.display_name%type;
2557: l_vpf_label pqh_table_route_vl.display_name%type;
2558: l_ccm_label pqh_table_route_vl.display_name%type;
2559: l_acp_label pqh_table_route_vl.display_name%type;
2560: l_egl_label pqh_table_route_vl.display_name%type; /* Bug 4169120 Rate By Criteria */
2561:
2562: l_selected_for_copy_lbl fnd_new_messages.message_text%type;
2563: l_created_objects_lbl fnd_new_messages.message_text%type;
2564: l_reused_objects_lbl fnd_new_messages.message_text%type;

Line 5165: from pqh_table_route

5161: from ben_copy_entity_results
5162: where copy_entity_txn_id = p_copy_entity_txn_id
5163: and information174 is not null
5164: and table_route_id in (select table_route_id
5165: from pqh_table_route
5166: where where_clause in('BEN_HRS_WKD_IN_PERD_FCTR',
5167: -- 'BEN_POPL_ORG_F',
5168: 'BEN_COMP_LVL_FCTR',
5169: 'BEN_ENRT_PERD')); -- Bug No 4498668

Line 5173: from pqh_table_route

5169: 'BEN_ENRT_PERD')); -- Bug No 4498668
5170: --
5171: cursor c_table_name (p_table_route_id number) is
5172: select display_name
5173: from pqh_table_route
5174: where table_route_id = p_table_route_id;
5175:
5176: l_table_name pqh_table_route.display_name%type;
5177: --

Line 5176: l_table_name pqh_table_route.display_name%type;

5172: select display_name
5173: from pqh_table_route
5174: where table_route_id = p_table_route_id;
5175:
5176: l_table_name pqh_table_route.display_name%type;
5177: --
5178: begin
5179: p_required_mapping := ' ';
5180: --

Line 5362: from pqh_table_route

5358: procedure write_txn_table_route(p_copy_entity_txn_id in number)
5359: is
5360: pragma AUTONOMOUS_TRANSACTION;
5361: cursor tr is select table_route_id,display_name,table_alias
5362: from pqh_table_route
5363: where from_clause ='OAB'
5364: and table_alias in ( select distinct table_alias from ben_copy_entity_results
5365: where copy_entity_txn_id = p_copy_entity_txn_id
5366: and table_route_id is null);