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_PD_RATE_AND_CVG_MODULE dependencies on BEN_ACTY_BASE_RT_F

Line 58: -- START OF BEN_ACTY_BASE_RT_F ----------------------

54: -- trt.from_clause = 'OAB'
55: -- and trt.where_clause = upper(c_parent_table_name) ;
56: ---
57: ---------------------------------------------------------------
58: -- START OF BEN_ACTY_BASE_RT_F ----------------------
59: ---------------------------------------------------------------
60: cursor c_abr_from_parent(c_pgm_id number,
61: c_ptip_id number,
62: c_plip_id number,

Line 74: from BEN_ACTY_BASE_RT_F

70: c_opt_id number
71: --
72: ) is
73: select distinct acty_base_rt_id
74: from BEN_ACTY_BASE_RT_F
75: where (c_pgm_id is not null and c_pgm_id = pgm_id) or
76: (c_ptip_id is not null and c_ptip_id = ptip_id) or
77: (c_plip_id is not null and c_plip_id = plip_id) or
78: (c_pl_id is not null and c_pl_id = pl_id ) or

Line 91: from BEN_ACTY_BASE_RT_F abr

87: --
88: cursor c_abr(c_acty_base_rt_id number,c_mirror_src_entity_result_id number,
89: c_table_alias varchar2) is
90: select abr.*
91: from BEN_ACTY_BASE_RT_F abr
92: where abr.acty_base_rt_id = c_acty_base_rt_id
93: -- and abr.business_group_id = p_business_group_id
94: and not exists (
95: select /* */ null

Line 102: -- and trt.where_clause = 'BEN_ACTY_BASE_RT_F'

98: where copy_entity_txn_id = p_copy_entity_txn_id
99: -- and trt.table_route_id = cpe.table_route_id
100: and ( -- c_mirror_src_entity_result_id is null or
101: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
102: -- and trt.where_clause = 'BEN_ACTY_BASE_RT_F'
103: and cpe.table_alias = c_table_alias
104: and information1 = c_acty_base_rt_id
105: -- and information4 = abr.business_group_id
106: and information2 = abr.effective_start_date

Line 177: l_abr_acty_base_rt_esd ben_acty_base_rt_f.effective_start_date%type;

173: l_mapping_column_name2 pqh_attributes.attribute_name%type;
174:
175: l_input_value_name pay_input_values_f.name%type;
176:
177: l_abr_acty_base_rt_esd ben_acty_base_rt_f.effective_start_date%type;
178:
179: l_element_type_start_date pay_element_types_f.effective_start_date%type;
180: l_input_value_start_date pay_input_values_f.effective_start_date%type;
181:

Line 183: -- END OF BEN_ACTY_BASE_RT_F ----------------------

179: l_element_type_start_date pay_element_types_f.effective_start_date%type;
180: l_input_value_start_date pay_input_values_f.effective_start_date%type;
181:
182: ---------------------------------------------------------------
183: -- END OF BEN_ACTY_BASE_RT_F ----------------------
184: ---------------------------------------------------------------
185: ---------------------------------------------------------------
186: -- START OF BEN_ACTY_RT_PYMT_SCHED_F ----------------------
187: ---------------------------------------------------------------

Line 253: from BEN_ACTY_BASE_RT_F

249: -- START OF BEN_ACTL_PREM_F ----------------------
250: ---------------------------------------------------------------
251: cursor c_apr_from_parent(c_ACTY_BASE_RT_ID number) is
252: select distinct actl_prem_id
253: from BEN_ACTY_BASE_RT_F
254: where ACTY_BASE_RT_ID = c_ACTY_BASE_RT_ID ;
255: --
256: cursor c_apr(c_actl_prem_id number,c_mirror_src_entity_result_id number,
257: c_table_alias varchar2 ) is

Line 556: l_parent_rec Ben_Acty_base_rt_F%ROWTYPE;

552: l_number_of_copies number(15);
553:
554: TYPE rt_ref_csr_typ IS REF CURSOR;
555: c_parent_rec rt_ref_csr_typ;
556: l_parent_rec Ben_Acty_base_rt_F%ROWTYPE;
557: l_parent_acty_base_rt_id number;
558: l_Sql Varchar2(2000) := NULL;
559: l_Bind_Value Ben_Pgm_F.Pgm_Id%TYPE := NULL;
560:

Line 564: -- START OF BEN_ACTY_BASE_RT_F ----------------------

560:
561: begin
562: l_number_of_copies := p_number_of_copies ;
563: ---------------------------------------------------------------
564: -- START OF BEN_ACTY_BASE_RT_F ----------------------
565: ---------------------------------------------------------------
566: If p_pgm_id is NOT NULL then
567:
568: l_sql := 'select distinct acty_base_rt_id

Line 569: from BEN_ACTY_BASE_RT_F

565: ---------------------------------------------------------------
566: If p_pgm_id is NOT NULL then
567:
568: l_sql := 'select distinct acty_base_rt_id
569: from BEN_ACTY_BASE_RT_F
570: where pgm_id = :Pgm_Id';
571:
572: l_Bind_Value := p_Pgm_Id;
573:

Line 577: from BEN_ACTY_BASE_RT_F

573:
574: Elsif p_ptip_id is NOT NULL then
575:
576: l_sql := 'select distinct acty_base_rt_id
577: from BEN_ACTY_BASE_RT_F
578: where ptip_id = :Ptip_id';
579:
580: l_Bind_Value := p_Ptip_id;
581:

Line 585: from BEN_ACTY_BASE_RT_F

581:
582: Elsif p_plip_id is NOT NULL then
583:
584: l_Sql := 'select distinct acty_base_rt_id
585: from BEN_ACTY_BASE_RT_F
586: where plip_id = :plip_id';
587:
588: l_Bind_Value := p_plip_id;
589:

Line 593: from BEN_ACTY_BASE_RT_F

589:
590: Elsif p_pl_id is NOT NULL then
591:
592: l_sql := 'select distinct acty_base_rt_id
593: from BEN_ACTY_BASE_RT_F
594: where pl_id = :pl_Id';
595:
596: l_Bind_Value := p_pl_Id;
597:

Line 601: from BEN_ACTY_BASE_RT_F

597:
598: Elsif p_oipl_id is NOT NULL then
599:
600: l_sql := 'select distinct acty_base_rt_id
601: from BEN_ACTY_BASE_RT_F
602: where oipl_id = :oipl_id';
603:
604: l_Bind_Value := p_oipl_id;
605:

Line 609: from BEN_ACTY_BASE_RT_F

605:
606: Elsif p_oiplip_id is NOT NULL then
607:
608: l_sql := 'select distinct acty_base_rt_id
609: from BEN_ACTY_BASE_RT_F
610: where oiplip_id = :oiplip_id';
611:
612: l_Bind_Value := p_oiplip_id;
613:

Line 617: from BEN_ACTY_BASE_RT_F

613:
614: Elsif p_cmbn_plip_id is NOT NULL then
615:
616: l_sql := 'select distinct acty_base_rt_id
617: from BEN_ACTY_BASE_RT_F
618: where cmbn_plip_id = :cmbn_plip_id';
619:
620: l_Bind_Value := p_cmbn_plip_id;
621:

Line 625: from BEN_ACTY_BASE_RT_F

621:
622: Elsif p_cmbn_ptip_id is NOT NULL then
623:
624: l_sql := 'select distinct acty_base_rt_id
625: from BEN_ACTY_BASE_RT_F
626: where cmbn_ptip_id = :cmbn_ptip_id';
627:
628: l_Bind_Value := p_cmbn_ptip_id;
629:

Line 633: from BEN_ACTY_BASE_RT_F

629:
630: Elsif p_cmbn_ptip_opt_id is NOT NULL Then
631:
632: l_sql := 'select distinct acty_base_rt_id
633: from BEN_ACTY_BASE_RT_F
634: where cmbn_ptip_opt_id = :cmbn_ptip_opt_id';
635:
636: l_Bind_Value := p_cmbn_ptip_opt_id;
637:

Line 642: from BEN_ACTY_BASE_RT_F

638: Elsif p_opt_id is NOT NULL then
639:
640:
641: l_sql := 'select distinct acty_base_rt_id
642: from BEN_ACTY_BASE_RT_F
643: where opt_id = :opt_id';
644:
645: l_Bind_Value := p_opt_id;
646:

Line 2465: -- END OF BEN_ACTY_BASE_RT_F ----------------------

2461: ---------------------------------------------------------------
2462: --
2463: end loop;
2464: ---------------------------------------------------------------
2465: -- END OF BEN_ACTY_BASE_RT_F ----------------------
2466: ---------------------------------------------------------------
2467: end create_rate_results;
2468: --
2469: procedure create_coverage_results