APPS.PA_FUNDS_CONTROL_PKG1 dependencies on IGC_CC_ACCT_LINES

Line 9120: igc_cc_acct_lines igc,

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
9124: WHERE igc.cc_header_id = gl.reference1

Line 9188: and exists (select 1 from igc_cc_acct_lines igcc where igcc.cc_acct_line_id = igc.cc_acct_line_id

9184: and glp.closing_status = 'O'
9185: and glp.adjustment_period_flag = 'N'
9186: and igc.cc_transaction_date between glp.start_date and glp.end_date
9187: and glp.set_of_books_id = igc.set_of_books_id
9188: and exists (select 1 from igc_cc_acct_lines igcc where igcc.cc_acct_line_id = igc.cc_acct_line_id
9189: and project_id >0);
9190:
9191:
9192: BEGIN

Line 9346: igc_cc_acct_lines igc,

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
9350: AND igchead.cc_header_id = igc.cc_header_id

Line 9431: igc_cc_acct_lines igc,

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,
9434: pa_implementations_all imp
9435: WHERE igc.cc_header_id = p_reference2