APPS.JA_CN_CFS_CLT_SLA_PKG dependencies on GL_PERIODS

Line 98: FROM gl_periods

94: l_period_name VARCHAR2(30);
95: BEGIN
96: SELECT period_name
97: INTO l_period_name
98: FROM gl_periods
99: WHERE period_set_name = p_period_set_name
100: AND start_date <= p_gl_date
101: AND End_Date >= p_gl_date
102: AND period_type = p_period_type

Line 217: l_period_name gl_periods.period_name%TYPE;

213: L_GL_date ja_cn_cfs_activities_all.gl_date%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

Line 381: l_period_num_from gl_periods.period_num%TYPE;

377: P_GL_PERIOD_FROM IN VARCHAR2,
378: P_GL_PERIOD_TO IN VARCHAR2,
379: P_SOURCE IN VARCHAR2) AS
380: l_procedure_name VARCHAR2(30) := 'collect_SLA_data';
381: l_period_num_from gl_periods.period_num%TYPE;
382: l_period_num_to gl_periods.period_num%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;

Line 382: l_period_num_to gl_periods.period_num%TYPE;

378: P_GL_PERIOD_TO IN VARCHAR2,
379: P_SOURCE IN VARCHAR2) AS
380: l_procedure_name VARCHAR2(30) := 'collect_SLA_data';
381: l_period_num_from gl_periods.period_num%TYPE;
382: l_period_num_to gl_periods.period_num%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;

Line 383: l_date_from gl_periods.start_date%TYPE;

379: P_SOURCE IN VARCHAR2) AS
380: l_procedure_name VARCHAR2(30) := 'collect_SLA_data';
381: l_period_num_from gl_periods.period_num%TYPE;
382: l_period_num_to gl_periods.period_num%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;

Line 384: l_date_to gl_periods.end_date%TYPE;

380: l_procedure_name VARCHAR2(30) := 'collect_SLA_data';
381: l_period_num_from gl_periods.period_num%TYPE;
382: l_period_num_to gl_periods.period_num%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;

Line 582: FROM gl_periods

578: -- Get l_date_from, l_date_to
579: BEGIN
580: SELECT period_year * 1000 + period_num, start_date
581: INTO l_period_num_from, l_date_from
582: FROM gl_periods
583: WHERE period_set_name = p_period_set_name
584: AND period_name = P_GL_PERIOD_FROM
585: AND period_type = l_period_type;
586:

Line 589: FROM gl_periods

585: AND period_type = l_period_type;
586:
587: SELECT period_year * 1000 + period_num, end_date
588: INTO l_period_num_to, l_date_to
589: FROM gl_periods
590: WHERE period_set_name = p_period_set_name
591: AND period_name = P_GL_PERIOD_to
592: AND period_type = l_period_type;
593:

Line 618: FROM Gl_Periods

614: AND ledger_id = p_ledger_id
615: AND ca.SOURCE_application_id NOT IN (101, 435)
616: AND ca.period_name IN
617: (SELECT period_name
618: FROM Gl_Periods
619: WHERE period_set_name = p_period_set_name
620: AND period_year * 1000 + period_num BETWEEN
621: l_period_num_from AND l_period_num_to);
622: COMMIT;

Line 644: FROM Gl_Periods

640: AND ledger_id = p_ledger_id
641: AND ca.SOURCE_application_id = l_source_id
642: AND ca.period_name IN
643: (SELECT period_name
644: FROM Gl_Periods
645: WHERE period_set_name = p_period_set_name
646: AND period_year * 1000 + period_num BETWEEN
647: l_period_num_from AND l_period_num_to);
648: COMMIT;