APPS.JAI_AP_DTC_DEFAULTATION_PKG dependencies on GL_PERIODS

Line 175: -- cursor to get period year from gl_periods

171: MIN(ACCOUNTING_DATE) MIN_DATE
172: FROM AP_INVOICE_DISTRIBUTIONS_ALL
173: WHERE INVOICE_ID = p_inv_id;
174:
175: -- cursor to get period year from gl_periods
176: cursor c_get_period_year(cp_calendar_id number,
177: cp_accounting_date AP_INVOICE_DISTRIBUTIONS_ALL.ACCOUNTING_DATE%TYPE)
178: is
179: SELECT a.PERIOD_YEAR

Line 180: FROM GL_PERIODS a, gl_period_sets b

176: cursor c_get_period_year(cp_calendar_id number,
177: cp_accounting_date AP_INVOICE_DISTRIBUTIONS_ALL.ACCOUNTING_DATE%TYPE)
178: is
179: SELECT a.PERIOD_YEAR
180: FROM GL_PERIODS a, gl_period_sets b
181: WHERE a.PERIOD_SET_NAME = b.period_set_name
182: and b.period_set_id = cp_calendar_id
183: AND cp_accounting_date BETWEEN a.START_DATE AND a.END_DATE;
184:

Line 737: ln_max_period_year GL_PERIODS.PERIOD_YEAR%TYPE;

733: lv_inv_tlc AP_INVOICES_ALL.INVOICE_TYPE_LOOKUP_CODE%TYPE;
734: lv_segment_name FND_ID_FLEX_SEGMENTS.APPLICATION_COLUMN_NAME%TYPE;
735: ld_max_date AP_INVOICE_DISTRIBUTIONS_ALL.ACCOUNTING_DATE%TYPE;
736: ld_min_date AP_INVOICE_DISTRIBUTIONS_ALL.ACCOUNTING_DATE%TYPE;
737: ln_max_period_year GL_PERIODS.PERIOD_YEAR%TYPE;
738: ln_min_period_year GL_PERIODS.PERIOD_YEAR%TYPE;
739: lv_tax_default_option VARCHAR2(40);
740: lv_tds_vendor_default_flag VARCHAR2(40) := NULL; --Added by Chong for bug#16367707
741: -- la_aida_tab AIDA_TYPE := AIDA_TYPE(); commented for test by ChongLei

Line 738: ln_min_period_year GL_PERIODS.PERIOD_YEAR%TYPE;

734: lv_segment_name FND_ID_FLEX_SEGMENTS.APPLICATION_COLUMN_NAME%TYPE;
735: ld_max_date AP_INVOICE_DISTRIBUTIONS_ALL.ACCOUNTING_DATE%TYPE;
736: ld_min_date AP_INVOICE_DISTRIBUTIONS_ALL.ACCOUNTING_DATE%TYPE;
737: ln_max_period_year GL_PERIODS.PERIOD_YEAR%TYPE;
738: ln_min_period_year GL_PERIODS.PERIOD_YEAR%TYPE;
739: lv_tax_default_option VARCHAR2(40);
740: lv_tds_vendor_default_flag VARCHAR2(40) := NULL; --Added by Chong for bug#16367707
741: -- la_aida_tab AIDA_TYPE := AIDA_TYPE(); commented for test by ChongLei
742: la_cum_amt_tab CUM_AMT_TYPE := CUM_AMT_TYPE();