APPS.AP_INVOICE_LINES_UTILITY_PKG dependencies on AP_ALLOCATION_RULES

Line 894: FROM ap_allocation_rules AR,

890: -- Bug 5386077. Recommenting again. Was checked incorrectly via bug 5000472 (120.20).
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

Line 1023: debug_info := 'Select from ap_allocation_rules';

1019: --
1020: current_calling_sequence :=
1021: 'AP_INVOICE_LINES_UTILITY_PKG.ALLOCATION_EXISTS<-'||p_Calling_Sequence;
1022:
1023: debug_info := 'Select from ap_allocation_rules';
1024:
1025: Select count(*)
1026: Into dummy
1027: From ap_allocation_rules AR,

Line 1027: From ap_allocation_rules AR,

1023: debug_info := 'Select from ap_allocation_rules';
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

Line 1388: From ap_allocation_rules AR,

1384: debug_info := 'Select from ap_allocatin_rules';
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 (+)

Line 1844: From ap_allocation_rules AR

1840: debug_info := 'Select from ap_allocatin_rules';
1841:
1842: Select count(*)
1843: Into dummy
1844: From ap_allocation_rules AR
1845: Where AR.invoice_id = p_Invoice_Id
1846: And AR.chrg_invoice_line_number = p_line_number
1847: And AR.status = 'PENDING';
1848: