DBA Data[Home] [Help]

APPS.PA_FUNDS_CONTROL_PKG1 dependencies on IGC_CC_HEADERS_ALL

Line 9122: igc_cc_headers_all igchead,

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
9125: AND igchead.cc_header_id = igc.cc_header_id
9126: AND igcpf.cc_det_pf_line_id = gl.reference4

Line 9177: igc_cc_headers_all igchead,

9173: NULL ,
9174: NULL ,
9175: NULL
9176: FROM igc_cc_interface igc,
9177: igc_cc_headers_all igchead,
9178: psa_bc_xla_events_gt pbgt,
9179: gl_period_statuses glp
9180: WHERE pbgt.event_id = igc.event_id
9181: and igc.cc_header_id = igchead.cc_header_id

Line 9348: igc_cc_headers_all igchead

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
9351: AND igcpf.cc_det_pf_line_id = p_reference4
9352: AND igc.cc_acct_line_id = igcpf.cc_acct_line_id

Line 9432: igc_cc_headers_all igchead,

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
9436: AND p_reference1 = 'CC'