APPS.IGC_CBC_PA_BC_PKG dependencies on IGC_CC_INTERFACE

Line 159: FROM igc_cc_interface_v a

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
161: AND budget_dest_flag = 'C'
162: AND actual_flag = p_actual_flag
163: AND document_type = p_doc_type )

Line 226: UPDATE igc_cc_interface_v v1

222: Put_Debug_Msg(l_full_path, 'Project Bc enabled');
223: END IF;
224: l_pa_bc_required:=TRUE;
225:
226: UPDATE igc_cc_interface_v v1
227: SET v1.pa_flag = 'Y',
228: v1.result_code_source = 'P',
229: v1.period_name =
230: ( SELECT min(per.period_name)

Line 583: FROM igc_cc_interface

579: l_full_path VARCHAR2(255);
580:
581: CURSOR c_result_code IS
582: SELECT distinct cbc_result_code, cc_header_id
583: FROM igc_cc_interface
584: WHERE cc_header_id = p_header_id;
585:
586: BEGIN
587:

Line 849: FROM igc_cc_interface_v

845: END IF;
846:
847: SELECT min(IGC_CBC_FUNDS_CHECKER.Get_Rank(cbc_result_code))
848: INTO l_rank
849: FROM igc_cc_interface_v
850: WHERE cc_header_id = p_header_id
851: AND budget_dest_flag = 'C'
852: AND actual_flag = p_actual_flag
853: AND document_type = p_doc_type

Line 896: FROM igc_cc_interface_v a

892:
893: --This cursor returns lines which have the same cc_acct_line_id but different code combinations from CC and PA.
894: CURSOR c_int IS
895: SELECT count(DISTINCT CODE_COMBINATION_ID)
896: FROM igc_cc_interface_v a
897: WHERE cc_header_id = p_header_id
898: AND budget_dest_flag = 'C'
899: AND actual_flag = p_actual_flag
900: AND document_type = p_doc_type