eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_PAYMENT_WORKSHEET_PVT dependencies on CN_SRP_INTEL_PERIODS

Line 1501: l_calc_status cn_srp_intel_periods.processing_status_code%TYPE;

1497: l_get_prd_statuses get_prd_statuses%ROWTYPE; -- Period
1498: l_pmt_trans_rec cn_pmt_trans_pkg.pmt_trans_rec_type; -- PmtTrans
1499: l_batch_rec cn_prepostbatches.posting_batch_rec_type;
1500: l_tmp NUMBER := 0;
1501: l_calc_status cn_srp_intel_periods.processing_status_code%TYPE;
1502: l_ispayee NUMBER := 0;
1503: l_has_access BOOLEAN;
1504:
1505: BEGIN

Line 1722: FROM cn_srp_intel_periods

1718: IF abs(nvl(l_srp_total, 0) - nvl(l_pmt_total, 0) - nvl(l_comm_total, 0)) > .1
1719: THEN
1720: SELECT processing_status_code
1721: INTO l_calc_status
1722: FROM cn_srp_intel_periods
1723: WHERE salesrep_id = p_worksheet_rec.salesrep_id
1724: AND period_id = l_get_payrun_rec.pay_period_id
1725: AND org_id = p_worksheet_rec.org_id;
1726: