DBA Data[Home] [Help]

APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_EXTRA_INPUT_VALUES

Line 459: -- START OF BEN_EXTRA_INPUT_VALUES ----------------------

455: ---------------------------------------------------------------
456: -- END OF BEN_PTD_LMT_F ----------------------
457: ---------------------------------------------------------------
458: ---------------------------------------------------------------
459: -- START OF BEN_EXTRA_INPUT_VALUES ----------------------
460: ---------------------------------------------------------------
461: cursor c_eiv_from_parent(c_ACTY_BASE_RT_ID number) is
462: select extra_input_value_id
463: from BEN_EXTRA_INPUT_VALUES

Line 463: from BEN_EXTRA_INPUT_VALUES

459: -- START OF BEN_EXTRA_INPUT_VALUES ----------------------
460: ---------------------------------------------------------------
461: cursor c_eiv_from_parent(c_ACTY_BASE_RT_ID number) is
462: select extra_input_value_id
463: from BEN_EXTRA_INPUT_VALUES
464: where ACTY_BASE_RT_ID = c_ACTY_BASE_RT_ID ;
465: --
466: cursor c_eiv(c_extra_input_value_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
467: select eiv.*

Line 468: from BEN_EXTRA_INPUT_VALUES eiv

464: where ACTY_BASE_RT_ID = c_ACTY_BASE_RT_ID ;
465: --
466: cursor c_eiv(c_extra_input_value_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
467: select eiv.*
468: from BEN_EXTRA_INPUT_VALUES eiv
469: where eiv.extra_input_value_id = c_extra_input_value_id
470: -- and eiv.business_group_id = p_business_group_id
471: and not exists (
472: select /* */ null

Line 479: -- and trt.where_clause = 'BEN_EXTRA_INPUT_VALUES'

475: where copy_entity_txn_id = p_copy_entity_txn_id
476: -- and trt.table_route_id = cpe.table_route_id
477: and ( -- c_mirror_src_entity_result_id is null or
478: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
479: -- and trt.where_clause = 'BEN_EXTRA_INPUT_VALUES'
480: and cpe.table_alias = c_table_alias
481: and information1 = c_extra_input_value_id
482: -- and information4 = eiv.business_group_id
483: );

Line 501: -- END OF BEN_EXTRA_INPUT_VALUES ----------------------

497: l_extra_input_value_id number(15);
498: l_out_eiv_result_id number(15);
499: l_element_type_id_for_eiv number;
500: ---------------------------------------------------------------
501: -- END OF BEN_EXTRA_INPUT_VALUES ----------------------
502: ---------------------------------------------------------------
503: ---------------------------------------------------------------
504: -- START OF BEN_ACTY_BASE_RT_CTFN_F ----------------------
505: ---------------------------------------------------------------

Line 2229: -- START OF BEN_EXTRA_INPUT_VALUES ----------------------

2225: ---------------------------------------------------------------
2226: -- END OF BEN_PRTL_MO_RT_PRTN_VAL_F ----------------------
2227: ---------------------------------------------------------------
2228: ---------------------------------------------------------------
2229: -- START OF BEN_EXTRA_INPUT_VALUES ----------------------
2230: ---------------------------------------------------------------
2231: --
2232: for l_parent_rec in c_eiv_from_parent(l_ACTY_BASE_RT_ID) loop
2233: --

Line 2337: -- END OF BEN_EXTRA_INPUT_VALUES ----------------------

2333: end loop;
2334: --
2335: end loop;
2336: ---------------------------------------------------------------
2337: -- END OF BEN_EXTRA_INPUT_VALUES ----------------------
2338: ---------------------------------------------------------------
2339: ---------------------------------------------------------------
2340: -- START OF BEN_ACTY_BASE_RT_CTFN_F ----------------------
2341: ---------------------------------------------------------------