eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JA_CN_CFS_CLT_SLA_PKG dependencies on GL_PERIODS

Line 125: FROM gl_periods

121: l_period_name VARCHAR2(30);
122: BEGIN
123: SELECT period_name
124: INTO l_period_name
125: FROM gl_periods
126: WHERE period_set_name = p_period_set_name
127: AND start_date <= p_gl_date
128: AND End_Date >= p_gl_date
129: AND period_type = p_period_type

Line 254: l_period_name gl_periods.period_name%TYPE;

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

Line 512: l_period_num_from gl_periods.period_num%TYPE;

508: P_GL_PERIOD_FROM IN VARCHAR2,
509: P_GL_PERIOD_TO IN VARCHAR2,
510: P_SOURCE IN VARCHAR2) AS
511: l_procedure_name VARCHAR2(30) := 'collect_SLA_data';
512: l_period_num_from gl_periods.period_num%TYPE;
513: l_period_num_to gl_periods.period_num%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;

Line 513: l_period_num_to gl_periods.period_num%TYPE;

509: P_GL_PERIOD_TO IN VARCHAR2,
510: P_SOURCE IN VARCHAR2) AS
511: l_procedure_name VARCHAR2(30) := 'collect_SLA_data';
512: l_period_num_from gl_periods.period_num%TYPE;
513: l_period_num_to gl_periods.period_num%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;

Line 514: l_date_from gl_periods.start_date%TYPE;

510: P_SOURCE IN VARCHAR2) AS
511: l_procedure_name VARCHAR2(30) := 'collect_SLA_data';
512: l_period_num_from gl_periods.period_num%TYPE;
513: l_period_num_to gl_periods.period_num%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;

Line 515: l_date_to gl_periods.end_date%TYPE;

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

Line 731: FROM gl_periods

727: -- Get l_date_from, l_date_to
728: BEGIN
729: SELECT period_year * 1000 + period_num, start_date
730: INTO l_period_num_from, l_date_from
731: FROM gl_periods
732: WHERE period_set_name = p_period_set_name
733: AND period_name = P_GL_PERIOD_FROM
734: AND period_type = l_period_type;
735:

Line 738: FROM gl_periods

734: AND period_type = l_period_type;
735:
736: SELECT period_year * 1000 + period_num, end_date
737: INTO l_period_num_to, l_date_to
738: FROM gl_periods
739: WHERE period_set_name = p_period_set_name
740: AND period_name = P_GL_PERIOD_to
741: AND period_type = l_period_type;
742:

Line 767: FROM Gl_Periods

763: AND ledger_id = p_ledger_id
764: AND ca.SOURCE_application_id NOT IN (101, 435)
765: AND ca.period_name IN
766: (SELECT period_name
767: FROM Gl_Periods
768: WHERE period_set_name = p_period_set_name
769: AND period_year * 1000 + period_num BETWEEN
770: l_period_num_from AND l_period_num_to);
771: COMMIT;

Line 793: FROM Gl_Periods

789: AND ledger_id = p_ledger_id
790: AND ca.SOURCE_application_id = l_source_id
791: AND ca.period_name IN
792: (SELECT period_name
793: FROM Gl_Periods
794: WHERE period_set_name = p_period_set_name
795: AND period_year * 1000 + period_num BETWEEN
796: l_period_num_from AND l_period_num_to);
797: COMMIT;