DBA Data[Home] [Help]

APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_ACTY_BASE_RT_CTFN_F

Line 504: -- START OF BEN_ACTY_BASE_RT_CTFN_F ----------------------

500: ---------------------------------------------------------------
501: -- END OF BEN_EXTRA_INPUT_VALUES ----------------------
502: ---------------------------------------------------------------
503: ---------------------------------------------------------------
504: -- START OF BEN_ACTY_BASE_RT_CTFN_F ----------------------
505: ---------------------------------------------------------------
506: cursor c_abc_from_parent(c_ACTY_BASE_RT_ID number) is
507: select acty_base_rt_ctfn_id
508: from BEN_ACTY_BASE_RT_CTFN_F

Line 508: from BEN_ACTY_BASE_RT_CTFN_F

504: -- START OF BEN_ACTY_BASE_RT_CTFN_F ----------------------
505: ---------------------------------------------------------------
506: cursor c_abc_from_parent(c_ACTY_BASE_RT_ID number) is
507: select acty_base_rt_ctfn_id
508: from BEN_ACTY_BASE_RT_CTFN_F
509: where ACTY_BASE_RT_ID = c_ACTY_BASE_RT_ID ;
510: --
511: cursor c_abc(c_acty_base_rt_ctfn_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2) is
512: select abc.*

Line 513: from BEN_ACTY_BASE_RT_CTFN_F abc

509: where ACTY_BASE_RT_ID = c_ACTY_BASE_RT_ID ;
510: --
511: cursor c_abc(c_acty_base_rt_ctfn_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2) is
512: select abc.*
513: from BEN_ACTY_BASE_RT_CTFN_F abc
514: where abc.acty_base_rt_ctfn_id = c_acty_base_rt_ctfn_id
515: -- and abc.business_group_id = p_business_group_id
516: and not exists (
517: select /* */ null

Line 524: -- and trt.where_clause = 'BEN_ACTY_BASE_RT_CTFN_F'

520: where copy_entity_txn_id = p_copy_entity_txn_id
521: -- and trt.table_route_id = cpe.table_route_id
522: and ( -- c_mirror_src_entity_result_id is null or
523: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
524: -- and trt.where_clause = 'BEN_ACTY_BASE_RT_CTFN_F'
525: and cpe.table_alias = c_table_alias
526: and information1 = c_acty_base_rt_ctfn_id
527: -- and information4 = abc.business_group_id
528: and information2 = abc.effective_start_date

Line 533: -- END OF BEN_ACTY_BASE_RT_CTFN_F ----------------------

529: and information3 = abc.effective_end_date);
530: l_acty_base_rt_ctfn_id number(15);
531: l_out_abc_result_id number(15);
532: ---------------------------------------------------------------
533: -- END OF BEN_ACTY_BASE_RT_CTFN_F ----------------------
534: ---------------------------------------------------------------
535:
536: cursor c_object_exists(c_pk_id number,
537: c_table_alias varchar2) is

Line 2340: -- START OF BEN_ACTY_BASE_RT_CTFN_F ----------------------

2336: ---------------------------------------------------------------
2337: -- END OF BEN_EXTRA_INPUT_VALUES ----------------------
2338: ---------------------------------------------------------------
2339: ---------------------------------------------------------------
2340: -- START OF BEN_ACTY_BASE_RT_CTFN_F ----------------------
2341: ---------------------------------------------------------------
2342: --
2343: for l_parent_rec in c_abc_from_parent(l_ACTY_BASE_RT_ID) loop
2344: --

Line 2460: -- END OF BEN_ACTY_BASE_RT_CTFN_F ----------------------

2456: end loop;
2457: --
2458: end loop;
2459: ---------------------------------------------------------------
2460: -- END OF BEN_ACTY_BASE_RT_CTFN_F ----------------------
2461: ---------------------------------------------------------------
2462: --
2463: end loop;
2464: ---------------------------------------------------------------