APPS.PER_CTK_BUS dependencies on PER_CHECKLISTS

Line 33: , per_checklists ckl

29: select pbg.security_group_id,
30: pbg.legislation_code
31: from per_business_groups_perf pbg
32: , per_tasks_in_checklist tic
33: , per_checklists ckl
34: where tic.task_in_checklist_id = p_task_in_checklist_id
35: and tic.checklist_id = ckl.checklist_id
36: and pbg.business_group_id = ckl.business_group_id;
37: --

Line 105: , per_checklists ckl

101: cursor csr_leg_code is
102: select pbg.legislation_code
103: from per_business_groups_perf pbg
104: , per_tasks_in_checklist tic
105: , per_checklists ckl
106: where tic.task_in_checklist_id = p_task_in_checklist_id
107: and tic.checklist_id = ckl.checklist_id
108: and pbg.business_group_id = ckl.business_group_id;
109:

Line 183: from per_checklists ckl

179: -- Declare cursor to check name is unique.
180: --
181: cursor csr_ckl_id is
182: select null
183: from per_checklists ckl
184: where ckl.checklist_id = p_checklist_id;
185: --
186: begin
187: IF g_debug THEN hr_utility.set_location('Entering:'||l_proc, 10); END IF;

Line 449: ,p_business_group_id in per_checklists.business_group_id%TYPE

445: -- ---------------------------------------------------------------------------
446: --
447: procedure chk_elig_prfl_id
448: (p_eligibility_profile_id in per_tasks_in_checklist.eligibility_profile_id%TYPE
449: ,p_business_group_id in per_checklists.business_group_id%TYPE
450: ,p_effective_date in date
451: ) is
452: --
453: -- Declare local variables

Line 494: ,p_business_group_id in per_checklists.business_group_id%TYPE

490: -- ---------------------------------------------------------------------------
491: --
492: procedure chk_elig_obj_id
493: (p_elig_obj_id in per_tasks_inchecklist.eligibility_profile_id%TYPE
494: ,p_business_group_id in per_checklists.business_group_id%TYPE
495: ,p_effective_date in date
496: ) is
497: --
498: -- Declare local variables