APPS.IGIPMSDA dependencies on AP_INVOICE_DISTRIBUTIONS

Line 45: FROM ap_invoice_distributions inv_dist

41: CURSOR c_proper_dist ( cp_invoice_id in number) IS
42: SELECT inv_dist.invoice_id, inv_dist.distribution_line_number
43: , inv_dist.invoice_distribution_id, inv_dist.dist_code_combination_id
44: , inv_dist.accounting_date gl_date
45: FROM ap_invoice_distributions inv_dist
46: WHERE inv_dist.invoice_id = cp_invoice_id
47: AND ( inv_dist.line_type_lookup_code = 'ITEM' OR
48: ( inv_dist.line_type_lookup_code = 'TAX' AND
49: inv_dist.tax_recoverable_flag = 'N' AND

Line 120: from ap_invoice_distributions

116: )
117: RETURN BOOLEAN IS
118: CURSOR C_reversal IS
119: select parent_reversal_id
120: from ap_invoice_distributions
121: where invoice_id = fp_invoice_id
122: and distribution_line_number = fp_distribution_line_number
123: and reversal_flag = 'Y'
124: and parent_reversal_id is not null

Line 140: FROM ap_invoice_distributions

136: FUNCTION ParentDistributionID ( fp_invoice_distribution_id in number )
137: RETURN NUMBER IS
138: CURSOR c_rev IS
139: SELECT parent_reversal_id
140: FROM ap_invoice_distributions
141: WHERE invoice_distribution_id = fp_invoice_distribution_id;
142: BEGIN
143: FOR l_rev in c_rev LOOP
144: return l_rev.parent_reversal_id;

Line 170: , ap_invoice_distributions dist

166: IS
167: CURSOR c_defaults IS
168: SELECT mpp_dist.accounting_rule_id, mpp_dist.ignore_mpp_flag
169: FROM igi_mpp_ap_invoice_dists mpp_dist
170: , ap_invoice_distributions dist
171: WHERE dist.invoice_id = mpp_dist.invoice_id
172: and dist.distribution_line_number
173: = mpp_dist.distribution_line_number
174: and dist.reversal_flag = 'Y'