APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_PYMT_SCHED_PY_FREQ

Line 218: -- START OF BEN_PYMT_SCHED_PY_FREQ ----------------------

214: ---------------------------------------------------------------
215: -- END OF BEN_ACTY_RT_PYMT_SCHED_F ----------------------
216: ---------------------------------------------------------------
217: ---------------------------------------------------------------
218: -- START OF BEN_PYMT_SCHED_PY_FREQ ----------------------
219: ---------------------------------------------------------------
220: cursor c_psq_from_parent(c_ACTY_RT_PYMT_SCHED_ID number) is
221: select pymt_sched_py_freq_id
222: from BEN_PYMT_SCHED_PY_FREQ

Line 222: from BEN_PYMT_SCHED_PY_FREQ

218: -- START OF BEN_PYMT_SCHED_PY_FREQ ----------------------
219: ---------------------------------------------------------------
220: cursor c_psq_from_parent(c_ACTY_RT_PYMT_SCHED_ID number) is
221: select pymt_sched_py_freq_id
222: from BEN_PYMT_SCHED_PY_FREQ
223: where ACTY_RT_PYMT_SCHED_ID = c_ACTY_RT_PYMT_SCHED_ID ;
224: --
225: cursor c_psq(c_pymt_sched_py_freq_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
226: select psq.*

Line 227: from BEN_PYMT_SCHED_PY_FREQ psq

223: where ACTY_RT_PYMT_SCHED_ID = c_ACTY_RT_PYMT_SCHED_ID ;
224: --
225: cursor c_psq(c_pymt_sched_py_freq_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
226: select psq.*
227: from BEN_PYMT_SCHED_PY_FREQ psq
228: where psq.pymt_sched_py_freq_id = c_pymt_sched_py_freq_id
229: --and psq.business_group_id = p_business_group_id
230: and not exists (
231: select /* */ null

Line 238: -- and trt.where_clause = 'BEN_PYMT_SCHED_PY_FREQ'

234: where copy_entity_txn_id = p_copy_entity_txn_id
235: -- and trt.table_route_id = cpe.table_route_id
236: and ( --c_mirror_src_entity_result_id is null or
237: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
238: -- and trt.where_clause = 'BEN_PYMT_SCHED_PY_FREQ'
239: and cpe.table_alias = c_table_alias
240: and information1 = c_pymt_sched_py_freq_id
241: --and information4 = psq.business_group_id
242: );

Line 246: -- END OF BEN_PYMT_SCHED_PY_FREQ ----------------------

242: );
243: l_pymt_sched_py_freq_id number(15);
244: l_out_psq_result_id number(15);
245: ---------------------------------------------------------------
246: -- END OF BEN_PYMT_SCHED_PY_FREQ ----------------------
247: ---------------------------------------------------------------
248: ---------------------------------------------------------------
249: -- START OF BEN_ACTL_PREM_F ----------------------
250: ---------------------------------------------------------------

Line 1429: -- START OF BEN_PYMT_SCHED_PY_FREQ ----------------------

1425: ---------------------------------------------------------------
1426: -- END OF BEN_ACTY_RT_PYMT_SCHED_F ----------------------
1427: ---------------------------------------------------------------
1428: ---------------------------------------------------------------
1429: -- START OF BEN_PYMT_SCHED_PY_FREQ ----------------------
1430: ---------------------------------------------------------------
1431: --
1432: for l_parent_rec in c_psq_from_parent(l_ACTY_RT_PYMT_SCHED_ID) loop
1433: --

Line 1516: -- END OF BEN_PYMT_SCHED_PY_FREQ ----------------------

1512: end loop;
1513: --
1514: end loop;
1515: ---------------------------------------------------------------
1516: -- END OF BEN_PYMT_SCHED_PY_FREQ ----------------------
1517: ---------------------------------------------------------------
1518: ---------------------------------------------------------------
1519: -- START OF BEN_ACTL_PREM_F ----------------------
1520: ---------------------------------------------------------------