APPS.JL_JLARPPFF_XMLP_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 850: AP_INVOICE_DISTRIBUTIONS AID

846: ,' ')
847: INTO L_DGI_CODE
848: FROM
849: AP_TAX_CODES ATC,
850: AP_INVOICE_DISTRIBUTIONS AID
851: WHERE AID.INVOICE_ID = CF_DGI_TRAN_CODEFORMULA.INVOICE_ID
852: AND AID.LINE_TYPE_LOOKUP_CODE = 'TAX'
853: AND AID.TAX_CODE_ID = ATC.TAX_ID
854: AND ATC.TAX_TYPE = P_NON_TAXABLE_TAX_TYPE

Line 872: AP_INVOICE_DISTRIBUTIONS LINES,

868: SELECT
869: count(ATC.TAX_RATE)
870: INTO L_COUNT
871: FROM
872: AP_INVOICE_DISTRIBUTIONS LINES,
873: AP_TAX_CODES ATC
874: WHERE LINES.TAX_CODE_ID = ATC.TAX_ID
875: AND LINES.INVOICE_ID = CF_VAT_COUNTFORMULA.INVOICE_ID
876: AND ATC.TAX_TYPE = P_VAT_TAX_TYPE

Line 895: AP_INVOICE_DISTRIBUTIONS AID

891: COUNT(ATC.TAX_ID)
892: INTO L_VAT_RATE_QTY
893: FROM
894: AP_TAX_CODES ATC,
895: AP_INVOICE_DISTRIBUTIONS AID
896: WHERE AID.INVOICE_ID = CF_RATE_QTYFORMULA.INVOICE_ID
897: AND ATC.TAX_ID = AID.TAX_CODE_ID
898: AND AID.LINE_TYPE_LOOKUP_CODE = 'TAX'
899: AND ATC.TAX_TYPE in ( P_VAT_TAX_TYPE , P_NON_TAXABLE_TAX_TYPE );