DBA Data[Home] [Help]

APPS.PA_FUNDS_CONTROL_PKG dependencies on PA_PROJECTS_ALL

Line 1213: pa_projects_all pp

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

Line 5891: pa_projects_all pp,

5887: pa_bc_packets pbc,
5888: pa_budget_versions pbv,
5889: pa_budget_entry_methods pm,
5890: pa_budgetary_control_options pb,
5891: pa_projects_all pp,
5892: pa_resource_list_members rlm,
5893: PA_RESOURCE_LISTS_ALL_BG list
5894: WHERE pbc.packet_id = p_packet_id
5895: AND pbc.budget_version_id = pbv.budget_version_id

Line 7427: pa_projects_all pp,

7423: pbc.document_line_id,
7424: bv.resource_list_id,
7425: pbc.vendor_id
7426: FROM pa_bc_packets pbc,
7427: pa_projects_all pp,
7428: pa_budget_versions bv,
7429: pa_budget_entry_methods pm,
7430: pa_expenditure_types type,
7431: pa_expenditure_items_all ei

Line 7583: ,pa_projects_all pp

7579: ,decode(NVL(pt.burden_amt_display_method,'N'),'D'
7580: ,decode(parent_bc_packet_id,NULL,'RAW','BURDEN'),'RAW') pkt_line_type
7581: FROM pa_bc_packets pkt
7582: ,pa_project_types_all pt
7583: ,pa_projects_all pp
7584: WHERE pkt.packet_id = p_packet_id
7585: AND pkt.document_line_id is not null
7586: AND pkt.document_type in ('PO','EXP')
7587: ANd NVL(pkt.summary_record_flag,'N') <> 'Y'