APPS.JA_CN_CFS_CLT_SLA_PKG dependencies on FND_APPLICATION

Line 218: l_application_source fnd_application.application_short_name%TYPE;

214: l_func_amount ja_cn_cfs_activities_all.func_amount%type;
215: l_orig_amount ja_cn_cfs_activities_all.original_amount%type;
216: l_detailed_item_desc varchar2(240);
217: l_period_name gl_periods.period_name%TYPE;
218: l_application_source fnd_application.application_short_name%TYPE;
219: BEGIN
220: --Get the application short name for source
221: SELECT application_short_name
222: INTO l_application_source

Line 223: FROM fnd_application

219: BEGIN
220: --Get the application short name for source
221: SELECT application_short_name
222: INTO l_application_source
223: FROM fnd_application
224: WHERE application_id = p_application_id;
225:
226: -- Get the gl date,
227: If p_cash_date > p_transaction_date then

Line 387: --l_source fnd_application.application_short_name%TYPE;

383: l_date_from gl_periods.start_date%TYPE;
384: l_date_to gl_periods.end_date%TYPE;
385: l_func_currency_code fnd_currencies.currency_code%TYPE;
386: l_period_type gl_ledgers.accounted_period_type%TYPE;
387: --l_source fnd_application.application_short_name%TYPE;
388: l_source_id fnd_application.application_id%TYPE;
389:
390: -- the interim variables for activities all table
391: l_line_org_id xla_transaction_entities.security_id_int_1%TYPE;

Line 388: l_source_id fnd_application.application_id%TYPE;

384: l_date_to gl_periods.end_date%TYPE;
385: l_func_currency_code fnd_currencies.currency_code%TYPE;
386: l_period_type gl_ledgers.accounted_period_type%TYPE;
387: --l_source fnd_application.application_short_name%TYPE;
388: l_source_id fnd_application.application_id%TYPE;
389:
390: -- the interim variables for activities all table
391: l_line_org_id xla_transaction_entities.security_id_int_1%TYPE;
392: l_mapping_org_id NUMBER;

Line 635: FROM fnd_application

631: ELSE
632: BEGIN
633: SELECT application_id
634: INTO l_source_id
635: FROM fnd_application
636: WHERE application_short_name = p_source;
637:
638: DELETE ja_cn_cfs_activities_all ca
639: WHERE ca.legal_entity_id = P_LE_ID