DBA Data[Home] [Help]

APPS.PA_FUNDS_CONTROL_PKG1 dependencies on IGC_CC_DET_PF

Line 8736: igc_cc_det_pf igcpf,

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

Line 8774: to_char(igc.cc_det_pf_line_id),

8770: decode(igchead.CC_STATE,'PR','Provisional','Confirmed') Category,
8771: to_char(igc.cc_header_id),
8772: NULL,
8773: NULL,
8774: to_char(igc.cc_det_pf_line_id),
8775: NULL,
8776: igc.CC_TRANSACTION_DATE gl_date,
8777: igc.actual_flag,
8778: glp.period_name,

Line 8959: igc_cc_det_pf igcpf,

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