APPS.GHR_PDC_BUS SQL Statements

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

Line: 15

PROCEDURE CHK_NON_UPDATEABLE_ARGS(p_rec IN ghr_pdc_shd.g_rec_type)

IS

l_proc 	varchar2(72)	:= g_package || 'chk_non_updateable_args';

Line: 125

end chk_non_updateable_args;

Line: 227

       SELECT pay_plan
       FROM   ghr_pay_plans
       WHERE  pay_plan = p_pay_plan;

Line: 458

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

Line: 478

    SELECT sysdate
    INTO   l_effective_date
    FROM   dual;

Line: 507

End insert_validate;

Line: 512

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

Line: 519

  select sysdate
  into   l_effective_date
  from dual;

Line: 534

  chk_non_updateable_args(p_rec);

Line: 559

End update_validate;

Line: 564

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

Line: 574

End delete_validate;