[Home] [Help]
755: , p_fixed_amount IN NUMBER
756: , p_expnd_item_date IN DATE ) IS
757: CURSOR C_pa_src_exists IS
758: SELECT 1
759: FROM pa_alloc_source_lines
760: WHERE rule_id = p_rule_id ;
761: CURSOR C_gl_src_exists IS
762: SELECT 1
763: FROM pa_alloc_GL_lines
1276: , class_code
1277: , service_type
1278: , project_id
1279: , task_id
1280: FROM pa_alloc_source_lines
1281: WHERE rule_id = p_rule_id
1282: ORDER BY exclude_flag, line_num;
1283: source_lines_rec c_alloc_source_lines%ROWTYPE;
1284: CURSOR c_leaf_tasks_under_task(p_tsk_id IN NUMBER) IS