DBA Data[Home] [Help]

APPS.IGIPMSDA dependencies on IGI_MPP_AP_INVOICE_DISTS

Line 88: FROM igi_mpp_ap_invoice_dists

84: , cp_distribution_line_number in number
85: ) RETURN BOOLEAN IS
86: CURSOR c_exists IS
87: SELECT 'x'
88: FROM igi_mpp_ap_invoice_dists
89: WHERE invoice_id = cp_invoice_id
90: AND distribution_line_number = cp_distribution_line_number
91: ;
92:

Line 169: FROM igi_mpp_ap_invoice_dists mpp_dist

165: )
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

Line 302: INSERT into igi_mpp_ap_invoice_dists

298: from ra_rules
299: where rule_id = l_default_acc_rule_id;
300:
301:
302: INSERT into igi_mpp_ap_invoice_dists
303: (
304: distribution_line_number
305: ,invoice_id
306: ,accounting_rule_id