DBA Data[Home] [Help]

APPS.CN_GET_TX_DATA_PUB dependencies on CN_PERIOD_STATUSES

Line 2809: cn_period_statuses cpsp

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

Line 2827: cn_period_statuses cpsp

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