APPS.AP_RECT_MATCH_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_S

Line 1001: ap_invoice_distributions_s.nextval

997: 'EXPENSE',PD.expenditure_organization_id,
998: NULL), --expenditure_organization_id
999: DECODE(PD.destination_type_code,
1000: 'EXPENSE', PD.award_id), --award_id
1001: ap_invoice_distributions_s.nextval
1002: FROM po_distributions_ap_v PD,
1003: rcv_transactions RT
1004: WHERE PD.line_location_id = x_po_line_location_id
1005: and Pd.line_location_id = RT.po_line_location_id

Line 1261: ap_invoice_distributions_s.nextval

1257: pd.award_id,
1258: pd.expenditure_type,
1259: pd.expenditure_item_date,
1260: pd.expenditure_organization_id,
1261: ap_invoice_distributions_s.nextval
1262: INTO x_dist_tab(i).po_ccid,
1263: x_dist_tab(i).accrue_on_receipt_flag,
1264: x_dist_tab(i).project_id,
1265: x_dist_tab(i).task_id,

Line 3560: ap_invoice_distributions_s.nextval

3556: 'EXPENSE', DECODE(pd.accrue_on_receipt_flag,
3557: 'Y', pd.code_combination_id,
3558: aid.dist_code_combination_id),
3559: pd.variance_account_id),
3560: ap_invoice_distributions_s.nextval
3561: FROM ap_invoice_lines ail,
3562: ap_invoice_distributions aid,
3563: po_distributions pd
3564: WHERE ail.invoice_id = x_corrected_invoice_id

Line 3601: ap_invoice_distributions_s.nextval

3597: ) amount,
3598: round((x_correction_quantity * pd.quantity_billed)/
3599: p_total_quantity_billed , 15) corrected_quantity,
3600: aid.dist_code_combination_id,
3601: ap_invoice_distributions_s.nextval
3602: FROM ap_invoice_distributions aid,
3603: ap_invoice_lines ail,
3604: po_distributions pd
3605: WHERE ail.invoice_id = x_corrected_invoice_id

Line 3762: SELECT ap_invoice_distributions_s.nextval

3758: FOR i IN nvl(x_corr_dist_tab.first,0) ..nvl(x_corr_dist_tab.last,0) LOOP
3759:
3760: IF (x_corr_dist_tab.exists(i)) THEN
3761:
3762: SELECT ap_invoice_distributions_s.nextval
3763: INTO x_corr_dist_tab(i).invoice_distribution_id
3764: FROM dual ;
3765:
3766: x_corr_dist_tab(i).pa_quantity := x_corr_dist_tab(i).corrected_quantity;