DBA Data[Home] [Help]

APPS.PA_FUNDS_CONTROL_PKG1 dependencies on IGC_CC_HEADERS_ALL

Line 8737: igc_cc_headers_all igchead,

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

Line 8792: igc_cc_headers_all igchead,

8788: NULL ,
8789: NULL ,
8790: NULL
8791: FROM igc_cc_interface igc,
8792: igc_cc_headers_all igchead,
8793: psa_bc_xla_events_gt pbgt,
8794: gl_period_statuses glp
8795: WHERE pbgt.event_id = igc.event_id
8796: and igc.cc_header_id = igchead.cc_header_id

Line 8960: igc_cc_headers_all igchead

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

Line 9044: igc_cc_headers_all igchead,

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