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_GET_COMM_PMT_PAID_GRP dependencies on CN_SRP_PERIODS_ALL

Line 148: p_org_id cn_srp_periods_all.org_id%TYPE)

144:
145: CURSOR get_comm_and_pmt(p_salesrep_id jtf_rs_salesreps.salesrep_id%TYPE,
146: p_start_period_id cn_period_statuses_all.period_id%TYPE,
147: p_end_period_id cn_period_statuses_all.period_id%TYPE,
148: p_org_id cn_srp_periods_all.org_id%TYPE)
149: IS
150: SELECT NVL(SUM(NVL(balance2_dtd,0)),0) commission,
151: NVL(SUM(NVL(balance1_dtd,0) - NVL(balance1_ctd,0)),0) paid_pmt
152: FROM cn_srp_periods_all

Line 152: FROM cn_srp_periods_all

148: p_org_id cn_srp_periods_all.org_id%TYPE)
149: IS
150: SELECT NVL(SUM(NVL(balance2_dtd,0)),0) commission,
151: NVL(SUM(NVL(balance1_dtd,0) - NVL(balance1_ctd,0)),0) paid_pmt
152: FROM cn_srp_periods_all
153: WHERE salesrep_id = p_salesrep_id
154: AND period_id BETWEEN p_start_period_id AND p_end_period_id
155: AND credit_type_id = g_credit_type_id
156: AND quota_id IS NULL