APPS.PA_ALLOC_RUN dependencies on PA_ALLOC_TARGET_LINES

Line 767: FROM pa_alloc_target_lines

763: FROM pa_alloc_GL_lines
764: WHERE rule_id = p_rule_id ;
765: CURSOR C_target_lines IS
766: SELECT project_id, task_id, exclude_flag, billable_only_flag
767: FROM pa_alloc_target_lines
768: WHERE rule_id = p_rule_id;
769: CURSOR C_pa_trg_exists IS
770: SELECT 1
771: FROM pa_alloc_target_lines

Line 771: FROM pa_alloc_target_lines

767: FROM pa_alloc_target_lines
768: WHERE rule_id = p_rule_id;
769: CURSOR C_pa_trg_exists IS
770: SELECT 1
771: FROM pa_alloc_target_lines
772: WHERE rule_id = p_rule_id;
773: CURSOR C_check_task( p_project_id IN NUMBER
774: , p_task_id IN NUMBER
775: , p_expnd_item_date IN DATE ) IS

Line 792: FROM pa_alloc_target_lines

788: AND TRUNC(G_sysdate) BETWEEN TRUNC(start_date_active)
789: AND TRUNC(nvl(end_date_active, G_sysdate));
790: CURSOR C_fixed_percent IS
791: SELECT nvl(sum(NVL(line_percent,0)),0)
792: FROM pa_alloc_target_lines
793: WHERE rule_id = p_rule_id;
794: CURSOR C_billable_task( p_task_id IN NUMBER
795: , p_billable_only_flag IN VARCHAR2 ) IS
796: SELECT 1

Line 2047: FROM pa_alloc_target_lines

2043: , project_id
2044: , task_id
2045: , billable_only_flag
2046: , line_percent
2047: FROM pa_alloc_target_lines
2048: WHERE rule_id = p_rule_id
2049: ORDER BY 1, 2;
2050: target_lines_rec c_alloc_target_lines%ROWTYPE;
2051: Cursor c_chargeable_tasks_in_proj (x_project_id IN NUMBER,

Line 2078: FROM pa_alloc_target_lines

2074: AND budget_type_code = p_bas_budget_type_code
2075: AND budget_entry_method_code = p_bas_budget_entry_method_code );
2076: CURSOR C_target_line_exists IS
2077: SELECT 1
2078: FROM pa_alloc_target_lines
2079: WHERE rule_id = p_rule_id;
2080: v_trg_extn_tabtype PA_CLIENT_EXTN_ALLOC.ALLOC_TARGET_TABTYPE;
2081: v_top_task_id NUMBER;
2082: v_retcode NUMBER;

Line 8787: from pa_alloc_target_lines patl

8783: )
8784: IS
8785: cursor c_target_lines is
8786: select line_num
8787: from pa_alloc_target_lines patl
8788: where rule_id = p_rule_id;
8789: v_commit_count NUMBER ;
8790: v_do_commit VARCHAR2(1);
8791: BEGIN