APPS.CN_PAYMENT_WORKSHEET_PVT dependencies on CN_SRP_INTEL_PERIODS

Line 1503: l_calc_status cn_srp_intel_periods.processing_status_code%TYPE;

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

Line 1724: FROM cn_srp_intel_periods

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