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_ELPRO_MODULE dependencies on BEN_ELIG_JOB_PRTE_F

Line 2196: -- START OF BEN_ELIG_JOB_PRTE_F ----------------------

2192: ---------------------------------------------------------------
2193: -- END OF BEN_ELIG_HRS_WKD_PRTE_F ----------------------
2194: ---------------------------------------------------------------
2195: ---------------------------------------------------------------
2196: -- START OF BEN_ELIG_JOB_PRTE_F ----------------------
2197: ---------------------------------------------------------------
2198: cursor c_ejp_from_parent(c_ELIGY_PRFL_ID number) is
2199: select elig_job_prte_id
2200: from BEN_ELIG_JOB_PRTE_F

Line 2200: from BEN_ELIG_JOB_PRTE_F

2196: -- START OF BEN_ELIG_JOB_PRTE_F ----------------------
2197: ---------------------------------------------------------------
2198: cursor c_ejp_from_parent(c_ELIGY_PRFL_ID number) is
2199: select elig_job_prte_id
2200: from BEN_ELIG_JOB_PRTE_F
2201: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
2202: --
2203: cursor c_ejp(c_elig_job_prte_id number,c_mirror_src_entity_result_id number ,
2204: c_table_alias varchar2 ) is

Line 2206: from BEN_ELIG_JOB_PRTE_F ejp

2202: --
2203: cursor c_ejp(c_elig_job_prte_id number,c_mirror_src_entity_result_id number ,
2204: c_table_alias varchar2 ) is
2205: select ejp.*
2206: from BEN_ELIG_JOB_PRTE_F ejp
2207: where ejp.elig_job_prte_id = c_elig_job_prte_id
2208: -- and ejp.business_group_id = p_business_group_id
2209: and not exists (
2210: select /* */ null

Line 2217: -- and trt.where_clause = 'BEN_ELIG_JOB_PRTE_F'

2213: where copy_entity_txn_id = p_copy_entity_txn_id
2214: -- and trt.table_route_id = cpe.table_route_id
2215: and ( -- c_mirror_src_entity_result_id is null or
2216: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
2217: -- and trt.where_clause = 'BEN_ELIG_JOB_PRTE_F'
2218: and cpe.table_alias = c_table_alias
2219: and information1 = c_elig_job_prte_id
2220: -- and information4 = ejp.business_group_id
2221: and information2 = ejp.effective_start_date

Line 2244: -- END OF BEN_ELIG_JOB_PRTE_F ----------------------

2240: where job_id = c_job_id;
2241:
2242: l_job_start_date per_jobs.date_from%type;
2243: ---------------------------------------------------------------
2244: -- END OF BEN_ELIG_JOB_PRTE_F ----------------------
2245: ---------------------------------------------------------------
2246: ---------------------------------------------------------------
2247: -- START OF BEN_ELIG_LBR_MMBR_PRTE_F ----------------------
2248: ---------------------------------------------------------------

Line 7029: -- START OF BEN_ELIG_JOB_PRTE_F ----------------------

7025: ---------------------------------------------------------------
7026: -- END OF BEN_ELIG_HRS_WKD_PRTE_F ----------------------
7027: ---------------------------------------------------------------
7028: ---------------------------------------------------------------
7029: -- START OF BEN_ELIG_JOB_PRTE_F ----------------------
7030: ---------------------------------------------------------------
7031: --
7032: for l_parent_rec in c_ejp_from_parent(l_ELIGY_PRFL_ID) loop
7033: --

Line 7172: -- END OF BEN_ELIG_JOB_PRTE_F ----------------------

7168: end loop;
7169: --
7170: end loop;
7171: ---------------------------------------------------------------
7172: -- END OF BEN_ELIG_JOB_PRTE_F ----------------------
7173: ---------------------------------------------------------------
7174: ---------------------------------------------------------------
7175: -- START OF BEN_ELIG_LBR_MMBR_PRTE_F ----------------------
7176: ---------------------------------------------------------------