APPS.BEN_ORG_OBJECT SQL Statements

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

Line: 219

    select bus.*
    from   per_business_groups bus
    where  bus.business_group_id = p_business_group_id
    and    p_effective_date
           between bus.date_from
           and     nvl(bus.date_to,p_effective_date);

Line: 264

    select org.*
    from   hr_all_organization_units org
    where  org.organization_id = p_organization_id
    and    p_effective_date
           between org.date_from
           and     nvl(org.date_to,p_effective_date);

Line: 310

    select pay.*
    from   pay_all_payrolls_f pay
    where  pay.payroll_id = p_payroll_id
    and    pay.business_group_id = p_business_group_id
    and    p_effective_date
           between pay.effective_start_date
           and     pay.effective_end_date;

Line: 356

    select ben.*
    from   ben_benfts_grp ben
    where  ben.benfts_grp_id = p_benfts_grp_id
    and    ben.business_group_id = p_business_group_id;

Line: 674

  g_cache_bus_rec.delete;

Line: 676

  g_cache_org_rec.delete;

Line: 678

  g_cache_pay_rec.delete;

Line: 680

  g_cache_ben_rec.delete;