[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
Select nvl(imp.XFACE_CWK_TIMECARDS_FLAG ,'N')
from pa_implementations_all imp
where imp.org_id = nvl(p_proj_org_id,-99) ; /*5368274*/
SELECT resource_list_member_id
FROM pa_bc_packets pkt
WHERE pkt.project_id = p_project_id
AND pkt.task_id = p_task_id
AND pkt.budget_version_id = p_budget_version_id
AND ((p_document_type = 'PO'
AND pkt.document_header_id = p_document_header_id)
OR
p_document_type = 'EXP'
)
AND pkt.document_line_id = p_document_line_id
AND NVL(pkt.summary_record_flag,'N') = 'Y'
AND pkt.balance_posted_flag = 'N'
AND pkt.status_code in ('P','L','A','B','C')
AND substr(nvl(pkt.result_code,'P'),1,1) = 'P'
AND pkt.document_type = 'PO'
AND (( pkt.expenditure_type = p_expenditure_type
and p_line_type = 'BURDEN'
and EXISTS (select null
from pa_projects_all pp
,pa_project_types_all pt
where pt.project_type = pp.project_type
and pt.org_id = pp.org_id /*5368274*/
and pp.project_id = pkt.project_id
and NVL(pt.burden_amt_display_method,'N') = 'D'
))
OR
(p_line_type = 'RAW'
and pkt.parent_bc_packet_id is NULL
and EXISTS (select null
from pa_projects_all pp
,pa_project_types_all pt
where pt.project_type = pp.project_type
and pt.org_id = pp.org_id /*5368274*/
and pp.project_id = pkt.project_id
and NVL(pt.burden_amt_display_method,'N') = 'D'
))
OR
(EXISTS (select null
from pa_projects_all pp
,pa_project_types_all pt
where pt.project_type = pp.project_type
and pt.org_id = pp.org_id /*5368274*/
and pp.project_id = pkt.project_id
and NVL(pt.burden_amt_display_method,'N') <> 'D'
)
)
) ;
SELECT resource_list_member_id
FROM pa_bc_commitments_all com
WHERE com.project_id = p_project_id
AND com.task_id = p_task_id
AND com.budget_version_id = p_budget_version_id
AND ((p_document_type = 'PO'
AND com.document_header_id = p_document_header_id)
OR
p_document_type = 'EXP'
)
AND com.document_line_id = p_document_line_id
AND com.document_type = 'PO'
AND NVL(com.summary_record_flag,'N') = 'Y'
AND (( com.expenditure_type = p_expenditure_type
and p_line_type = 'BURDEN'
and EXISTS (select null
from pa_projects_all pp
,pa_project_types_all pt
where pt.project_type = pp.project_type
and pt.org_id = pp.org_id /*5368274*/
and pp.project_id = com.project_id
and NVL(pt.burden_amt_display_method,'N') = 'D'
))
OR
(p_line_type = 'RAW'
and com.parent_bc_packet_id is NULL
and EXISTS (select null
from pa_projects_all pp
,pa_project_types_all pt
where pt.project_type = pp.project_type
and pt.org_id = pp.org_id /*5368274*/
and pp.project_id = com.project_id
and NVL(pt.burden_amt_display_method,'N') = 'D'
))
OR
(EXISTS (select null
from pa_projects_all pp
,pa_project_types_all pt
where pt.project_type = pp.project_type
and pt.org_id = pp.org_id /*5368274*/
and pp.project_id = com.project_id
and NVL(pt.burden_amt_display_method,'N') <> 'D'
)
)
) ;
select max(pbv.budget_version_id)
INTO l_bdgt_version_id
FROM pa_budget_versions pbv
,pa_budget_types bdgttype
,pa_budgetary_control_options pbct
WHERE pbv.project_id = p_project_id
AND pbv.current_flag = 'N'
AND pbv.budget_status_code = 'W'
AND bdgttype.budget_type_code = pbv.budget_type_code
AND bdgttype.budget_amount_code = 'C'
AND pbct.project_id = pbv.project_id
AND pbct.BDGT_CNTRL_FLAG = 'Y'
AND pbct.BUDGET_TYPE_CODE = pbv.budget_type_code
AND NVL(pbct.EXTERNAL_BUDGET_CODE,'GL') = p_ext_bdgt_type ;
select max(pbv.budget_version_id)
INTO l_bdgt_version_id
FROM pa_budget_versions pbv
,pa_budget_types bdgttype
,pa_budgetary_control_options pbct
WHERE pbv.project_id = p_project_id
AND pbv.current_flag = 'Y'
AND pbv.budget_status_code = 'B'
AND bdgttype.budget_type_code = pbv.budget_type_code
AND bdgttype.budget_amount_code = 'C'
AND pbct.project_id = pbv.project_id
AND pbct.BDGT_CNTRL_FLAG = 'Y'
AND pbct.BUDGET_TYPE_CODE = pbv.budget_type_code
AND NVL(pbct.EXTERNAL_BUDGET_CODE,'GL') = p_ext_bdgt_type ;
SELECT sm.expenditure_type
FROM pa_bc_commitments_all sm
,pa_projects_all pp
,pa_project_types_all pt
WHERE sm.summary_record_flag = 'Y'
AND sm.project_id = p_project_id
AND sm.task_id = p_task_id
AND sm.document_line_id = p_doc_line_id
AND sm.parent_bc_packet_id is not Null
AND nvl(sm.comm_tot_bd_amt,0) <> 0
AND pp.project_id = sm.project_id
AND pt.project_type = pp.project_type
AND pt.org_id = pp.org_id /*5368274*/
AND NVL(pt.burden_amt_display_method,'N') = 'D';
SELECT sm.expenditure_type
FROM pa_bc_packets sm
,pa_projects_all pp
,pa_project_types_all pt
WHERE sm.summary_record_flag = 'Y'
AND sm.project_id = p_project_id
AND sm.task_id = p_task_id
AND sm.document_line_id = p_doc_line_id
AND sm.parent_bc_packet_id is not Null
AND sm.balance_posted_flag <> 'Y'
AND sm.status_code in ('A','C','B','P')
AND substr(sm.result_code,1,1) = 'P'
AND nvl(sm.comm_tot_bd_amt,0) <> 0
AND pp.project_id = sm.project_id
AND pt.project_type = pp.project_type
AND pt.org_id = pp.org_id /*5368274*/
AND NVL(pt.burden_amt_display_method,'N') = 'D';
Select 'Y'
INTO l_error_flag
From Dual
Where Exists (Select null
from pa_cost_base_cost_codes icc
,pa_cost_base_exp_types exp
,pa_cost_bases base
where icc.cost_base = exp.cost_base
and icc.cost_plus_structure = exp.cost_plus_structure
and base.cost_base = icc.cost_base
and icc.ind_cost_code NOT IN (l_exp_string)
and exp.expenditure_type = p_exp_type
and base.cost_base = l_cost_base
and icc.cost_plus_structure = l_cost_plus_structure
and icc.cost_base_type = 'INDIRECT COST') ;
Select count(*)
INTO l_cwkbdCount
from pa_cost_base_cost_codes icc
,pa_cost_base_exp_types exp
,pa_cost_bases base
where icc.cost_base = exp.cost_base
and icc.cost_plus_structure = exp.cost_plus_structure
and base.cost_base = icc.cost_base
and icc.ind_cost_code IN (l_exp_string)
and exp.expenditure_type = p_exp_type
and base.cost_base = l_cost_base
and icc.cost_plus_structure = l_cost_plus_structure
and icc.cost_base_type = 'INDIRECT COST' ;