[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
588: ,decode(pt.burden_amt_display_method,'D'
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
2653: AND pobc.distribution_type <> 'REQUISITION' )
2654: /** Bug fix : 2347699 added this check to make sure that project is not cross charged **/
2655: /** BugFix : If grants and projects enables in the same ou then errors with no data found in cursors*/
2656: AND EXISTS (SELECT 1
2657: FROM pa_projects_all pp,
2658: pa_implementations_all imp
2659: WHERE pp.project_id = pobc.pa_project_id
2660: AND pp.org_id = imp.org_id
2661: AND imp.set_of_books_id = pobc.ledger_id )
2731: )
2732: /** Bug fix : 2347699 added this check to make sure that project is not cross charged **/
2733: /** BugFix : If grants and projects enables in the same ou then errors with no data found in cursors*/
2734: AND EXISTS (SELECT 1
2735: FROM pa_projects_all pp,
2736: pa_implementations_all imp
2737: WHERE pp.project_id = apd.project_id
2738: AND pp.org_id = imp.org_id
2739: AND imp.set_of_books_id = apd.set_of_books_id )
4255: g_bdamt_balance_tab,
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
4288: g_bdamt_balance_tab,
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'
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
6330: ppt.project_type = pp.project_type
7244: SELECT start_date,
7245: completion_date
7246: INTO l_project_start_date,
7247: l_project_end_date
7248: FROM pa_projects_all
7249: WHERE project_id = p_project_id;
7250:
7251: IF p_time_phase_type_code in ('P','G') and l_project_start_date is NULL then
7252: SELECT MIN ( start_date )
8730: and gl.je_category_name in ('Confirmed','Provisional')
8731: and EXISTS
8732: ( SELECT 'Project Related'
8733: FROM pa_tasks pkt,
8734: pa_projects_all pp,
8735: igc_cc_acct_lines igc,
8736: igc_cc_det_pf igcpf,
8737: igc_cc_headers_all igchead,
8738: pa_implementations_all imp
8953: PA_FUNDS_CONTROL_UTILS.get_encum_type_id(igc.project_id,'STD') enc_type_id,
8954: igchead.vendor_id,
8955: pa_bc_packets_s.nextval
8956: FROM pa_tasks pkt,
8957: pa_projects_all pp,
8958: igc_cc_acct_lines igc,
8959: igc_cc_det_pf igcpf,
8960: igc_cc_headers_all igchead
8961: WHERE igc.cc_header_id = p_reference1
9037: igci.cc_acct_line_id pkt_reference3,
9038: pa_bc_packets_s.nextval
9039: FROM
9040: pa_tasks pkt,
9041: pa_projects_all pp,
9042: igc_cc_interface igci,
9043: igc_cc_acct_lines igc,
9044: igc_cc_headers_all igchead,
9045: gl_period_statuses gl,