APPS.CN_PREPOST_PVT dependencies on CN_COMMISSION_LINES_ALL

Line 331: FROM cn_commission_lines_all cl,

327: SYSDATE creation_date,
328: FND_GLOBAL.LOGIN_ID last_update_login,
329: SYSDATE last_update_date,
330: FND_GLOBAL.USER_ID last_updated_by*/
331: FROM cn_commission_lines_all cl,
332: -- cn_srp_plan_assigns srcp,
333: --cn_srp_payee_assigns srpa, removed for payee assigns bug #2495614
334: -- cn_role_plans rcp,
335: cn_quotas_all pe

Line 391: FROM cn_commission_lines_all cl,

387: null, --cl.attribute14,
388: null, --cl.attribute15
389: cl.org_id,
390: 0
391: FROM cn_commission_lines_all cl,
392: -- cn_srp_plan_assigns srcp,
393: cn_srp_payee_assigns_all payee,
394: -- cn_role_plans rcp,
395: cn_quotas_all pe

Line 525: UPDATE cn_commission_lines_all

521: -- RAISE FND_API.G_EXC_ERROR;
522: -- END IF;
523: -- if REVERT then Update commission line posting status to REVERTED
524: IF p_create_mode = 'REVERT' THEN
525: UPDATE cn_commission_lines_all
526: SET posting_status = C_REVERTED
527: WHERE commission_line_id = p_commission_line_id;
528: END IF;
529: END IF;