DBA Data[Home] [Help]

APPS.CN_FORMULA_COMMON_PKG dependencies on CN_COMMISSION_HEADERS_S

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

3515: l_role_id NUMBER;
3516: l_org_id NUMBER;
3517: l_commission_line_id number;
3518: BEGIN
3519: SELECT cn_commission_headers_s.NEXTVAL INTO l_header_id FROM dual;
3520:
3521: SELECT role_id, org_id INTO l_role_id, l_org_id
3522: FROM cn_srp_plan_assigns_all
3523: WHERE srp_plan_assign_id = p_trx_rec.srp_plan_assign_id;