APPS.HR_WPM_IMPORT_LIB_OBJ_API SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 120

  cursor  bg_cur(cur_p_org_id number) is select BUSINESS_GROUP_ID into l_bg_id from hr_organization_units where ORGANIZATION_ID=cur_p_org_id;

Line: 123

    select 'Y',BUSINESS_GROUP_ID
    from   ben_eligy_prfl_f
    where  eligy_prfl_id = cur_p_eligy_prfl_id
    and    cur_p_effective_date <= nvl(effective_end_date,to_date('31-12-4712','DD-MM-YYYY'))
    and    cur_p_effective_date >= effective_start_date
    and    stat_cd='A' ;