DBA Data[Home] [Help]

APPS.FV_AR_PKG dependencies on GL_INTERFACE

Line 21: FROM gl_interface gi,

17: SUM(entered_dr) entered_dr,
18: SUM(entered_cr) entered_cr,
19: SUM(accounted_dr) accounted_dr,
20: SUM(accounted_cr) accounted_cr
21: FROM gl_interface gi,
22: ar_cash_receipts cr
23: WHERE gi.reference30 = 'AR_RECEIVABLE_APPLICATIONS'
24: AND gi.group_id = pcid
25: AND gi.user_je_source_name = 'Receivables'

Line 72: DELETE FROM gl_interface

68: EXIT;
69: END IF;
70:
71: FORALL j IN cash_receipt_id_t.FIRST..cash_receipt_id_t.LAST
72: DELETE FROM gl_interface
73: WHERE reference30 = 'AR_RECEIVABLE_APPLICATIONS'
74: AND group_id = p_posting_control_id
75: AND substr(reference29,7) = 'UNAPP'
76: AND substr(reference22,1,instr(reference22,'C')-1) =