DBA Data[Home] [Help]

APPS.IGC_CBC_PA_BC_PKG dependencies on IGC_CC_ACCT_LINES

Line 156: FROM igc_cc_acct_lines

152: p_packet_id NUMBER;
153: /* Cursor select all projects from CC account lines table */
154: CURSOR c_acct_info IS
155: SELECT DISTINCT project_id
156: FROM igc_cc_acct_lines
157: WHERE cc_acct_line_id IN
158: (SELECT cc_acct_line_id
159: FROM igc_cc_interface_v a
160: WHERE cc_header_id = p_header_id

Line 245: FROM igc_cc_acct_lines

241: AND actual_flag = p_actual_flag
242: AND document_type = p_doc_type
243: AND cc_acct_line_id IN
244: (SELECT cc_acct_line_id
245: FROM igc_cc_acct_lines
246: WHERE cc_header_id = p_header_id
247: AND project_id = c_acct_info_rec.project_id
248: AND project_id IS NOT NULL);
249: