APPS.IGC_CC_ARCHIVE_PURGE_PKG dependencies on IGC_CC_MC_ACCT_LINES

Line 1076: FROM igc_cc_mc_acct_lines CML

1072: CONVERSION_TYPE,
1073: CONVERSION_DATE,
1074: CONVERSION_RATE,
1075: CC_FUNC_WITHHELD_AMT
1076: FROM igc_cc_mc_acct_lines CML
1077: WHERE CML.cc_acct_line_id IN
1078: ( SELECT ACLH.cc_acct_line_id
1079: FROM igc_cc_acct_line_history ACLH
1080: WHERE ACLH.cc_header_id IN

Line 4997: FROM igc_cc_mc_acct_lines CAL

4993: -- --------------------------------------------------------------------
4994: -- Delete all MRC Account Line History Lines for related CC Header IDs.
4995: -- --------------------------------------------------------------------
4996: DELETE
4997: FROM igc_cc_mc_acct_lines CAL
4998: WHERE CAL.cc_acct_line_id IN
4999: ( SELECT ACLH.cc_acct_line_id
5000: FROM igc_cc_acct_line_history ACLH
5001: WHERE ACLH.cc_header_id = l_cc_header_id

Line 5011: g_debug_msg := 'Number Rows Deleted from IGC_CC_MC_ACCT_LINES for CC Header ID : ' ||

5007: );
5008:
5009: l_num_mc_acct_pur := SQL%ROWCOUNT;
5010: IF (g_debug_mode = 'Y') THEN
5011: g_debug_msg := 'Number Rows Deleted from IGC_CC_MC_ACCT_LINES for CC Header ID : ' ||
5012: l_cc_header_id || ' is : ' || to_char(SQL%ROWCOUNT);
5013: Output_Debug (l_full_path, p_debug_msg => g_debug_msg);
5014: END IF;
5015: