DBA Data[Home] [Help]

APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_PTD_LMT_F

Line 426: -- START OF BEN_PTD_LMT_F ----------------------

422: ---------------------------------------------------------------
423: -- END OF BEN_PRTL_MO_RT_PRTN_VAL_F ----------------------
424: ---------------------------------------------------------------
425: ---------------------------------------------------------------
426: -- START OF BEN_PTD_LMT_F ----------------------
427: ---------------------------------------------------------------
428: cursor c_pdl_from_parent(c_ACTY_RT_PTD_LMT_ID number) is
429: select ptd_lmt_id
430: from BEN_ACTY_RT_PTD_LMT_F

Line 436: from BEN_PTD_LMT_F pdl

432: --
433: cursor c_pdl(c_ptd_lmt_id number,c_mirror_src_entity_result_id number,
434: c_table_alias varchar2 ) is
435: select pdl.*
436: from BEN_PTD_LMT_F pdl
437: where pdl.ptd_lmt_id = c_ptd_lmt_id
438: -- and pdl.business_group_id = p_business_group_id
439: and not exists (
440: select /* */ null

Line 447: -- and trt.where_clause = 'BEN_PTD_LMT_F'

443: where copy_entity_txn_id = p_copy_entity_txn_id
444: -- and trt.table_route_id = cpe.table_route_id
445: and ( -- c_mirror_src_entity_result_id is null or
446: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
447: -- and trt.where_clause = 'BEN_PTD_LMT_F'
448: and cpe.table_alias = c_table_alias
449: and information1 = c_ptd_lmt_id
450: -- and information4 = pdl.business_group_id
451: and information2 = pdl.effective_start_date

Line 456: -- END OF BEN_PTD_LMT_F ----------------------

452: and information3 = pdl.effective_end_date);
453: l_ptd_lmt_id number(15);
454: l_out_pdl_result_id number(15);
455: ---------------------------------------------------------------
456: -- END OF BEN_PTD_LMT_F ----------------------
457: ---------------------------------------------------------------
458: ---------------------------------------------------------------
459: -- START OF BEN_EXTRA_INPUT_VALUES ----------------------
460: ---------------------------------------------------------------

Line 1624: -- START OF BEN_PTD_LMT_F ----------------------

1620: --
1621: end loop;
1622: --
1623: ---------------------------------------------------------------
1624: -- START OF BEN_PTD_LMT_F ----------------------
1625: ---------------------------------------------------------------
1626: --
1627: for l_parent_rec in c_pdl_from_parent(l_ACTY_RT_PTD_LMT_ID) loop
1628: --

Line 1783: -- END OF BEN_PTD_LMT_F ----------------------

1779: end loop;
1780: --
1781: end loop;
1782: ---------------------------------------------------------------
1783: -- END OF BEN_PTD_LMT_F ----------------------
1784: ---------------------------------------------------------------
1785: end loop;
1786: ---------------------------------------------------------------
1787: -- END OF BEN_ACTY_RT_PTD_LMT_F ----------------------