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.CE_CP_OA_XTR_PKG dependencies on CE_PROJECTED_BALANCES

Line 131: DELETE FROM ce_projected_balances

127: p_balance_date DATE,
128: p_balance_amount NUMBER)
129: IS
130: BEGIN
131: DELETE FROM ce_projected_balances
132: WHERE bank_account_id=p_bank_account_id
133: AND balance_date=p_balance_date;
134:
135: INSERT INTO ce_projected_balances

Line 135: INSERT INTO ce_projected_balances

131: DELETE FROM ce_projected_balances
132: WHERE bank_account_id=p_bank_account_id
133: AND balance_date=p_balance_date;
134:
135: INSERT INTO ce_projected_balances
136: (projected_balance_id,
137: bank_Account_id,
138: balance_date,
139: projected_balance,

Line 146: VALUES (ce_projected_Balances_s.nextval,

142: creation_date,
143: created_by,
144: last_update_login,
145: object_version_number)
146: VALUES (ce_projected_Balances_s.nextval,
147: p_bank_account_id,
148: p_balance_date,
149: p_balance_amount,
150: sysdate,