APPS.CN_INVOICE_CHANGES_PVT dependencies on CN_SALESREPS

Line 1457: 'FROM cn_period_statuses CPSP, cn_salesreps RSD, cn_commission_headers CCH, '||

1453: 'CCH.direct_salesrep_id,CCH.invoice_number,CCH.line_number, '||
1454: 'CCH.revenue_type,CCH.split_pct,RSD.employee_number, CCH.comm_lines_api_id, '||
1455: --Modified for Crediting Bug
1456: 'API.terr_id, NVL(API.preserve_credit_override_flag,''N'') '||
1457: 'FROM cn_period_statuses CPSP, cn_salesreps RSD, cn_commission_headers CCH, '||
1458: 'cn_lookups CLT, cn_lookups CLR, cn_lookups CLS, cn_lookups CLRV, '||
1459: 'cn_lookups CLAD, cn_revenue_classes CNR, cn_quotas CQ, cn_trx_batches CTB, '||
1460: -- Modified for Crediting Bug
1461: 'cn_comm_lines_api API '||

Line 1528: 'cn_period_statuses CPSP, cn_salesreps RSD, '||

1524: 'CCLA.revenue_type,CCLA.split_pct,RSD.employee_number, CCLA.comm_lines_api_id, '||
1525: --Modified for Crediting Bug
1526: 'CCLA.terr_id, CCLA.preserve_credit_override_flag '||
1527: 'FROM cn_comm_lines_api CCLA, '||
1528: 'cn_period_statuses CPSP, cn_salesreps RSD, '||
1529: 'cn_revenue_classes CNR, cn_lookups CLT, '||
1530: 'cn_lookups CLRV, cn_lookups CLAD,cn_lookups CLR '||
1531: 'WHERE RSD.salesrep_id = CCLA.salesrep_id '||
1532: 'AND CCLA.processed_period_id = CPSP.period_id '||

Line 1892: cn_salesreps rep

1888: l_line_number NUMBER,
1889: l_revenue_type VARCHAR2) IS
1890: SELECT inv.*,rep.employee_number
1891: FROM cn_invoice_changes inv,
1892: cn_salesreps rep
1893: WHERE inv.salesrep_id = rep.salesrep_id
1894: AND inv.invoice_number = l_invoice_number
1895: AND inv.line_number = l_line_number
1896: AND inv.revenue_type = l_revenue_type;