APPS.PER_QH_MAINTAIN_QUERY dependencies on PER_CHECKLIST_ITEMS

Line 392: from per_checklist_items

388: cursor csr_checklist
389: (p_person_id number
390: ,p_item_code varchar2) is
391: select *
392: from per_checklist_items
393: where person_id=p_person_id
394: and item_code=p_item_code;
395: --
396: cursor csr_country

Line 485: chk_rec per_checklist_items%rowtype;

481: pgp_rec pay_people_groups%rowtype;
482: scl_rec hr_soft_coding_keyflex%rowtype;
483: pyp_rec per_pay_proposals%rowtype;
484: dpf_rec per_deployment_factors%rowtype;
485: chk_rec per_checklist_items%rowtype;
486: --
487: l_end_of_time date;
488: l_legislation_code varchar2(150);
489: l_proc varchar2(72) := g_package||'onerow';