DBA Data[Home] [Help]

APPS.CN_FORMULA_COMMON_PKG dependencies on CN_COMMISSION_HEADERS_S

Line 3548: SELECT cn_commission_headers_s.NEXTVAL INTO l_header_id FROM dual;

3544: l_role_id NUMBER;
3545: l_org_id NUMBER;
3546: l_commission_line_id number;
3547: BEGIN
3548: SELECT cn_commission_headers_s.NEXTVAL INTO l_header_id FROM dual;
3549:
3550: SELECT role_id, org_id INTO l_role_id, l_org_id
3551: FROM cn_srp_plan_assigns_all
3552: WHERE srp_plan_assign_id = p_trx_rec.srp_plan_assign_id;