APPS.JE_IT_INVOICES_ABOVE_THRESHOLD dependencies on JE_IT_COUNTRY_REP_CODES

Line 742: FROM je_it_country_rep_codes cc

738: AND ((g_inv_acctg_status = 'ACCOUNTED' AND nvl(aid.posted_flag,'N') = 'Y') --TRX_ACCOUNTING_STATUS check
739: OR (g_inv_acctg_status = 'UNACCOUNTED' AND nvl(aid.posted_flag,'N') = 'N')
740: OR g_inv_acctg_status = 'BOTH')
741: AND NOT EXISTS (SELECT 1 -- Black listed countries
742: FROM je_it_country_rep_codes cc
743: WHERE pvs.country = cc.country_code
744: AND aid.accounting_date BETWEEN NVL(cc.rep_exclusion_date_from,sysdate)
745: AND NVL(cc.rep_exclusion_date_to,sysdate));
746: -- AND trunc(sysdate) BETWEEN papf.effective_start_date AND papf.effective_end_date;

Line 1160: FROM je_it_country_rep_codes cc

1156: AND ((g_inv_acctg_status = 'ACCOUNTED' AND nvl(rctd.posting_control_id,-3) <> -3) --TRX_ACCOUNTING_STATUS check
1157: OR (g_inv_acctg_status = 'UNACCOUNTED' AND nvl(rctd.posting_control_id,-3) = -3)
1158: OR g_inv_acctg_status = 'BOTH')
1159: AND NOT EXISTS (SELECT 1 -- Black listed countries
1160: FROM je_it_country_rep_codes cc
1161: WHERE hl.country = cc.country_code
1162: AND rctd.gl_date BETWEEN NVL(cc.rep_exclusion_date_from,sysdate)
1163: AND NVL(cc.rep_exclusion_date_to,sysdate))
1164: group by 222,

Line 1294: FROM je_it_country_rep_codes cc

1290: AND ((g_inv_acctg_status = 'ACCOUNTED' AND nvl(rctd.posting_control_id,-3) <> -3) --TRX_ACCOUNTING_STATUS check
1291: OR (g_inv_acctg_status = 'UNACCOUNTED' AND nvl(rctd.posting_control_id,-3) = -3)
1292: OR g_inv_acctg_status = 'BOTH')
1293: AND NOT EXISTS (SELECT 1 -- Black listed countries
1294: FROM je_it_country_rep_codes cc
1295: WHERE hl.country = cc.country_code
1296: AND rctd.gl_date BETWEEN NVL(cc.rep_exclusion_date_from,sysdate)
1297: AND NVL(cc.rep_exclusion_date_to,sysdate))
1298: group by 222,