DBA Data[Home] [Help]

APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_JOB_RT_F

Line 7214: -- START OF BEN_JOB_RT_F ----------------------

7210: ---------------------------------------------------------------
7211: -- END OF BEN_COMPTNCY_RT_F ----------------------
7212: ---------------------------------------------------------------
7213: ---------------------------------------------------------------
7214: -- START OF BEN_JOB_RT_F ----------------------
7215: ---------------------------------------------------------------
7216: cursor c_jrt_from_parent(c_VRBL_RT_PRFL_ID number) is
7217: select job_rt_id
7218: from BEN_JOB_RT_F

Line 7218: from BEN_JOB_RT_F

7214: -- START OF BEN_JOB_RT_F ----------------------
7215: ---------------------------------------------------------------
7216: cursor c_jrt_from_parent(c_VRBL_RT_PRFL_ID number) is
7217: select job_rt_id
7218: from BEN_JOB_RT_F
7219: where VRBL_RT_PRFL_ID = c_VRBL_RT_PRFL_ID ;
7220: --
7221: cursor c_jrt(c_job_rt_id number,c_mirror_src_entity_result_id number,
7222: c_table_alias varchar2 ) is

Line 7224: from BEN_JOB_RT_F jrt

7220: --
7221: cursor c_jrt(c_job_rt_id number,c_mirror_src_entity_result_id number,
7222: c_table_alias varchar2 ) is
7223: select jrt.*
7224: from BEN_JOB_RT_F jrt
7225: where jrt.job_rt_id = c_job_rt_id
7226: -- and jrt.business_group_id = p_business_group_id
7227: and not exists (
7228: select /* */ null

Line 7235: -- and trt.where_clause = 'BEN_JOB_RT_F'

7231: where copy_entity_txn_id = p_copy_entity_txn_id
7232: -- and trt.table_route_id = cpe.table_route_id
7233: and ( -- c_mirror_src_entity_result_id is null or
7234: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
7235: -- and trt.where_clause = 'BEN_JOB_RT_F'
7236: and cpe.table_alias = c_table_alias
7237: and information1 = c_job_rt_id
7238: -- and information4 = jrt.business_group_id
7239: and information2 = jrt.effective_start_date

Line 7263: -- END OF BEN_JOB_RT_F ----------------------

7259: l_job_rt_id number(15);
7260: l_out_jrt_result_id number(15);
7261: l_job_start_date per_jobs.date_from%type;
7262: ---------------------------------------------------------------
7263: -- END OF BEN_JOB_RT_F ----------------------
7264: ---------------------------------------------------------------
7265: ---------------------------------------------------------------
7266: -- START OF BEN_PSTN_RT_F ----------------------
7267: ---------------------------------------------------------------

Line 12781: -- START OF BEN_JOB_RT_F ----------------------

12777: ---------------------------------------------------------------
12778: -- END OF BEN_COMPTNCY_RT_F ----------------------
12779: ---------------------------------------------------------------
12780: ---------------------------------------------------------------
12781: -- START OF BEN_JOB_RT_F ----------------------
12782: ---------------------------------------------------------------
12783: --
12784: hr_utility.set_location('START OF BEN_JOB_RT_F',100);
12785: for l_parent_rec in c_jrt_from_parent(l_VRBL_RT_PRFL_ID) loop

Line 12784: hr_utility.set_location('START OF BEN_JOB_RT_F',100);

12780: ---------------------------------------------------------------
12781: -- START OF BEN_JOB_RT_F ----------------------
12782: ---------------------------------------------------------------
12783: --
12784: hr_utility.set_location('START OF BEN_JOB_RT_F',100);
12785: for l_parent_rec in c_jrt_from_parent(l_VRBL_RT_PRFL_ID) loop
12786: --
12787: l_mirror_src_entity_result_id := l_out_vpf_result_id ;
12788:

Line 12924: hr_utility.set_location('END OF BEN_JOB_RT_F',100);

12920: --
12921: end loop;
12922: --
12923: end loop;
12924: hr_utility.set_location('END OF BEN_JOB_RT_F',100);
12925: ---------------------------------------------------------------
12926: -- END OF BEN_JOB_RT_F ----------------------
12927: ---------------------------------------------------------------
12928:

Line 12926: -- END OF BEN_JOB_RT_F ----------------------

12922: --
12923: end loop;
12924: hr_utility.set_location('END OF BEN_JOB_RT_F',100);
12925: ---------------------------------------------------------------
12926: -- END OF BEN_JOB_RT_F ----------------------
12927: ---------------------------------------------------------------
12928:
12929: ---------------------------------------------------------------
12930: -- START OF BEN_PSTN_RT_F ----------------------