526:
527: l_api_name CONSTANT VARCHAR2(30) := 'Update_srp_pe_subledger';
528: l_api_version CONSTANT NUMBER :=1.0;
529:
530: l_max_period_id cn_period_statuses.period_id%TYPE;
531: l_start_period_id cn_period_statuses.period_id%TYPE;
532:
533: CURSOR comm_bonus_cr IS
534: SELECT SUM(Decode(cl.pending_status, 'Y', 0,
527: l_api_name CONSTANT VARCHAR2(30) := 'Update_srp_pe_subledger';
528: l_api_version CONSTANT NUMBER :=1.0;
529:
530: l_max_period_id cn_period_statuses.period_id%TYPE;
531: l_start_period_id cn_period_statuses.period_id%TYPE;
532:
533: CURSOR comm_bonus_cr IS
534: SELECT SUM(Decode(cl.pending_status, 'Y', 0,
535: Decode(cl.trx_type, 'ADV', 0, 'REC', 0, 'CHG', 0, 'FORECAST', 0,