DBA Data[Home] [Help]

APPS.JL_JLARPPFF_XMLP_PKG dependencies on AP_TAX_CODES

Line 849: AP_TAX_CODES ATC,

845: ,1)
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

Line 873: AP_TAX_CODES ATC

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
877: AND LINES.LINE_TYPE_LOOKUP_CODE = 'TAX';

Line 894: AP_TAX_CODES ATC,

890: SELECT
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'