APPS.BEN_EXTRACT_SEED dependencies on BEN_EXT_WHERE_CLAUSE

Line 2409: from ben_Ext_where_clause

2405: /* If the Same Sequence Find Delete the Record for the Sequence */
2406: declare
2407: cursor c1 (c_ext_rcd_in_file_id number) is
2408: select 'x'
2409: from ben_Ext_where_clause
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'

Line 3149: from ben_ext_where_clause

3145:
3146:
3147: cursor c_ext_where_clause (p_ext_data_elmt_in_rcd_id number) is
3148: select ext_where_clause_id,object_version_number
3149: from ben_ext_where_clause
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

Line 3407: FROM ben_ext_where_clause

3403: l_ext_data_elmt_in_rcd_id := null ;
3404:
3405: SELECT 'Y'
3406: INTO l_temp
3407: FROM ben_ext_where_clause
3408: WHERE cond_ext_data_elmt_in_rcd_id = l_cond_ext_data_elmt_in_rcd_id
3409: AND ext_rcd_in_file_id = l_ext_rcd_in_file_id
3410: AND seq_num = p_seq_num
3411: --AND ext_data_elmt_in_rcd_id = l_ext_data_elmt_in_rcd_id

Line 3420: FROM ben_ext_where_clause

3416: elsif p_record_name is not null then
3417: l_ext_data_elmt_id := null ;
3418: SELECT 'Y'
3419: INTO l_temp
3420: FROM ben_ext_where_clause
3421: WHERE cond_ext_data_elmt_in_rcd_id = l_cond_ext_data_elmt_in_rcd_id
3422: AND seq_num = p_seq_num
3423: AND ext_data_elmt_in_rcd_id = l_ext_data_elmt_in_rcd_id
3424: AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1)

Line 3430: FROM ben_ext_where_clause

3426: elsif p_cond_ext_data_elmt_name is not null then
3427:
3428: SELECT 'Y'
3429: INTO l_temp
3430: FROM ben_ext_where_clause
3431: WHERE ext_data_elmt_id = l_ext_data_elmt_id
3432: AND cond_ext_data_elmt_id = l_cond_ext_data_elmt_id
3433: AND seq_num = p_seq_num
3434: AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1)

Line 3454: FROM ben_ext_where_clause xwc

3450: cursor c_xwc_dup_order (p_ext_rcd_in_file_id number ,
3451: p_ext_data_elmt_in_rcd_id number,
3452: p_ext_data_elmt_id number ) is
3453: SELECT ext_where_clause_id, object_version_number
3454: FROM ben_ext_where_clause xwc
3455: WHERE ( business_group_id is null
3456: or business_group_id = l_new_business_group_id )
3457: and (legislation_code is null
3458: or legislation_code = l_legislation_code )