DBA Data[Home] [Help]

APPS.JAI_AP_MATCH_TAX_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_S

Line 870: select ap_invoice_distributions_s.nextval

866:
867:
868: -- Start add for bug#3632810
869: CURSOR c_get_invoice_distribution is -- bug#3332988
870: select ap_invoice_distributions_s.nextval
871: from dual;
872:
873: -- start addition by ssumaith -bug# 3127834
874:

Line 2951: ap_invoice_distributions_s.CURRVAL,

2947: )
2948: VALUES
2949: (
2950: inv_id,
2951: ap_invoice_distributions_s.CURRVAL,
2952: for_dist_insertion_rec.set_of_books_id,
2953: v_batch_id,
2954: for_dist_insertion_rec.po_distribution_id,
2955: rcv_tran_id,

Line 3796: ap_invoice_distributions_s.CURRVAL,

3792: )
3793: VALUES
3794: (
3795: inv_id,
3796: ap_invoice_distributions_s.CURRVAL,
3797: for_dist_insertion_rec.set_of_books_id,
3798: v_batch_id,
3799: for_dist_insertion_rec.po_distribution_id,
3800: rcv_tran_id,

Line 4668: ap_invoice_distributions_s.CURRVAL,

4664: )
4665: VALUES
4666: (
4667: inv_id,
4668: ap_invoice_distributions_s.CURRVAL,
4669: for_dist_insertion_rec.set_of_books_id,
4670: v_batch_id,
4671: for_dist_insertion_rec.po_distribution_id,
4672: rcv_tran_id,

Line 5609: ap_invoice_distributions_s.CURRVAL,

5605: )
5606: VALUES
5607: (
5608: inv_id,
5609: ap_invoice_distributions_s.CURRVAL,
5610: for_dist_insertion_rec.set_of_books_id,
5611: v_batch_id,
5612: for_dist_insertion_rec.po_distribution_id,
5613: rcv_tran_id,

Line 5936: select ap_invoice_distributions_s.nextval

5932: WHERE INVOICE_ID = inv_id)
5933: FOR UPDATE OF DISTRIBUTION_LINE_NUMBER;
5934:
5935: cursor c_get_invoice_distribution is -- bug#3332988
5936: select ap_invoice_distributions_s.nextval
5937: from dual;
5938:
5939: -- start addition by ssumaith -bug# 3127834
5940:

Line 7421: v_invoice_distribution_id, -- BUG#3332988 ap_invoice_distributions_s.NEXTVAL,

7417: for_dist_insertion_rec.program_application_id,
7418: for_dist_insertion_rec.program_id,
7419: for_dist_insertion_rec.program_update_date,
7420: for_dist_insertion_rec.accts_pay_code_combination_id,
7421: v_invoice_distribution_id, -- BUG#3332988 ap_invoice_distributions_s.NEXTVAL,
7422: 0,
7423: for_dist_insertion_rec.org_id, -- Bug 4863208
7424: po_dist_id ,
7425: rcv_tran_id,

Line 7607: ap_invoice_distributions_s.CURRVAL,

7603: )
7604: VALUES
7605: (
7606: inv_id,
7607: ap_invoice_distributions_s.CURRVAL,
7608: for_dist_insertion_rec.set_of_books_id,
7609: v_batch_id,
7610: for_dist_insertion_rec.po_distribution_id,
7611: rcv_tran_id,

Line 8453: ap_invoice_distributions_s.CURRVAL,

8449: )
8450: VALUES
8451: (
8452: inv_id,
8453: ap_invoice_distributions_s.CURRVAL,
8454: for_dist_insertion_rec.set_of_books_id,
8455: v_batch_id,
8456: for_dist_insertion_rec.po_distribution_id,
8457: rcv_tran_id,

Line 9299: ap_invoice_distributions_s.CURRVAL,

9295: )
9296: VALUES
9297: (
9298: inv_id,
9299: ap_invoice_distributions_s.CURRVAL,
9300: for_dist_insertion_rec.set_of_books_id,
9301: v_batch_id,
9302: for_dist_insertion_rec.po_distribution_id,
9303: rcv_tran_id,