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.JAI_AP_TDS_ETDS_PKG dependencies on AP_CHECKS_ALL

Line 482: ln_check_number ap_checks_all.check_number%TYPE;

478: v_prepay_invoice_id NUMBER;
479: v_prepayment_amount_applied NUMBER;
480:
481: \* Bug 4353842. Added by Lakshmi Gopalsami *\
482: ln_check_number ap_checks_all.check_number%TYPE;
483: ln_tax_rate JAI_CMN_TAXES_ALL.tax_rate%TYPE;
484: ln_tds_rate JAI_CMN_TAXES_ALL.tax_rate%TYPE;
485: ln_surcharge_rate JAI_CMN_TAXES_ALL.surcharge_rate%TYPE;
486: ln_cess_rate JAI_CMN_TAXES_ALL.cess_rate%TYPE;

Line 604: FROM ap_invoice_payments_all PAY, ap_checks_all APC \* renamed the table from ap_checks_v to ap_checks_All for bug 12691784*\, JAI_AP_TDS_PAYMENTS JATP

600: \*Modified the cursor c_tds_payment_check_id by JMEENA for bug#4600778 to select the bsr_code from JAI_AP_TDS_PAYMENTS table *\
601: CURSOR c_tds_payment_check_id(p_invoice_id IN NUMBER) IS
602: SELECT pay.check_id, apc.bank_account_name, JATP.Challan_no challan_num,
603: JATP.check_deposit_date challan_date, JATP.bsr_code branch_code, apc.check_number check_number \*Bug 7688789 - Added Check Number*\
604: FROM ap_invoice_payments_all PAY, ap_checks_all APC \* renamed the table from ap_checks_v to ap_checks_All for bug 12691784*\, JAI_AP_TDS_PAYMENTS JATP
605: WHERE PAY.invoice_id = p_invoice_id
606: AND PAY.check_id = APC.check_id
607: AND APC.check_id = JATP.check_id
608: AND APC.status_lookup_code NOT IN (lv_voided,lv_stop_init);

Line 614: FROM ap_invoice_payments_all PAY, ap_checks_all APC\renamed the table from ap_checks_v to ap_checks_All for Bug 12691784\, JAI_AP_TDS_PAYMENTS JATP

610: \*Bug 12415388 - Get Payment details based on CHECK_ID instead of TDS_INVOICE_ID as a single TDS Invoice may be paid with multiple checks*\
611: CURSOR c_tds_payment_details(p_check_id IN NUMBER) IS
612: SELECT pay.check_id, apc.bank_account_name, JATP.Challan_no challan_num,
613: JATP.check_deposit_date challan_date, JATP.bsr_code branch_code, apc.check_number check_number \*Bug 7688789 - Added Check Number*\
614: FROM ap_invoice_payments_all PAY, ap_checks_all APC\*renamed the table from ap_checks_v to ap_checks_All for Bug 12691784*\, JAI_AP_TDS_PAYMENTS JATP
615: WHERE PAY.check_id = p_check_id
616: AND PAY.check_id = APC.check_id
617: AND APC.check_id = JATP.check_id
618: AND APC.status_lookup_code NOT IN (lv_voided,lv_stop_init);

Line 1733: ln_check_number ap_checks_all.check_number%TYPE;

1729: v_prepay_invoice_id NUMBER;
1730: v_prepayment_amount_applied NUMBER;
1731:
1732: /* Bug 4353842. Added by Lakshmi Gopalsami */
1733: ln_check_number ap_checks_all.check_number%TYPE;
1734: ln_tax_rate JAI_CMN_TAXES_ALL.tax_rate%TYPE;
1735: ln_tds_rate JAI_CMN_TAXES_ALL.tax_rate%TYPE;
1736: ln_surcharge_rate JAI_CMN_TAXES_ALL.surcharge_rate%TYPE;
1737: ln_cess_rate JAI_CMN_TAXES_ALL.cess_rate%TYPE;

Line 1855: FROM ap_invoice_payments_all PAY, ap_checks_all APC /* renamed the table from ap_checks_v to ap_checks_All for bug 12691784*/, JAI_AP_TDS_PAYMENTS JATP

1851: /*Modified the cursor c_tds_payment_check_id by JMEENA for bug#4600778 to select the bsr_code from JAI_AP_TDS_PAYMENTS table */
1852: CURSOR c_tds_payment_check_id(p_invoice_id IN NUMBER) IS
1853: SELECT pay.check_id, apc.bank_account_name, JATP.Challan_no challan_num,
1854: JATP.check_deposit_date challan_date, JATP.bsr_code branch_code, apc.check_number check_number /*Bug 7688789 - Added Check Number*/
1855: FROM ap_invoice_payments_all PAY, ap_checks_all APC /* renamed the table from ap_checks_v to ap_checks_All for bug 12691784*/, JAI_AP_TDS_PAYMENTS JATP
1856: WHERE PAY.invoice_id = p_invoice_id
1857: AND PAY.check_id = APC.check_id
1858: AND APC.check_id = JATP.check_id
1859: AND APC.status_lookup_code NOT IN (lv_voided,lv_stop_init);

Line 1865: FROM ap_invoice_payments_all PAY, ap_checks_all APC/renamed the table from ap_checks_v to ap_checks_All for Bug 12691784/, JAI_AP_TDS_PAYMENTS JATP

1861: /*Bug 12415388 - Get Payment details based on CHECK_ID instead of TDS_INVOICE_ID as a single TDS Invoice may be paid with multiple checks*/
1862: CURSOR c_tds_payment_details(p_check_id IN NUMBER) IS
1863: SELECT pay.check_id, apc.bank_account_name, JATP.Challan_no challan_num,
1864: JATP.check_deposit_date challan_date, JATP.bsr_code branch_code, apc.check_number check_number /*Bug 7688789 - Added Check Number*/
1865: FROM ap_invoice_payments_all PAY, ap_checks_all APC/*renamed the table from ap_checks_v to ap_checks_All for Bug 12691784*/, JAI_AP_TDS_PAYMENTS JATP
1866: WHERE PAY.check_id = p_check_id
1867: AND PAY.check_id = APC.check_id
1868: AND APC.check_id = JATP.check_id
1869: AND APC.status_lookup_code NOT IN (lv_voided,lv_stop_init);

Line 5107: FROM ap_checks_all

5103: AND vendor_site_id = p_vendor_site_id;
5104:
5105: CURSOR c_check_dtls(p_check_id IN NUMBER) IS
5106: SELECT check_date
5107: FROM ap_checks_all
5108: WHERE check_id = p_check_id;
5109:
5110: CURSOR c_cert_issue_date(p_tds_invoice_id IN NUMBER) IS
5111: SELECT a.issue_date