DBA Data[Home] [Help]

APPS.BEN_EXTRACT_SEED dependencies on BEN_EXT_INCL_CHG

Line 2414: from ben_ext_incl_chg

2410: where ext_rcd_in_file_id = c_ext_rcd_in_file_id ;
2411:
2412: cursor c2 (c_ext_rcd_in_file_id number) is
2413: select 'x'
2414: from ben_ext_incl_chg
2415: where ext_rcd_in_file_id = c_ext_rcd_in_file_id ;
2416:
2417: l_tmp varchar2(1) ;
2418: Begin

Line 3154: from ben_ext_incl_chg

3150: where ext_data_elmt_in_rcd_id = p_ext_data_elmt_in_rcd_id;
3151:
3152: cursor c_ext_incl_chg_id (p_ext_data_elmt_in_rcd_id number) is
3153: select ext_incl_chg_id,object_version_number
3154: from ben_ext_incl_chg
3155: where ext_data_elmt_in_rcd_id = p_ext_data_elmt_in_rcd_id;
3156:
3157: l_obj_ver_number number ;
3158:

Line 3678: FROM ben_ext_incl_chg

3674: BEGIN
3675: --rpinjala
3676: SELECT 'Y'
3677: INTO l_temp
3678: FROM ben_ext_incl_chg
3679: WHERE (l_ext_rcd_in_file_id IS NULL OR
3680: ext_rcd_in_file_id = l_ext_rcd_in_file_id)
3681: AND (l_ext_data_elmt_in_rcd_id IS NULL OR
3682: ext_data_elmt_in_rcd_id = l_ext_data_elmt_in_rcd_id)

Line 3693: FROM ben_ext_incl_chg

3689: WHEN TOO_MANY_ROWS then
3690: declare
3691: cursor c_incl is
3692: SELECT ext_incl_chg_id , object_version_number
3693: FROM ben_ext_incl_chg
3694: WHERE (l_ext_rcd_in_file_id IS NULL OR
3695: ext_rcd_in_file_id = l_ext_rcd_in_file_id)
3696: AND (l_ext_data_elmt_in_rcd_id IS NULL OR
3697: ext_data_elmt_in_rcd_id = l_ext_data_elmt_in_rcd_id)