DBA Data[Home] [Help]

APPS.AP_RCT_AMT_MATCH_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_S

Line 932: ap_invoice_distributions_s.nextval

928: 'EXPENSE',PD.expenditure_organization_id,
929: NULL), --expenditure_organization_id
930: DECODE(PD.destination_type_code,
931: 'EXPENSE', PD.award_id), --award_id
932: ap_invoice_distributions_s.nextval
933: FROM po_distributions_ap_v PD,
934: rcv_transactions RT
935: WHERE PD.line_location_id = x_po_line_location_id
936: and Pd.line_location_id = RT.po_line_location_id

Line 1150: ap_invoice_distributions_s.nextval

1146: award_id,
1147: expenditure_type,
1148: expenditure_item_date,
1149: expenditure_organization_id,
1150: ap_invoice_distributions_s.nextval
1151: INTO x_dist_tab(i).accrue_on_receipt_flag,
1152: x_dist_tab(i).po_ccid,
1153: x_dist_tab(i).project_id,
1154: x_dist_tab(i).task_id,

Line 3220: ap_invoice_distributions_s.nextval

3216: round((x_correction_amount * aid.amount/ail.amount)
3217: /g_min_acct_unit) * g_min_acct_unit
3218: ) amount,
3219: aid.dist_code_combination_id,
3220: ap_invoice_distributions_s.nextval
3221: FROM ap_invoice_lines ail,
3222: ap_invoice_distributions aid
3223: WHERE ail.invoice_id = x_corrected_invoice_id
3224: AND ail.line_number = x_corrected_line_number

Line 3296: SELECT ap_invoice_distributions_s.nextval

3292: FOR i IN nvl(x_corr_dist_tab.first,0) ..nvl(x_corr_dist_tab.last,0) LOOP
3293:
3294: IF (x_corr_dist_tab.exists(i)) THEN
3295:
3296: SELECT ap_invoice_distributions_s.nextval
3297: INTO x_corr_dist_tab(i).invoice_distribution_id
3298: FROM DUAL;
3299:
3300: x_corr_dist_tab(i).pa_quantity := Null;