APPS.PAY_CON_BUS SQL Statements

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

Line: 168

    select count(*)
    into   l_count
    from   per_people_f         ppf,
           per_person_types     ptype
    where  (to_number(to_char(p_from_date,'YYYY')) >=
                to_number(to_char(ppf.effective_start_date,'YYYY')) and
            to_number(to_char(p_from_date,'YYYY'))  <=
                to_number(to_char(ppf.effective_end_date,'YYYY')))
    and    ppf.person_type_id       = ptype.person_type_id
    and    ppf.person_id            = p_person_id
    and    ptype.system_person_type = 'EMP'
    and    ppf.business_group_id    = p_business_group_id;

Line: 264

Procedure insert_validate(p_rec in pay_con_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'insert_validate';

Line: 296

End insert_validate;

Line: 301

Procedure update_validate(p_rec in pay_con_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'update_validate';

Line: 329

End update_validate;

Line: 334

Procedure delete_validate(p_rec in pay_con_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'delete_validate';

Line: 344

End delete_validate;

Line: 357

    select a.legislation_code
    from   per_business_groups a,
           pay_us_contribution_history b
    where b.contr_history_id      = p_contr_history_id
    and   a.business_group_id = b.business_group_id;