APPS.CSM_CURRENCY_EVENT_PKG dependencies on FND_CURRENCIES_TL

Line 45: fnd_currencies_tl curr_tl,

41: CURSOR l_deletes_csr(p_last_upd_date date)
42: IS
43: SELECT acc.access_id, curr.currency_code, curr_tl.language
44: FROM fnd_currencies curr,
45: fnd_currencies_tl curr_tl,
46: csm_currencies_acc acc
47: WHERE curr.currency_code = curr_tl.currency_code
48: AND curr.currency_code = acc.currency_code
49: AND ((SYSDATE not BETWEEN nvl(curr.start_date_active, sysdate) AND nvl(curr.end_date_active, sysdate))

Line 62: l_language fnd_currencies_tl.language%TYPE;

58: l_mark_dirty boolean;
59: l_curr_last_update_date fnd_currencies.LAST_UPDATE_DATE%TYPE;
60: l_curr_tl_last_update_date fnd_currencies.LAST_UPDATE_DATE%TYPE;
61: l_max_update_date fnd_currencies.LAST_UPDATE_DATE%TYPE;
62: l_language fnd_currencies_tl.language%TYPE;
63: l_currency_code fnd_currencies.currency_code%TYPE;
64: l_access_id CSM_currencies_ACC.ACCESS_ID%TYPE;
65: l_tl_omfs_palm_resource_list asg_download.user_list;
66: l_single_access_id_list asg_download.access_list;

Line 124: fnd_currencies_tl curr_tl

120: l_dsql :=
121: 'select acc.access_id, curr_tl.language, curr.last_update_date, curr_tl.last_update_date
122: from csm_currencies_acc acc,
123: fnd_currencies curr,
124: fnd_currencies_tl curr_tl
125: where acc.currency_code = curr.currency_code
126: and curr_tl.currency_code = curr.currency_code
127: AND SYSDATE BETWEEN nvl(curr.start_date_active, sysdate) AND nvl(curr.end_date_active, sysdate)
128: AND curr.enabled_flag = ''Y''

Line 267: fnd_currencies_tl curr_tl

263: CURSOR l_currency_ins_csr(p_last_upd_date date)
264: IS
265: SELECT curr.currency_code, curr_tl.language, curr.last_update_date
266: FROM fnd_currencies curr,
267: fnd_currencies_tl curr_tl
268: WHERE curr.currency_code = curr_tl.currency_code
269: AND SYSDATE BETWEEN nvl(curr.start_date_active, sysdate) AND nvl(curr.end_date_active, sysdate)
270: AND curr.enabled_flag = 'Y'
271: AND (curr.creation_date > p_last_upd_date

Line 278: fnd_currencies_tl curr_tl

274: CURSOR l_currency_upd_csr(p_last_upd_date date)
275: IS
276: SELECT curr.currency_code, curr_tl.language
277: FROM fnd_currencies curr,
278: fnd_currencies_tl curr_tl
279: WHERE curr.currency_code = curr_tl.currency_code
280: AND SYSDATE BETWEEN nvl(curr.start_date_active, sysdate) AND nvl(curr.end_date_active, sysdate)
281: AND curr.enabled_flag = 'Y'
282: AND ((curr.creation_date < p_last_upd_date AND curr.last_update_date > p_last_upd_date)

Line 290: fnd_currencies_tl curr_tl

286: CURSOR l_currency_del_csr(p_last_upd_date date)
287: IS
288: SELECT curr.currency_code, curr_tl.language
289: FROM fnd_currencies curr,
290: fnd_currencies_tl curr_tl
291: WHERE curr.currency_code = curr_tl.currency_code
292: AND ((SYSDATE not BETWEEN nvl(curr.start_date_active, sysdate) AND nvl(curr.end_date_active, sysdate))
293: OR curr.enabled_flag <> 'Y')
294: AND ((curr.creation_date < p_last_upd_date AND curr.last_update_date > p_last_upd_date)