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
8739: WHERE igc.cc_header_id = gl.reference1
8799: and glp.closing_status = 'O'
8800: and glp.adjustment_period_flag = 'N'
8801: and igc.cc_transaction_date between glp.start_date and glp.end_date
8802: and glp.set_of_books_id = igc.set_of_books_id
8803: and exists (select 1 from igc_cc_acct_lines igcc where igcc.cc_acct_line_id = igc.cc_acct_line_id
8804: and project_id >0);
8805:
8806:
8807: BEGIN
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
8962: AND igchead.cc_header_id = igc.cc_header_id
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,
9046: pa_implementations_all imp
9047: WHERE igc.cc_header_id = p_reference2