APPS.PER_RI_LCW_REG_PKG dependencies on PER_RI_SETUP_SUB_TASKS

Line 30: FROM per_ri_setup_sub_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)
30: FROM per_ri_setup_sub_tasks
31: WHERE setup_task_code = p_setup_task_code;
32:
33:
34: CURSOR csr_get_max_entry_seq (p_menu_id number) IS

Line 42: FROM per_ri_setup_sub_tasks psst,fnd_territories_vl ter

38:
39: --To be changed as soon as the issue with table's PK is resolved
40: Cursor chk_sub_task_exists IS
41: SELECT psst.setup_sub_task_sequence
42: FROM per_ri_setup_sub_tasks psst,fnd_territories_vl ter
43: WHERE psst.setup_sub_task_code = p_setup_sub_task_code;
44: -- AND psst.setup_task_code = 'LCW_' || p_workbench_item_code
45: -- AND psst.legislation_code= p_legislation_code;
46:

Line 183: FROM per_ri_setup_sub_tasks

179: Is
180:
181: CURSOR csr_chk_sub_task_exists IS
182: SELECT 1
183: FROM per_ri_setup_sub_tasks
184: WHERE setup_task_code = p_setup_task_code;
185:
186: CURSOR csr_task_object_version_num IS
187: SELECT object_version_number