DBA Data[Home] [Help]

APPS.BEN_EXTRACT_SEED dependencies on BEN_EXT_INCL_CHG

Line 2470: from ben_ext_incl_chg

2466: where ext_rcd_in_file_id = c_ext_rcd_in_file_id ;
2467:
2468: cursor c2 (c_ext_rcd_in_file_id number) is
2469: select 'x'
2470: from ben_ext_incl_chg
2471: where ext_rcd_in_file_id = c_ext_rcd_in_file_id ;
2472:
2473: l_tmp varchar2(1) ;
2474: Begin

Line 3210: from ben_ext_incl_chg

3206: where ext_data_elmt_in_rcd_id = p_ext_data_elmt_in_rcd_id;
3207:
3208: cursor c_ext_incl_chg_id (p_ext_data_elmt_in_rcd_id number) is
3209: select ext_incl_chg_id,object_version_number
3210: from ben_ext_incl_chg
3211: where ext_data_elmt_in_rcd_id = p_ext_data_elmt_in_rcd_id;
3212:
3213: l_obj_ver_number number ;
3214:

Line 3734: FROM ben_ext_incl_chg

3730: BEGIN
3731: --rpinjala
3732: SELECT 'Y'
3733: INTO l_temp
3734: FROM ben_ext_incl_chg
3735: WHERE (l_ext_rcd_in_file_id IS NULL OR
3736: ext_rcd_in_file_id = l_ext_rcd_in_file_id)
3737: AND (l_ext_data_elmt_in_rcd_id IS NULL OR
3738: ext_data_elmt_in_rcd_id = l_ext_data_elmt_in_rcd_id)

Line 3749: FROM ben_ext_incl_chg

3745: WHEN TOO_MANY_ROWS then
3746: declare
3747: cursor c_incl is
3748: SELECT ext_incl_chg_id , object_version_number
3749: FROM ben_ext_incl_chg
3750: WHERE (l_ext_rcd_in_file_id IS NULL OR
3751: ext_rcd_in_file_id = l_ext_rcd_in_file_id)
3752: AND (l_ext_data_elmt_in_rcd_id IS NULL OR
3753: ext_data_elmt_in_rcd_id = l_ext_data_elmt_in_rcd_id)