DBA Data[Home] [Help]

APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_ACTY_RT_PYMT_SCHED_F

Line 186: -- START OF BEN_ACTY_RT_PYMT_SCHED_F ----------------------

182: ---------------------------------------------------------------
183: -- END OF BEN_ACTY_BASE_RT_F ----------------------
184: ---------------------------------------------------------------
185: ---------------------------------------------------------------
186: -- START OF BEN_ACTY_RT_PYMT_SCHED_F ----------------------
187: ---------------------------------------------------------------
188: cursor c_apf_from_parent(c_ACTY_BASE_RT_ID number) is
189: select acty_rt_pymt_sched_id
190: from BEN_ACTY_RT_PYMT_SCHED_F

Line 190: from BEN_ACTY_RT_PYMT_SCHED_F

186: -- START OF BEN_ACTY_RT_PYMT_SCHED_F ----------------------
187: ---------------------------------------------------------------
188: cursor c_apf_from_parent(c_ACTY_BASE_RT_ID number) is
189: select acty_rt_pymt_sched_id
190: from BEN_ACTY_RT_PYMT_SCHED_F
191: where ACTY_BASE_RT_ID = c_ACTY_BASE_RT_ID ;
192: --
193: cursor c_apf(c_acty_rt_pymt_sched_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2) is
194: select apf.*

Line 195: from BEN_ACTY_RT_PYMT_SCHED_F apf

191: where ACTY_BASE_RT_ID = c_ACTY_BASE_RT_ID ;
192: --
193: cursor c_apf(c_acty_rt_pymt_sched_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2) is
194: select apf.*
195: from BEN_ACTY_RT_PYMT_SCHED_F apf
196: where apf.acty_rt_pymt_sched_id = c_acty_rt_pymt_sched_id
197: --and apf.business_group_id = p_business_group_id
198: and not exists (
199: select /* */ null

Line 206: -- and trt.where_clause = 'BEN_ACTY_RT_PYMT_SCHED_F'

202: where copy_entity_txn_id = p_copy_entity_txn_id
203: -- and trt.table_route_id = cpe.table_route_id
204: and ( --l_mirror_src_entity_result_id is null or
205: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
206: -- and trt.where_clause = 'BEN_ACTY_RT_PYMT_SCHED_F'
207: and cpe.table_alias = c_table_alias
208: and information1 = c_acty_rt_pymt_sched_id
209: --and information4 = apf.business_group_id
210: and information2 = apf.effective_start_date

Line 215: -- END OF BEN_ACTY_RT_PYMT_SCHED_F ----------------------

211: and information3 = apf.effective_end_date);
212: l_acty_rt_pymt_sched_id number(15);
213: l_out_apf_result_id number(15);
214: ---------------------------------------------------------------
215: -- END OF BEN_ACTY_RT_PYMT_SCHED_F ----------------------
216: ---------------------------------------------------------------
217: ---------------------------------------------------------------
218: -- START OF BEN_PYMT_SCHED_PY_FREQ ----------------------
219: ---------------------------------------------------------------

Line 1310: -- START OF BEN_ACTY_RT_PYMT_SCHED_F ----------------------

1306:
1307: end loop;
1308:
1309: ---------------------------------------------------------------
1310: -- START OF BEN_ACTY_RT_PYMT_SCHED_F ----------------------
1311: ---------------------------------------------------------------
1312: --
1313: for l_parent_rec in c_apf_from_parent(l_ACTY_BASE_RT_ID) loop
1314: --

Line 1426: -- END OF BEN_ACTY_RT_PYMT_SCHED_F ----------------------

1422: --
1423: end loop;
1424:
1425: ---------------------------------------------------------------
1426: -- END OF BEN_ACTY_RT_PYMT_SCHED_F ----------------------
1427: ---------------------------------------------------------------
1428: ---------------------------------------------------------------
1429: -- START OF BEN_PYMT_SCHED_PY_FREQ ----------------------
1430: ---------------------------------------------------------------