APPS.JAI_AP_TDS_ETDS_PKG dependencies on JAI_AP_TDS_PAYMENTS

Line 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 *\

596: FROM hr_all_organization_units
597: WHERE organization_id = p_organization_id;
598:
599: \*added by csahoo for bug # 6158875, START*\
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

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 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 */

1847: FROM hr_all_organization_units
1848: WHERE organization_id = p_organization_id;
1849:
1850: /*added by csahoo for bug # 6158875, START*/
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

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);