APPS.BEN_RT_ASNT_CACHE SQL Statements

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

Line: 50

    select asr.VRBL_RT_PRFL_ID,
           ass.formula_id,
           asr.excld_flag
    from   ben_asnt_set_rt_f asr,
           hr_assignment_sets ass
    where  p_effective_date
           between asr.effective_start_date
           and     asr.effective_end_date
    and    asr.assignment_set_id = ass.assignment_set_id
    and    asr.VRBL_RT_PRFL_ID = p_VRBL_RT_PRFL_ID
    order  by asr.VRBL_RT_PRFL_ID,
           decode(asr.excld_flag,'Y',1,2),
           asr.ordr_num;

Line: 151

    g_asntlookup.delete(l_hv);