DBA Data[Home] [Help]

APPS.AP_ETAX_UTILITY_PKG dependencies on AP_SUPPLIERS

Line 1963: ap_suppliers ap,

1959: DECODE(zls.applied_from_trx_id,
1960: null, P_Invoice_Header_Rec.pay_awt_group_id,
1961: prepay.pay_awt_group_id)) -- pay_awt_group_id Bug8345264 */
1962: FROM ap_invoices_all ai,
1963: ap_suppliers ap,
1964: ap_supplier_sites_all aps,
1965: zx_lines_summary zls,
1966: ap_invoice_lines_all prepay
1967: WHERE ai.invoice_id = p_invoice_header_rec.invoice_id

Line 11064: FROM ap_suppliers /* bUg 4718054 */

11060:
11061: BEGIN
11062: SELECT employee_id
11063: INTO l_employee_id
11064: FROM ap_suppliers /* bUg 4718054 */
11065: WHERE DECODE(SIGN(TO_DATE(TO_CHAR(START_DATE_ACTIVE,'DD-MM-YYYY'),
11066: 'DD-MM-YYYY') - TO_DATE(TO_CHAR(SYSDATE,'DD-MM-YYYY'),'DD-MM-YYYY')),
11067: 1, 'N', DECODE(SIGN(TO_DATE(TO_CHAR(END_DATE_ACTIVE ,'DD-MM-YYYY'),
11068: 'DD-MM-YYYY') - TO_DATE(TO_CHAR(SYSDATE,'DD-MM-YYYY'),'DD-MM-YYYY')),