DBA Data[Home] [Help]

APPS.CN_PMT_TRANS_PKG dependencies on CN_COMMISSION_LINES

Line 189: -- cn_commission_lines

185: -- Description: Insert Record API called from Create Worksheet
186: -- If the User calls this Table Hander
187: -- we need need to check the pay by transaction value
188: -- if the value is N we need to insert the record from
189: -- cn_commission_lines
190: -- if the value is Y then we need to insert from
191: -- cn_srp_periods
192: -- for all Quota ID and the Null QUOTA ID
193: -- Called from : cnvwkshb.pls ( Worksheet Creation )

Line 542: FROM cn_commission_lines cl,

538: g_last_update_login,
539: cl.org_id,
540: 1,
541: cl.processed_date
542: FROM cn_commission_lines cl,
543: cn_quotas_all pe,
544: cn_quota_pay_elements_all qp,
545: cn_srp_payee_assigns_all spayee
546: WHERE cl.srp_payee_assign_id IS NOT NULL

Line 652: FROM cn_commission_lines cl,

648: --Bug 3080846 for who columns
649: cl.org_id,
650: 1,
651: cl.processed_date
652: FROM cn_commission_lines cl,
653: cn_quotas_all pe,
654: cn_quota_pay_elements_all qp
655: WHERE cl.credited_salesrep_id = p_salesrep_id
656: AND cl.processed_period_id <= p_pay_period_id