APPS.IGC_CBC_PA_BC_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 153

   /* Cursor select all projects from CC account lines table */
   CURSOR c_acct_info IS
     SELECT DISTINCT project_id
       FROM igc_cc_acct_lines
      WHERE cc_acct_line_id IN
        (SELECT cc_acct_line_id
           FROM igc_cc_interface_v a
          WHERE cc_header_id     = p_header_id
            AND budget_dest_flag = 'C'
            AND actual_flag      = p_actual_flag
            AND document_type    = p_doc_type )
        AND project_id IS NOT NULL ;

Line: 226

       UPDATE igc_cc_interface_v v1
          SET v1.pa_flag = 'Y',
              v1.result_code_source = 'P',
              v1.period_name =
              ( SELECT min(per.period_name)
                      FROM gl_period_statuses per
                     WHERE per.application_id   = 101
                           AND per.adjustment_period_flag='N'
                           AND per.set_of_books_id  = p_sobid
                           AND v1.cc_transaction_date
                       BETWEEN per.start_date
                           AND per.end_date
               )
        WHERE cc_header_id     = p_header_id
          AND budget_dest_flag = 'C'
          AND actual_flag      = p_actual_flag
          AND document_type    = p_doc_type
          AND cc_acct_line_id IN
          (SELECT cc_acct_line_id
             FROM igc_cc_acct_lines
            WHERE cc_header_id = p_header_id
              AND project_id = c_acct_info_rec.project_id
              AND project_id IS  NOT NULL);

Line: 257

   END LOOP; --End of interface update

Line: 582

SELECT distinct cbc_result_code, cc_header_id
FROM igc_cc_interface
WHERE cc_header_id = p_header_id;

Line: 597

	SELECT distinct severity_rank INTO l_sev_rank
	FROM igc_cc_result_code_ranks
	WHERE funds_checker_code = l_result_code.cbc_result_code;

Line: 611

SELECT distinct popup_messg_code INTO l_h_code
FROM igc_cc_result_code_ranks
WHERE severity_rank = l_min_sev_rank
AND action = decode(p_mode,'F','R',p_mode);

Line: 847

   SELECT min(IGC_CBC_FUNDS_CHECKER.Get_Rank(cbc_result_code))
     INTO l_rank
     FROM igc_cc_interface_v
    WHERE cc_header_id     = p_header_id
      AND budget_dest_flag = 'C'
      AND actual_flag      = p_actual_flag
      AND document_type    = p_doc_type
      AND cbc_result_code IS NOT NULL;

Line: 895

     SELECT count(DISTINCT CODE_COMBINATION_ID)
       FROM igc_cc_interface_v  a
      WHERE cc_header_id         = p_header_id
            AND budget_dest_flag = 'C'
            AND actual_flag      = p_actual_flag
            AND document_type    = p_doc_type
            AND pa_flag ='Y'
     HAVING count(DISTINCT CODE_COMBINATION_ID)  > 1
     GROUP BY cc_acct_line_id;