161: SOURCE_VALUE,
162: CASH_ITEM_DESC,
163: 'I',
164: SYSDATE,
165: fnd_global.user_id,
166: SYSDATE,
167: fnd_global.user_id,
168: fnd_global.LOGIN_ID
169: FROM ja_cn_cfs_activities_interface
163: 'I',
164: SYSDATE,
165: fnd_global.user_id,
166: SYSDATE,
167: fnd_global.user_id,
168: fnd_global.LOGIN_ID
169: FROM ja_cn_cfs_activities_interface
170: WHERE legal_entity_id = p_legal_entity_id
171: AND ledger_id = p_ledger_id
164: SYSDATE,
165: fnd_global.user_id,
166: SYSDATE,
167: fnd_global.user_id,
168: fnd_global.LOGIN_ID
169: FROM ja_cn_cfs_activities_interface
170: WHERE legal_entity_id = p_legal_entity_id
171: AND ledger_id = p_ledger_id
172: AND status = 'S';