DBA Data[Home] [Help]

APPS.PA_FUNDS_CONTROL_PKG dependencies on PA_PROJECTS_ALL

Line 1217: pa_projects_all pp

1213: NVL(ppt.burden_amt_display_method,'S'),'N')
1214: -- decode(NVL(ppt.burden_amt_display_method,'S'), 'S','SAME','D','DIFFERENT'),'NONE')
1215: INTO l_burden_method
1216: FROM pa_project_types ppt,
1217: pa_projects_all pp
1218: WHERE
1219: ppt.project_type = pp.project_type
1220: AND pp.project_id = p_project_id;
1221:

Line 6034: pa_projects_all pp,

6030: pa_bc_packets pbc,
6031: pa_budget_versions pbv,
6032: pa_budget_entry_methods pm,
6033: pa_budgetary_control_options pb,
6034: pa_projects_all pp,
6035: pa_resource_list_members rlm,
6036: PA_RESOURCE_LISTS_ALL_BG list
6037: WHERE pbc.packet_id = p_packet_id
6038: AND pbc.budget_version_id = pbv.budget_version_id

Line 7625: pa_projects_all pp,

7621: pbc.document_line_id,
7622: bv.resource_list_id,
7623: pbc.vendor_id
7624: FROM pa_bc_packets pbc,
7625: pa_projects_all pp,
7626: pa_budget_versions bv,
7627: pa_budget_entry_methods pm,
7628: pa_expenditure_types type,
7629: pa_expenditure_items_all ei

Line 7781: ,pa_projects_all pp

7777: ,decode(NVL(pt.burden_amt_display_method,'N'),'D'
7778: ,decode(parent_bc_packet_id,NULL,'RAW','BURDEN'),'RAW') pkt_line_type
7779: FROM pa_bc_packets pkt
7780: ,pa_project_types_all pt
7781: ,pa_projects_all pp
7782: WHERE pkt.packet_id = p_packet_id
7783: AND pkt.document_line_id is not null
7784: AND pkt.document_type in ('PO','EXP')
7785: ANd NVL(pkt.summary_record_flag,'N') <> 'Y'