DBA Data[Home] [Help]

APPS.BEN_PLAN_DESIGN_PROGRAM_MODULE dependencies on BEN_LER_CHG_PGM_ENRT_F

Line 144: -- START OF BEN_LER_CHG_PGM_ENRT_F ----------------------

140: ---------------------------------------------------------------
141: -- END OF BEN_LER_CHG_DPNT_CVG_F ----------------------
142: ---------------------------------------------------------------
143: ---------------------------------------------------------------
144: -- START OF BEN_LER_CHG_PGM_ENRT_F ----------------------
145: ---------------------------------------------------------------
146: cursor c_lge_from_parent(c_PGM_ID number) is
147: select distinct ler_chg_pgm_enrt_id
148: from BEN_LER_CHG_PGM_ENRT_F

Line 148: from BEN_LER_CHG_PGM_ENRT_F

144: -- START OF BEN_LER_CHG_PGM_ENRT_F ----------------------
145: ---------------------------------------------------------------
146: cursor c_lge_from_parent(c_PGM_ID number) is
147: select distinct ler_chg_pgm_enrt_id
148: from BEN_LER_CHG_PGM_ENRT_F
149: where PGM_ID = c_PGM_ID ;
150: --
151: cursor c_lge(c_ler_chg_pgm_enrt_id number ,c_mirror_src_entity_result_id number,
152: c_table_alias varchar2 ) is

Line 154: from BEN_LER_CHG_PGM_ENRT_F lge

150: --
151: cursor c_lge(c_ler_chg_pgm_enrt_id number ,c_mirror_src_entity_result_id number,
152: c_table_alias varchar2 ) is
153: select lge.*
154: from BEN_LER_CHG_PGM_ENRT_F lge
155: where lge.ler_chg_pgm_enrt_id = c_ler_chg_pgm_enrt_id
156: --and lge.business_group_id = p_business_group_id
157: and not exists (
158: select /* */ null

Line 179: -- and trt.where_clause = 'BEN_LER_CHG_PGM_ENRT_F'

175: -- ,pqh_table_route trt
176: where copy_entity_txn_id = p_copy_entity_txn_id
177: -- and trt.table_route_id = cpe.table_route_id
178: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
179: -- and trt.where_clause = 'BEN_LER_CHG_PGM_ENRT_F'
180: and cpe.table_alias = c_table_alias
181: and information1 = c_ler_chg_pgm_enrt_id
182: -- and information4 = p_business_group_id
183: ;

Line 186: -- END OF BEN_LER_CHG_PGM_ENRT_F ----------------------

182: -- and information4 = p_business_group_id
183: ;
184: l_out_lge_result_id number(15);
185: ---------------------------------------------------------------
186: -- END OF BEN_LER_CHG_PGM_ENRT_F ----------------------
187: ---------------------------------------------------------------
188: ---------------------------------------------------------------
189: -- START OF BEN_ELIG_TO_PRTE_RSN_F ----------------------
190: ---------------------------------------------------------------

Line 1763: -- START OF BEN_LER_CHG_PGM_ENRT_F ----------------------

1759: ---------------------------------------------------------------
1760: -- END OF BEN_LER_CHG_DPNT_CVG_F ----------------------
1761: ---------------------------------------------------------------
1762: ---------------------------------------------------------------
1763: -- START OF BEN_LER_CHG_PGM_ENRT_F ----------------------
1764: ---------------------------------------------------------------
1765: --
1766: for l_parent_rec in c_lge_from_parent(l_PGM_ID) loop
1767: --

Line 1945: -- END OF BEN_LER_CHG_PGM_ENRT_F ----------------------

1941: end loop;
1942: --
1943: end loop;
1944: ---------------------------------------------------------------
1945: -- END OF BEN_LER_CHG_PGM_ENRT_F ----------------------
1946: ---------------------------------------------------------------
1947: ---------------------------------------------------------------
1948: -- START OF BEN_ELIG_TO_PRTE_RSN_F ----------------------
1949: ---------------------------------------------------------------