APPS.PA_PROCESS_CI_LINES_PKG dependencies on PA_CI_SUPPLIER_DETAILS

Line 183: from pa_ci_supplier_details

179: cursor get_sc_burden_cost_rate(c_task_id number,
180: c_rlmi_id number,
181: c_currency_code varchar2) IS
182: select sum(burdened_cost)/sum(raw_cost)
183: from pa_ci_supplier_details
184: where task_id = c_task_id
185: and resource_list_member_id = c_rlmi_id
186: and currency_code = c_currency_code
187: and ci_id = (select ci_id from pa_budget_versions where budget_version_id = p_bvid)

Line 1053: from pa_ci_supplier_details

1049: max(to_change_date) effective_to,
1050: sum(NULL) quantity,
1051: sum(raw_cost),
1052: count(*)
1053: from pa_ci_supplier_details
1054: where ci_id = p_ci_id
1055: and task_id = p_task_id
1056: and resource_list_member_id = p_resource_list_member_id
1057: and currency_code = p_currency_code;