DBA Data[Home] [Help]

APPS.PA_INV_ON_ACCOUNT_CM dependencies on RA_INTERFACE_LINES

Line 24: FROM ra_interface_lines ra,

20: pdi.system_reference,
21: NVL(rbs.gen_line_level_bal_flag,'N') line_level_bal_flag,
22: sum(pdii_cm.inv_amount) cm_amount,
23: rctt.allow_overapplication_flag
24: FROM ra_interface_lines ra,
25: pa_draft_invoices pdi,
26: pa_draft_invoices pdi_cm,
27: pa_implementations pi,
28: pa_projects pa,

Line 103: UPDATE ra_interface_lines ra

99:
100: IF (((c_cm_rec.cm_amount * -1) > l_balance_inv_curr ) AND
101: c_cm_rec.allow_overapplication_flag = 'N' )THEN
102:
103: UPDATE ra_interface_lines ra
104: SET Reference_Line_Attribute1 = NULL,
105: Reference_Line_Attribute2 = NULL,
106: Reference_Line_Attribute3 = NULL,
107: Reference_Line_Attribute4 = NULL,

Line 146: UPDATE ra_interface_lines ra

142: PA_MCB_INVOICE_PKG.log_message('CM Line Amount in Invoice currency:'||c_cm_lines_rec.inv_amount);
143:
144: IF ((c_cm_lines_rec.inv_amount * -1) > l_balance_inv_curr ) THEN
145:
146: UPDATE ra_interface_lines ra
147: SET Reference_Line_Attribute1 = NULL,
148: Reference_Line_Attribute2 = NULL,
149: Reference_Line_Attribute3 = NULL,
150: Reference_Line_Attribute4 = NULL,