DBA Data[Home] [Help]

APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_QUAL_TITL_RT_F

Line 7314: -- START OF BEN_QUAL_TITL_RT_F ----------------------

7310: ---------------------------------------------------------------
7311: -- END OF BEN_PSTN_RT_F ----------------------
7312: ---------------------------------------------------------------
7313: ---------------------------------------------------------------
7314: -- START OF BEN_QUAL_TITL_RT_F ----------------------
7315: ---------------------------------------------------------------
7316: cursor c_qtr_from_parent(c_VRBL_RT_PRFL_ID number) is
7317: select qual_titl_rt_id
7318: from BEN_QUAL_TITL_RT_F

Line 7318: from BEN_QUAL_TITL_RT_F

7314: -- START OF BEN_QUAL_TITL_RT_F ----------------------
7315: ---------------------------------------------------------------
7316: cursor c_qtr_from_parent(c_VRBL_RT_PRFL_ID number) is
7317: select qual_titl_rt_id
7318: from BEN_QUAL_TITL_RT_F
7319: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
7320: --
7321: cursor c_qtr(c_qual_titl_rt_id number,c_mirror_src_entity_result_id number,
7322: c_table_alias varchar2 ) is

Line 7324: from BEN_QUAL_TITL_RT_F qtr

7320: --
7321: cursor c_qtr(c_qual_titl_rt_id number,c_mirror_src_entity_result_id number,
7322: c_table_alias varchar2 ) is
7323: select qtr.*
7324: from BEN_QUAL_TITL_RT_F qtr
7325: where qtr.qual_titl_rt_id = c_qual_titl_rt_id
7326: --and qtr.business_group_id = p_business_group_id
7327: and not exists (
7328: select /* */ null

Line 7335: -- and trt.where_clause = 'BEN_QUAL_TITL_RT_F'

7331: where copy_entity_txn_id = p_copy_entity_txn_id
7332: -- and trt.table_route_id = cpe.table_route_id
7333: and ( -- c_mirror_src_entity_result_id is null or
7334: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
7335: -- and trt.where_clause = 'BEN_QUAL_TITL_RT_F'
7336: and cpe.table_alias = c_table_alias
7337: and information1 = c_qual_titl_rt_id
7338: -- and information4 = qtr.business_group_id
7339: and information2 = qtr.effective_start_date

Line 7352: -- END OF BEN_QUAL_TITL_RT_F ----------------------

7348:
7349: l_qual_titl_rt_id number(15);
7350: l_out_qtr_result_id number(15);
7351: ---------------------------------------------------------------
7352: -- END OF BEN_QUAL_TITL_RT_F ----------------------
7353: ---------------------------------------------------------------
7354: ---------------------------------------------------------------
7355: -- START OF BEN_CBR_QUALD_BNF_RT_F ----------------------
7356: ---------------------------------------------------------------

Line 13078: -- START OF BEN_QUAL_TITL_RT_F ----------------------

13074: ---------------------------------------------------------------
13075: -- END OF BEN_PSTN_RT_F ----------------------
13076: ---------------------------------------------------------------
13077: ---------------------------------------------------------------
13078: -- START OF BEN_QUAL_TITL_RT_F ----------------------
13079: ---------------------------------------------------------------
13080: --
13081: hr_utility.set_location('START OF BEN_QUAL_TITL_RT_F ',100);
13082: for l_parent_rec in c_qtr_from_parent(l_VRBL_RT_PRFL_ID) loop

Line 13081: hr_utility.set_location('START OF BEN_QUAL_TITL_RT_F ',100);

13077: ---------------------------------------------------------------
13078: -- START OF BEN_QUAL_TITL_RT_F ----------------------
13079: ---------------------------------------------------------------
13080: --
13081: hr_utility.set_location('START OF BEN_QUAL_TITL_RT_F ',100);
13082: for l_parent_rec in c_qtr_from_parent(l_VRBL_RT_PRFL_ID) loop
13083: --
13084: l_mirror_src_entity_result_id := l_out_vpf_result_id ;
13085:

Line 13213: hr_utility.set_location('END OF BEN_QUAL_TITL_RT_F ',100);

13209: --
13210: end loop;
13211: --
13212: end loop;
13213: hr_utility.set_location('END OF BEN_QUAL_TITL_RT_F ',100);
13214: ---------------------------------------------------------------
13215: -- END OF BEN_QUAL_TITL_RT_F ----------------------
13216: ---------------------------------------------------------------
13217: ---------------------------------------------------------------

Line 13215: -- END OF BEN_QUAL_TITL_RT_F ----------------------

13211: --
13212: end loop;
13213: hr_utility.set_location('END OF BEN_QUAL_TITL_RT_F ',100);
13214: ---------------------------------------------------------------
13215: -- END OF BEN_QUAL_TITL_RT_F ----------------------
13216: ---------------------------------------------------------------
13217: ---------------------------------------------------------------
13218: -- START OF BEN_CBR_QUALD_BNF_RT_F ----------------------
13219: ---------------------------------------------------------------