DBA Data[Home] [Help]

APPS.AP_RCT_AMT_MATCH_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_S

Line 1030: ap_invoice_distributions_s.nextval

1026: 'EXPENSE',PD.expenditure_organization_id,
1027: NULL), --expenditure_organization_id
1028: DECODE(PD.destination_type_code,
1029: 'EXPENSE', PD.award_id), --award_id
1030: ap_invoice_distributions_s.nextval
1031: FROM po_distributions_ap_v PD,
1032: rcv_transactions RT
1033: WHERE PD.line_location_id = x_po_line_location_id
1034: and Pd.line_location_id = RT.po_line_location_id

Line 1258: ap_invoice_distributions_s.nextval

1254: pod.award_id,
1255: pod.expenditure_type,
1256: pod.expenditure_item_date,
1257: pod.expenditure_organization_id,
1258: ap_invoice_distributions_s.nextval
1259: INTO x_dist_tab(i).accrue_on_receipt_flag,
1260: x_dist_tab(i).po_ccid,
1261: x_dist_tab(i).project_id,
1262: x_dist_tab(i).task_id,

Line 3385: ap_invoice_distributions_s.nextval

3381: round((x_correction_amount * aid.amount/ail.amount)
3382: /g_min_acct_unit) * g_min_acct_unit
3383: ) amount,
3384: aid.dist_code_combination_id,
3385: ap_invoice_distributions_s.nextval
3386: FROM ap_invoice_lines ail,
3387: ap_invoice_distributions aid
3388: WHERE ail.invoice_id = x_corrected_invoice_id
3389: AND ail.line_number = x_corrected_line_number

Line 3462: SELECT ap_invoice_distributions_s.nextval

3458: FOR i IN nvl(x_corr_dist_tab.first,0) ..nvl(x_corr_dist_tab.last,0) LOOP
3459:
3460: IF (x_corr_dist_tab.exists(i)) THEN
3461:
3462: SELECT ap_invoice_distributions_s.nextval
3463: INTO x_corr_dist_tab(i).invoice_distribution_id
3464: FROM DUAL;
3465:
3466: x_corr_dist_tab(i).pa_quantity := Null;