DBA Data[Home] [Help]

APPS.PER_RI_LCW_REG_PKG dependencies on PER_RI_SETUP_TASKS

Line 18: FROM per_ri_setup_tasks

14: ,p_msg Out nocopy Varchar2
15: ) Is
16: CURSOR csr_chk_task_exists IS
17: SELECT 1
18: FROM per_ri_setup_tasks
19: WHERE workbench_item_code = p_workbench_item_code
20: AND setup_task_code = p_setup_task_code;
21:
22:

Line 25: FROM per_ri_setup_tasks

21:
22:
23: CURSOR csr_get_max_task_seq IS
24: SELECT max(setup_task_sequence)
25: FROM per_ri_setup_tasks
26: WHERE workbench_item_code = p_workbench_item_code;
27:
28: CURSOR csr_get_max_sub_task_seq IS
29: SELECT max(setup_sub_task_sequence)

Line 188: FROM per_ri_setup_tasks

184: WHERE setup_task_code = p_setup_task_code;
185:
186: CURSOR csr_task_object_version_num IS
187: SELECT object_version_number
188: FROM per_ri_setup_tasks
189: WHERE setup_task_code = p_setup_task_code;
190:
191:
192: l_dummy varchar2(20);