DBA Data[Home] [Help]

APPS.JAI_AR_TCS_REP_PKG dependencies on JAI_AP_TDS_YEARS

Line 188: | and jai_ap_tds_years. Hence retreiving the value from the jai_ap_tds_years

184: /*
185: | cursor modified by ssumaith for the bug 6109941
186: | the fin_year value was being incorrectly coded.
187: | The basic reason was was the join bwtween the hr_operating_units
188: | and jai_ap_tds_years. Hence retreiving the value from the jai_ap_tds_years
189: | only
190: */
191:
192: CURSOR get_tcs_fin_year ( cp_org_id NUMBER ,

Line 199: JAI_AP_TDS_YEARS jtyi

195: IS
196: SELECT
197: fin_year
198: FROM
199: JAI_AP_TDS_YEARS jtyi
200: WHERE
201: jtyi.legal_entity_id = cp_org_id
202: AND trunc(cp_trx_date) BETWEEN trunc(jtyi.start_date) and trunc(nvl(jtyi.end_date,sysdate)); --Added trunc by JMEENA for bug#9538920
203: