DBA Data[Home] [Help]

APPS.AP_INVOICE_LINES_UTILITY_PKG dependencies on AP_ALLOCATION_RULE_LINES

Line 895: ap_allocation_rule_lines ARL

891: /*
892: SELECT count(*)
893: INTO l_pending_count
894: FROM ap_allocation_rules AR,
895: ap_allocation_rule_lines ARL
896: WHERE AR.invoice_id = p_line_rec.invoice_id
897: AND AR.invoice_id = ARL.invoice_id
898: AND AR.chrg_invoice_line_number = ARL.chrg_invoice_line_number
899: AND ARL.to_invoice_line_number = p_line_rec.line_number

Line 1028: ap_allocation_rule_lines ARL

1024:
1025: Select count(*)
1026: Into dummy
1027: From ap_allocation_rules AR,
1028: ap_allocation_rule_lines ARL
1029: Where AR.invoice_id = p_Invoice_Id
1030: And AR.invoice_id = ARL.invoice_id
1031: And AR.chrg_invoice_line_number = ARL.chrg_invoice_line_number
1032: And ARL.to_invoice_line_number = p_line_number;

Line 1389: ap_allocation_rule_lines ARL

1385:
1386: Select count(*)
1387: Into dummy
1388: From ap_allocation_rules AR,
1389: ap_allocation_rule_lines ARL
1390: Where AR.invoice_id = p_Invoice_Id
1391: And AR.invoice_id = ARL.invoice_id (+)
1392: And AR.chrg_invoice_line_number = ARL.chrg_invoice_line_number (+)
1393: And ARL.to_invoice_line_number (+) = p_line_number