eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_CALC_SUBLEDGER_PVT dependencies on CN_PERIOD_STATUSES

Line 528: l_max_period_id cn_period_statuses.period_id%TYPE;

524:
525: l_api_name CONSTANT VARCHAR2(30) := 'Update_srp_pe_subledger';
526: l_api_version CONSTANT NUMBER :=1.0;
527:
528: l_max_period_id cn_period_statuses.period_id%TYPE;
529: l_start_period_id cn_period_statuses.period_id%TYPE;
530:
531: CURSOR comm_bonus_cr IS
532: SELECT SUM(Decode(cl.pending_status, 'Y', 0,

Line 529: l_start_period_id cn_period_statuses.period_id%TYPE;

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