DBA Data[Home] [Help]

APPS.AP_INVOICE_LINES_UTILITY_PKG dependencies on AP_ALLOCATION_RULE_LINES

Line 949: ap_allocation_rule_lines ARL

945: /*
946: SELECT count(*)
947: INTO l_pending_count
948: FROM ap_allocation_rules AR,
949: ap_allocation_rule_lines ARL
950: WHERE AR.invoice_id = p_line_rec.invoice_id
951: AND AR.invoice_id = ARL.invoice_id
952: AND AR.chrg_invoice_line_number = ARL.chrg_invoice_line_number
953: AND ARL.to_invoice_line_number = p_line_rec.line_number

Line 1100: ap_allocation_rule_lines ARL

1096:
1097: Select count(*)
1098: Into dummy
1099: From ap_allocation_rules AR,
1100: ap_allocation_rule_lines ARL
1101: Where AR.invoice_id = p_Invoice_Id
1102: And AR.invoice_id = ARL.invoice_id
1103: And AR.chrg_invoice_line_number = ARL.chrg_invoice_line_number
1104: And ARL.to_invoice_line_number = p_line_number;

Line 1462: ap_allocation_rule_lines ARL

1458:
1459: Select count(*)
1460: Into dummy
1461: From ap_allocation_rules AR,
1462: ap_allocation_rule_lines ARL
1463: Where AR.invoice_id = p_Invoice_Id
1464: And AR.invoice_id = ARL.invoice_id (+)
1465: And AR.chrg_invoice_line_number = ARL.chrg_invoice_line_number (+)
1466: --Commented below condition for bug #9143555 and introduced new conditions