APPS.CN_SCA_TRX_PROC_PVT dependencies on CN_SALESREPS

Line 1261: cn_sca_lines_output CSLO, cn_salesreps CS, cn_comm_lines_api CCLA, cn_sca_headers_interface CSHI

1257: CCLA.SPLIT_PCT,
1258: CCLA.SPLIT_status,
1259: ccla.org_id
1260: from
1261: cn_sca_lines_output CSLO, cn_salesreps CS, cn_comm_lines_api CCLA, cn_sca_headers_interface CSHI
1262: where CS.resource_id = CSLO.resource_id -- added org_id join, since one resource can belong to more than one org
1263: and cslo.org_id = cs.org_id
1264: and ccla.org_id = cslo.org_id
1265: and CCLA.comm_lines_api_id = CSLO.source_trx_id

Line 3277: FROM cn_commission_headers CCH, cn_salesreps CS

3273: CCH.OBJECT_VERSION_NUMBER,
3274: CCH.SPLIT_PCT,
3275: CCH.SPLIT_status,
3276: cch.org_id
3277: FROM cn_commission_headers CCH, cn_salesreps CS
3278: WHERE CCH.adj_comm_lines_api_id = sca_rollback_lines(j)
3279: AND CS.salesrep_id = CCH.direct_salesrep_id
3280: AND (--(CCH.adjust_status IS NULL) or
3281: (CCH.adjust_status <> 'FROZEN')));

Line 3835: FROM cn_commission_headers CCH, cn_salesreps CS

3831: CCH.OBJECT_VERSION_NUMBER,
3832: CCH.SPLIT_PCT,
3833: CCH.SPLIT_status,
3834: cch.org_id
3835: FROM cn_commission_headers CCH, cn_salesreps CS
3836: WHERE CCH.adj_comm_lines_api_id = sca_lines_rollback(j)
3837: AND CS.salesrep_id = CCH.direct_salesrep_id
3838: AND (--(CCH.adjust_status IS NULL) or
3839: (CCH.adjust_status <> 'FROZEN')));