APPS.IGC_CC_ARCHIVE_PURGE_PKG dependencies on IGC_CC_MC_ACCT_LINE_HISTORY

Line 1128: FROM igc_cc_mc_acct_line_history CMLH

1124: CONVERSION_TYPE,
1125: CONVERSION_DATE,
1126: CONVERSION_RATE,
1127: CC_FUNC_WITHHELD_AMT
1128: FROM igc_cc_mc_acct_line_history CMLH
1129: WHERE CMLH.cc_acct_line_id IN
1130: ( SELECT ACLH.cc_acct_line_id
1131: FROM igc_cc_acct_line_history ACLH
1132: WHERE ACLH.cc_header_id IN

Line 4975: FROM igc_cc_mc_acct_line_history CALH

4971: -- --------------------------------------------------------------------
4972: -- Delete all MRC Account Line History Lines for related CC Header IDs.
4973: -- --------------------------------------------------------------------
4974: DELETE
4975: FROM igc_cc_mc_acct_line_history CALH
4976: WHERE CALH.cc_acct_line_id IN
4977: ( SELECT ACLH.cc_acct_line_id
4978: FROM igc_cc_acct_line_history ACLH
4979: WHERE ACLH.cc_header_id = l_cc_header_id

Line 4988: g_debug_msg := 'Number Rows Deleted from IGC_CC_MC_ACCT_LINE_HISTORY CC Header ID : ' ||

4984: WHERE ACL.cc_header_id = l_cc_header_id
4985: );
4986:
4987: IF (g_debug_mode = 'Y') THEN
4988: g_debug_msg := 'Number Rows Deleted from IGC_CC_MC_ACCT_LINE_HISTORY CC Header ID : ' ||
4989: l_cc_header_id || ' is : ' || to_char(SQL%ROWCOUNT);
4990: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
4991: END IF;
4992: