APPS.BEN_EXTRACT_SEED dependencies on BEN_EXT_WHERE_CLAUSE

Line 2465: from ben_Ext_where_clause

2461: /* If the Same Sequence Find Delete the Record for the Sequence */
2462: declare
2463: cursor c1 (c_ext_rcd_in_file_id number) is
2464: select 'x'
2465: from ben_Ext_where_clause
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'

Line 3205: from ben_ext_where_clause

3201:
3202:
3203: cursor c_ext_where_clause (p_ext_data_elmt_in_rcd_id number) is
3204: select ext_where_clause_id,object_version_number
3205: from ben_ext_where_clause
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

Line 3463: FROM ben_ext_where_clause

3459: l_ext_data_elmt_in_rcd_id := null ;
3460:
3461: SELECT 'Y'
3462: INTO l_temp
3463: FROM ben_ext_where_clause
3464: WHERE cond_ext_data_elmt_in_rcd_id = l_cond_ext_data_elmt_in_rcd_id
3465: AND ext_rcd_in_file_id = l_ext_rcd_in_file_id
3466: AND seq_num = p_seq_num
3467: --AND ext_data_elmt_in_rcd_id = l_ext_data_elmt_in_rcd_id

Line 3476: FROM ben_ext_where_clause

3472: elsif p_record_name is not null then
3473: l_ext_data_elmt_id := null ;
3474: SELECT 'Y'
3475: INTO l_temp
3476: FROM ben_ext_where_clause
3477: WHERE cond_ext_data_elmt_in_rcd_id = l_cond_ext_data_elmt_in_rcd_id
3478: AND seq_num = p_seq_num
3479: AND ext_data_elmt_in_rcd_id = l_ext_data_elmt_in_rcd_id
3480: AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1)

Line 3486: FROM ben_ext_where_clause

3482: elsif p_cond_ext_data_elmt_name is not null then
3483:
3484: SELECT 'Y'
3485: INTO l_temp
3486: FROM ben_ext_where_clause
3487: WHERE ext_data_elmt_id = l_ext_data_elmt_id
3488: AND cond_ext_data_elmt_id = l_cond_ext_data_elmt_id
3489: AND seq_num = p_seq_num
3490: AND nvl( l_new_business_group_id, -1) = nvl(business_group_id , -1)

Line 3510: FROM ben_ext_where_clause xwc

3506: cursor c_xwc_dup_order (p_ext_rcd_in_file_id number ,
3507: p_ext_data_elmt_in_rcd_id number,
3508: p_ext_data_elmt_id number ) is
3509: SELECT ext_where_clause_id, object_version_number
3510: FROM ben_ext_where_clause xwc
3511: WHERE ( business_group_id is null
3512: or business_group_id = l_new_business_group_id )
3513: and (legislation_code is null
3514: or legislation_code = l_legislation_code )