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_SRP_PERIODS_PKG dependencies on CN_SRP_PERIODS_S

Line 22: -- To get the previous record in cn_srp_periods so can inherit the balance

18: -- /*-------------------------------------------------------------------------*
19: -- Procedure Name
20: -- Get_Previous_Balances
21: -- Purpose
22: -- To get the previous record in cn_srp_periods so can inherit the balance
23: -- from previous record
24: -- *-------------------------------------------------------------------------*/
25: PROCEDURE Get_Previous_Balances
26: (p_salesrep_id IN NUMBER,

Line 249: SELECT cn_srp_periods_s.NEXTVAL

245: l_dummy NUMBER;
246: l_srp_prd_row cn_srp_periods%ROWTYPE := Null;
247:
248: BEGIN
249: SELECT cn_srp_periods_s.NEXTVAL
250: INTO X_SRP_PERIOD_ID
251: FROM dual;
252:
253: INSERT INTO cn_srp_periods_all