APPS.PA_FP_CI_MERGE dependencies on PA_CI_DIRECT_COST_DETAILS

Line 13782: From pa_ci_direct_cost_details

13778: ,l_change_reason_code
13779: ,l_change_description
13780: ,l_effective_from_tbl
13781: ,l_effective_to_tbl
13782: From pa_ci_direct_cost_details
13783: where ci_id = p_ci_id_from ;
13784:
13785: select dc_line_id
13786: ,task_id

Line 13814: From pa_ci_direct_cost_details

13810: ,l_burden_cost_rate_to_tbl
13811: ,l_effective_from_to_tbl
13812: ,l_effective_to_to_tbl
13813: ,l_resource_asgn_id_to_tbl
13814: From pa_ci_direct_cost_details
13815: where ci_id = l_ci_id_to ;
13816:
13817: ins_index := 0;
13818: upd_index := 0;

Line 13981: update pa_ci_direct_cost_details pcdc

13977: END IF;
13978: end if;
13979:
13980: -- bug 9840053: modified the update stmt.
13981: update pa_ci_direct_cost_details pcdc
13982: set (resource_assignment_id, effective_from, effective_to,
13983: planning_resource_rate, burden_cost_rate,
13984: raw_cost, burdened_cost) =
13985: (select prac.resource_assignment_id,

Line 14013: update pa_ci_direct_cost_details pcdc

14009: OR
14010: (pcdc.raw_cost is not null and
14011: nvl(pa_planning_resource_utils.get_rate_based_flag(pcdc.resource_list_member_id), 'N') = 'N'));
14012:
14013: update pa_ci_direct_cost_details pcdc
14014: set (resource_assignment_id, effective_from, effective_to) =
14015: (select prac.resource_assignment_id,
14016: nvl(pcdc.effective_from, pra.planning_start_date),
14017: nvl(pcdc.effective_to, pra.planning_end_date)