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_ELIGY_CRITERIA

Line 3848: FROM ben_eligy_criteria egl

3844: --
3845: CURSOR c_egl_val_type_cd (cv_eligy_criteria_id NUMBER)
3846: IS
3847: SELECT crit_col1_val_type_cd
3848: FROM ben_eligy_criteria egl
3849: WHERE eligy_criteria_id = cv_eligy_criteria_id;
3850: --
3851: l_eligy_crit_values_id number(15);
3852: l_out_ecv_result_id number(15);

Line 3864: Bug : 4347039. Moved the code to copy BEN_ELIGY_CRITERIA data

3860: ---------------------------------------------------------------
3861: -------------- END OF BEN_ELIGY_CRIT_VALUES_F -----------------
3862: ---------------------------------------------------------------
3863: /*
3864: Bug : 4347039. Moved the code to copy BEN_ELIGY_CRITERIA data
3865: into the procedure create_eligy_criteria_result
3866: ---------------------------------------------------------------
3867: --------------- START OF BEN_ELIGY_CRITERIA -------------------
3868: ---------------------------------------------------------------

Line 3867: --------------- START OF BEN_ELIGY_CRITERIA -------------------

3863: /*
3864: Bug : 4347039. Moved the code to copy BEN_ELIGY_CRITERIA data
3865: into the procedure create_eligy_criteria_result
3866: ---------------------------------------------------------------
3867: --------------- START OF BEN_ELIGY_CRITERIA -------------------
3868: ---------------------------------------------------------------
3869: CURSOR c_egl (
3870: cv_eligy_criteria_id NUMBER,
3871: cv_mirror_src_entity_result_id NUMBER,

Line 3876: FROM ben_eligy_criteria egl

3872: cv_table_alias VARCHAR2
3873: )
3874: IS
3875: SELECT egl.*
3876: FROM ben_eligy_criteria egl
3877: WHERE egl.eligy_criteria_id = cv_eligy_criteria_id
3878: AND NOT EXISTS (
3879: SELECT NULL
3880: FROM ben_copy_entity_results cpe

Line 3903: ------------------ END OF BEN_ELIGY_CRITERIA ------------------

3899: l_egl_object_version_number ben_copy_entity_results.object_version_number%TYPE;
3900: l_flex_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE;
3901: --
3902: ---------------------------------------------------------------
3903: ------------------ END OF BEN_ELIGY_CRITERIA ------------------
3904: ---------------------------------------------------------------
3905: */
3906: cursor c_object_exists(c_pk_id number,
3907: c_table_alias varchar2) is

Line 12033: ----------------- START OF BEN_ELIGY_CRITERIA -----------------

12029: --
12030: end loop;
12031: --
12032: ---------------------------------------------------------------
12033: ----------------- START OF BEN_ELIGY_CRITERIA -----------------
12034: ---------------------------------------------------------------
12035: -- Bug: 4347039. Moved the code to copy BEN_ELIGY_CRITERIA
12036: -- to the following procedure. PDW wanted externalizing this copying.
12037: --

Line 12035: -- Bug: 4347039. Moved the code to copy BEN_ELIGY_CRITERIA

12031: --
12032: ---------------------------------------------------------------
12033: ----------------- START OF BEN_ELIGY_CRITERIA -----------------
12034: ---------------------------------------------------------------
12035: -- Bug: 4347039. Moved the code to copy BEN_ELIGY_CRITERIA
12036: -- to the following procedure. PDW wanted externalizing this copying.
12037: --
12038: create_eligy_criteria_result (
12039: p_validate => p_validate

Line 12185: ------------------ END OF BEN_ELIGY_CRITERIA ------------------

12181: --
12182: end loop;
12183: -- */
12184: ---------------------------------------------------------------
12185: ------------------ END OF BEN_ELIGY_CRITERIA ------------------
12186: ---------------------------------------------------------------
12187: --
12188: end loop;
12189: --

Line 13925: FROM ben_eligy_criteria egl

13921: cv_table_alias VARCHAR2
13922: )
13923: IS
13924: SELECT egl.*
13925: FROM ben_eligy_criteria egl
13926: WHERE egl.eligy_criteria_id = cv_eligy_criteria_id
13927: AND NOT EXISTS (
13928: SELECT NULL
13929: FROM ben_copy_entity_results cpe

Line 13986: ----------------- START OF BEN_ELIGY_CRITERIA -----------------

13982: l_number_of_copies := p_number_of_copies ;
13983: --
13984: --
13985: ---------------------------------------------------------------
13986: ----------------- START OF BEN_ELIGY_CRITERIA -----------------
13987: ---------------------------------------------------------------
13988: --
13989: l_mirror_src_entity_result_id := p_copy_entity_result_id ;
13990: l_eligy_criteria_id := p_eligy_criteria_id;

Line 14186: ------------------ END OF BEN_ELIGY_CRITERIA ------------------

14182: end loop;
14183: --
14184: --
14185: ---------------------------------------------------------------
14186: ------------------ END OF BEN_ELIGY_CRITERIA ------------------
14187: ---------------------------------------------------------------
14188: --
14189: end create_eligy_criteria_result;
14190: