DBA Data[Home] [Help]

APPS.PA_FUNDS_CONTROL_PKG1 dependencies on PA_PROJECT_TYPES

Line 593: ,pa_project_types_all pt

589: ,decode(pkt.parent_bc_packet_id,NULL,'RAW','BURDEN')
590: ,'RAW') line_type
591: from pa_bc_packets pkt
592: ,pa_projects_all pp
593: ,pa_project_types_all pt
594: where pkt.packet_id = p_packet_id
595: and pkt.document_line_id is NOT NULL -- with R12 this check is not sufficient to find if the PO is an CWK PO
596: and pa_funds_control_utils2.is_CWK_PO(pkt.document_header_id,pkt.document_line_id
597: ,pkt.document_distribution_id,pkt.org_id) = 'Y' -- R12 Funds management uptake

Line 4260: pa_project_types ppt

4256: g_doc_line_id_tab,
4257: g_burden_type_tab
4258: from pa_bc_packets pbc ,
4259: pa_projects_all pp,
4260: pa_project_types ppt
4261: where pbc.document_type = 'PO'
4262: and pbc.summary_record_flag = 'Y'
4263: and pbc.document_line_id = c_rate_po.document_line_id
4264: and pbc.document_header_id = c_rate_po.document_header_id

Line 4293: pa_project_types ppt

4289: g_doc_line_id_tab,
4290: g_burden_type_tab
4291: from pa_bc_commitments pbc,
4292: pa_projects_all pp,
4293: pa_project_types ppt
4294: where pbc.document_type = 'PO'
4295: and pbc.summary_record_flag = 'Y'
4296: --and pbc.burden_cost_flag = 'N'
4297: and pbc.parent_bc_packet_id is NULL

Line 6325: FROM pa_project_types ppt,

6321: pbc.document_distribution_id ,
6322: pbc.task_id,
6323: pbc.expenditure_item_date,
6324: pbc.expenditure_type
6325: FROM pa_project_types ppt,
6326: pa_projects_all pp,
6327: pa_tasks ptk,
6328: pa_bc_packets pbc
6329: WHERE