APPS.JAI_AP_TDS_PROCESSING_PKG dependencies on JAI_AP_TDS_YEARS

Line 1284: from jai_ap_tds_years

1280: where organization_id = pn_organization_id;*/
1281:
1282: cursor c_ja_in_tds_year_info(pn_legal_entity_id number, pd_invoice_date date) is
1283: select fin_year
1284: from jai_ap_tds_years
1285: where legal_entity_id = pn_legal_entity_id
1286: and pd_invoice_date between start_date and end_date;
1287:
1288: cursor c_group_for_no_certificate/*Bug 5647725 start bduvarag*/

Line 1418: from jai_ap_tds_years

1414: /*11067621*/
1415: cursor c_get_fin_year(p_fin_year number)
1416: is
1417: select to_char(start_date, 'YYYY')
1418: from jai_ap_tds_years
1419: where fin_year = p_fin_year;
1420:
1421: ln_cert_line_num NUMBER(15);
1422: ln_prev_parent_invoice_id ap_invoices_all.invoice_id%TYPE;