[Home] [Help]
406: SELECT irs.ind_rate_sch_id,
407: p.cost_ind_sch_fixed_date
408: INTO l_sch_id,l_sch_date
409: FROM pa_tasks t,
410: pa_projects_all p,
411: pa_ind_rate_schedules irs
412: WHERE t.task_id = p_task_id
413: AND t.project_id = p.project_id
414: AND t.project_id = irs.project_id
603: ,decode(pt.burden_amt_display_method,'D'
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
2700: AND pobc.distribution_type <> 'REQUISITION' )
2701: /** Bug fix : 2347699 added this check to make sure that project is not cross charged **/
2702: /** BugFix : If grants and projects enables in the same ou then errors with no data found in cursors*/
2703: AND EXISTS (SELECT 1
2704: FROM pa_projects_all pp,
2705: pa_implementations_all imp
2706: WHERE pp.project_id = pobc.pa_project_id
2707: AND pp.org_id = imp.org_id
2708: AND imp.set_of_books_id = pobc.ledger_id )
2778: )
2779: /** Bug fix : 2347699 added this check to make sure that project is not cross charged **/
2780: /** BugFix : If grants and projects enables in the same ou then errors with no data found in cursors*/
2781: AND EXISTS (SELECT 1
2782: FROM pa_projects_all pp,
2783: pa_implementations_all imp
2784: WHERE pp.project_id = apd.project_id
2785: AND pp.org_id = imp.org_id
2786: AND imp.set_of_books_id = apd.set_of_books_id )
2836: )
2837: )
2838: )
2839: AND EXISTS (SELECT 1
2840: FROM pa_projects_all pp,
2841: pa_implementations_all imp
2842: WHERE pp.project_id = apd.project_id
2843: AND pp.org_id = imp.org_id
2844: AND imp.set_of_books_id = apd.set_of_books_id )
4544: g_bdamt_balance_tab,
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
4577: g_bdamt_balance_tab,
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'
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
6673: ppt.project_type = pp.project_type
7591: SELECT start_date,
7592: completion_date
7593: INTO l_project_start_date,
7594: l_project_end_date
7595: FROM pa_projects_all
7596: WHERE project_id = p_project_id;
7597:
7598: IF p_time_phase_type_code in ('P','G') and l_project_start_date is NULL then
7599: SELECT MIN ( start_date )
9115: and gl.je_category_name in ('Confirmed','Provisional')
9116: and EXISTS
9117: ( SELECT 'Project Related'
9118: FROM pa_tasks pkt,
9119: pa_projects_all pp,
9120: igc_cc_acct_lines igc,
9121: igc_cc_det_pf igcpf,
9122: igc_cc_headers_all igchead,
9123: pa_implementations_all imp
9341: PA_FUNDS_CONTROL_UTILS.get_encum_type_id(igc.project_id,'STD') enc_type_id,
9342: igchead.vendor_id,
9343: pa_bc_packets_s.nextval
9344: FROM pa_tasks pkt,
9345: pa_projects_all pp,
9346: igc_cc_acct_lines igc,
9347: igc_cc_det_pf igcpf,
9348: igc_cc_headers_all igchead
9349: WHERE igc.cc_header_id = p_reference1
9425: igci.cc_acct_line_id pkt_reference3,
9426: pa_bc_packets_s.nextval
9427: FROM
9428: pa_tasks pkt,
9429: pa_projects_all pp,
9430: igc_cc_interface igci,
9431: igc_cc_acct_lines igc,
9432: igc_cc_headers_all igchead,
9433: gl_period_statuses gl,