APPS.PER_QH_MAINTAIN_QUERY dependencies on PER_CHECKLIST_ITEMS

Line 362: from per_checklist_items

358: cursor csr_checklist
359: (p_person_id number
360: ,p_item_code varchar2) is
361: select *
362: from per_checklist_items
363: where person_id=p_person_id
364: and item_code=p_item_code;
365: --
366: cursor csr_country

Line 455: chk_rec per_checklist_items%rowtype;

451: pgp_rec pay_people_groups%rowtype;
452: scl_rec hr_soft_coding_keyflex%rowtype;
453: pyp_rec per_pay_proposals%rowtype;
454: dpf_rec per_deployment_factors%rowtype;
455: chk_rec per_checklist_items%rowtype;
456: --
457: l_end_of_time date;
458: l_legislation_code varchar2(150);
459: l_proc varchar2(72) := g_package||'onerow';