DBA Data[Home] [Help]

APPS.PA_FUNDS_CONTROL_PKG1 dependencies on PA_PROJECT_TYPES

Line 608: ,pa_project_types_all pt

604: ,decode(pkt.parent_bc_packet_id,NULL,'RAW','BURDEN')
605: ,'RAW') line_type
606: from pa_bc_packets pkt
607: ,pa_projects_all pp
608: ,pa_project_types_all pt
609: where pkt.packet_id = p_packet_id
610: and pkt.document_line_id is NOT NULL -- with R12 this check is not sufficient to find if the PO is an CWK PO
611: and pa_funds_control_utils2.is_CWK_PO(pkt.document_header_id,pkt.document_line_id
612: ,pkt.document_distribution_id,pkt.org_id) = 'Y' -- R12 Funds management uptake

Line 4549: pa_project_types ppt

4545: g_doc_line_id_tab,
4546: g_burden_type_tab
4547: from pa_bc_packets pbc ,
4548: pa_projects_all pp,
4549: pa_project_types ppt
4550: where pbc.document_type = 'PO'
4551: and pbc.summary_record_flag = 'Y'
4552: and pbc.document_line_id = c_rate_po.document_line_id
4553: and pbc.document_header_id = c_rate_po.document_header_id

Line 4582: pa_project_types ppt

4578: g_doc_line_id_tab,
4579: g_burden_type_tab
4580: from pa_bc_commitments pbc,
4581: pa_projects_all pp,
4582: pa_project_types ppt
4583: where pbc.document_type = 'PO'
4584: and pbc.summary_record_flag = 'Y'
4585: --and pbc.burden_cost_flag = 'N'
4586: and pbc.parent_bc_packet_id is NULL

Line 6668: FROM pa_project_types ppt,

6664: pbc.document_distribution_id ,
6665: pbc.task_id,
6666: pbc.expenditure_item_date,
6667: pbc.expenditure_type
6668: FROM pa_project_types ppt,
6669: pa_projects_all pp,
6670: pa_tasks ptk,
6671: pa_bc_packets pbc
6672: WHERE