DBA Data[Home] [Help]

APPS.IGI_AP_INV_DIST_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 19: FROM AP_INVOICE_DISTRIBUTIONS_ALL

15: ,X_igi_sap_flag VARCHAR2
16: ) IS
17: CURSOR C IS
18: SELECT *
19: FROM AP_INVOICE_DISTRIBUTIONS_ALL
20: WHERE rowid = X_Rowid
21: FOR UPDATE of invoice_id NOWAIT;
22: Recinfo C%ROWTYPE;
23:

Line 30: FROM AP_INVOICE_DISTRIBUTIONS_ALL

26: SELECT *
27: FROM IGI_INVOICE_DISTRIBUTIONS_ALL
28: WHERE (invoice_id,distribution_line_number,org_id) =
29: (SELECT invoice_id,distribution_line_number, org_id
30: FROM AP_INVOICE_DISTRIBUTIONS_ALL
31: WHERE rowid = X_Rowid)
32: FOR UPDATE of igi_sap_flag NOWAIT; */
33: CURSOR C1 IS
34: SELECT *

Line 38: FROM AP_INVOICE_DISTRIBUTIONS_ALL

34: SELECT *
35: FROM IGI_INVOICE_DISTRIBUTIONS_ALL
36: WHERE (invoice_id,invoice_line_number,distribution_line_number,org_id) =
37: (SELECT invoice_id,invoice_line_number,distribution_line_number, org_id
38: FROM AP_INVOICE_DISTRIBUTIONS_ALL
39: WHERE rowid = X_Rowid)
40: FOR UPDATE of igi_sap_flag NOWAIT;
41: Recinfo1 C1%ROWTYPE;
42: BEGIN