DBA Data[Home] [Help]

APPS.CN_GET_TX_DATA_PUB dependencies on CN_PERIOD_STATUSES

Line 2808: cn_period_statuses cpsp

2804: FROM cn_commission_headers cch,
2805: jtf_rs_resource_extns_vl re,
2806: jtf_rs_salesreps s,
2807: cn_lookups clt,
2808: cn_period_statuses cpsp
2809: WHERE cch.direct_salesrep_id = s.salesrep_id
2810: AND s.resource_id = re.resource_id
2811: AND cch.processed_period_id = cpsp.period_id
2812: AND cch.trx_type = clt.lookup_code(+)

Line 2826: cn_period_statuses cpsp

2822: FROM cn_comm_lines_api ccla,
2823: jtf_rs_resource_extns_vl re,
2824: jtf_rs_salesreps s,
2825: cn_lookups clt,
2826: cn_period_statuses cpsp
2827: WHERE ccla.salesrep_id = s.salesrep_id
2828: AND s.resource_id = re.resource_id
2829: AND ccla.processed_period_id = cpsp.period_id
2830: AND ccla.trx_type = clt.lookup_code(+)