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_ST_REVERSAL_EXTRACT_PKG dependencies on AP_INVOICES_UTILITY_PKG

Line 132: ( ap_invoices_utility_pkg.get_approval_status(apa.invoice_id

128: AND aid.posted_flag = 'Y'
129: AND jail.invoice_line_number = aid.invoice_line_number
130: AND jail.parent_invoice_line_number IS NULL
131: AND
132: ( ap_invoices_utility_pkg.get_approval_status(apa.invoice_id
133: ,apa.invoice_amount
134: ,apa.payment_status_flag
135: ,apa.invoice_type_lookup_code) ='APPROVED' )
136: AND invoice_type_lookup_code NOT IN ('DEBIT', 'CREDIT')

Line 199: AND ap_invoices_utility_pkg.get_approval_status(apa.invoice_id

195: WHERE jamit.tax_id = jct.tax_id
196: AND apa.invoice_id = jamit.invoice_id
197: AND jct.tax_type IN ('Service', 'SERVICE_EDUCATION_CESS', 'SERVICE_SH_EDU_CESS')
198: )
199: AND ap_invoices_utility_pkg.get_approval_status(apa.invoice_id
200: ,apa.invoice_amount
201: ,apa.payment_status_flag
202: ,apa.invoice_type_lookup_code) = 'APPROVED'
203: AND apa.invoice_type_lookup_code NOT IN ('DEBIT', 'CREDIT')

Line 251: AND (ap_invoices_utility_pkg.get_approval_status(apa.invoice_id

247: WHERE jamit.tax_id = jct.tax_id
248: AND apa.invoice_id = jamit.invoice_id
249: AND jct.tax_type IN ('Service', 'SERVICE_EDUCATION_CESS', 'SERVICE_SH_EDU_CESS')
250: )
251: AND (ap_invoices_utility_pkg.get_approval_status(apa.invoice_id
252: ,apa.invoice_amount
253: ,apa.payment_status_flag
254: ,apa.invoice_type_lookup_code) = 'APPROVED' )
255: AND invoice_type_lookup_code NOT IN ('DEBIT', 'CREDIT')