APPS.AP_MATCHING_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_S

Line 1171: ap_invoice_distributions_s.nextval

1167: 'EXPENSE',PD.expenditure_organization_id,
1168: NULL), --expenditure_organization_id
1169: DECODE(PD.destination_type_code,
1170: 'EXPENSE', PD.award_id), --award_id
1171: ap_invoice_distributions_s.nextval
1172: FROM po_distributions_ap_v PD
1173: WHERE line_location_id = x_po_line_location_id;
1174:
1175:

Line 1324: ap_invoice_distributions_s.nextval

1320: award_id,
1321: expenditure_type,
1322: expenditure_item_date,
1323: expenditure_organization_id,
1324: ap_invoice_distributions_s.nextval
1325: INTO x_dist_tab(i).accrue_on_receipt_flag,
1326: x_dist_tab(i).po_ccid,
1327: x_dist_tab(i).project_id,
1328: x_dist_tab(i).task_id,

Line 3626: ap_invoice_distributions_s.nextval

3622: 'EXPENSE', DECODE(pd.accrue_on_receipt_flag,
3623: 'Y', pd.code_combination_id,
3624: aid1.dist_code_combination_id),
3625: pd.variance_account_id),
3626: ap_invoice_distributions_s.nextval
3627: FROM ap_invoice_lines ail,
3628: ap_invoice_distributions aid1,
3629: po_distributions pd,
3630: ap_invoice_distributions aid2

Line 3668: ap_invoice_distributions_s.nextval

3664: ) amount,
3665: round((x_correction_quantity * decode(pd.distribution_type,'PREPAYMENT',nvl(pd.quantity_financed,0),nvl(pd.quantity_billed,0)))/
3666: p_total_quantity_billed , 15) corrected_quantity,
3667: aid.dist_code_combination_id,
3668: ap_invoice_distributions_s.nextval
3669: FROM ap_invoice_distributions aid,
3670: ap_invoice_lines ail,
3671: po_distributions pd
3672: WHERE ail.invoice_id = x_corrected_invoice_id

Line 3845: SELECT ap_invoice_distributions_s.nextval

3841: FOR i IN nvl(x_corr_dist_tab.first,0) ..nvl(x_corr_dist_tab.last,0) LOOP
3842:
3843: IF (x_corr_dist_tab.exists(i)) THEN
3844:
3845: SELECT ap_invoice_distributions_s.nextval
3846: INTO x_corr_dist_tab(i).invoice_distribution_id
3847: FROM DUAL;
3848:
3849: x_corr_dist_tab(i).pa_quantity := x_corr_dist_tab(i).corrected_quantity;