APPS.JA_CN_CFS_CLT_SLA_PKG dependencies on FND_APPLICATION

Line 255: l_application_source fnd_application.application_short_name%TYPE;

251: l_func_amount ja_cn_cfs_activities_all.func_amount%type;
252: l_orig_amount ja_cn_cfs_activities_all.original_amount%type;
253: l_detailed_item_desc varchar2(240);
254: l_period_name gl_periods.period_name%TYPE;
255: l_application_source fnd_application.application_short_name%TYPE;
256: l_status ar_cash_receipt_history_all.status%TYPE;
257: l_je_header_id gl_je_lines.je_header_id%type;
258: l_je_line_num gl_je_lines.je_line_num%type;
259: BEGIN

Line 263: FROM fnd_application

259: BEGIN
260: --Get the application short name for source
261: SELECT application_short_name
262: INTO l_application_source
263: FROM fnd_application
264: WHERE application_id = p_application_id;
265:
266: -- Get the gl date,
267: If p_cash_date > p_transaction_date then

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

514: l_date_from gl_periods.start_date%TYPE;
515: l_date_to gl_periods.end_date%TYPE;
516: l_func_currency_code fnd_currencies.currency_code%TYPE;
517: l_period_type gl_ledgers.accounted_period_type%TYPE;
518: --l_source fnd_application.application_short_name%TYPE;
519: l_source_id fnd_application.application_id%TYPE;
520:
521: -- the interim variables for activities all table
522: l_line_org_id xla_transaction_entities.security_id_int_1%TYPE;

Line 519: l_source_id fnd_application.application_id%TYPE;

515: l_date_to gl_periods.end_date%TYPE;
516: l_func_currency_code fnd_currencies.currency_code%TYPE;
517: l_period_type gl_ledgers.accounted_period_type%TYPE;
518: --l_source fnd_application.application_short_name%TYPE;
519: l_source_id fnd_application.application_id%TYPE;
520:
521: -- the interim variables for activities all table
522: l_line_org_id xla_transaction_entities.security_id_int_1%TYPE;
523: l_mapping_org_id NUMBER;

Line 784: FROM fnd_application

780: ELSE
781: BEGIN
782: SELECT application_id
783: INTO l_source_id
784: FROM fnd_application
785: WHERE application_short_name = p_source;
786:
787: DELETE ja_cn_cfs_activities_all ca
788: WHERE ca.legal_entity_id = P_LE_ID