APPS.AP_INVOICE_LINES_UTILITY_PKG dependencies on AP_ALLOCATION_RULES

Line 948: FROM ap_allocation_rules AR,

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

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

1091: --
1092: current_calling_sequence :=
1093: 'AP_INVOICE_LINES_UTILITY_PKG.ALLOCATION_EXISTS<-'||p_Calling_Sequence;
1094:
1095: debug_info := 'Select from ap_allocation_rules';
1096:
1097: Select count(*)
1098: Into dummy
1099: From ap_allocation_rules AR,

Line 1099: From ap_allocation_rules AR,

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

Line 1461: From ap_allocation_rules AR,

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

Line 1919: From ap_allocation_rules AR

1915: debug_info := 'Select from ap_allocatin_rules';
1916:
1917: Select count(*)
1918: Into dummy
1919: From ap_allocation_rules AR
1920: Where AR.invoice_id = p_Invoice_Id
1921: And AR.chrg_invoice_line_number = p_line_number
1922: And AR.status = 'PENDING';
1923: