APPS.PA_MC_CURRENCY_PKG dependencies on GL_SETS_OF_BOOKS

Line 61: FROM gl_sets_of_books gl,

57: G_PREV_ORG_ID := x_org_id;
58:
59: SELECT gl.currency_code
60: INTO currency
61: FROM gl_sets_of_books gl,
62: pa_implementations_all i
63: -- WHERE NVL(i.org_id,-99) = NVL(x_org_id,-99)
64: WHERE i.org_id = x_org_id -- x_org_id also taken from Implementation table.
65: AND i.set_of_books_id = gl.set_of_books_id;

Line 144: FROM gl_sets_of_books gl

140: BEGIN
141:
142: SELECT mrc_sob_type_code
143: INTO sob_type
144: FROM gl_sets_of_books gl
145: WHERE gl.set_of_books_id = x_set_of_books_id;
146:
147: RETURN sob_type;
148:

Line 163: FROM gl_sets_of_books gl,

159:
160: BEGIN
161: SELECT mrc_sob_type_code
162: INTO sob_type
163: FROM gl_sets_of_books gl,
164: pa_implementations imp
165: WHERE gl.set_of_books_id = imp.set_of_books_id;
166:
167: RETURN sob_type;

Line 1093: FROM gl_sets_of_books sob,

1089: x_exchange_date,
1090: x_exchange_rate_type,
1091: x_amount,
1092: l_reporting_curr_code
1093: FROM gl_sets_of_books sob,
1094: ap_mc_invoice_dists mc,
1095: ap_invoice_distributions ap
1096: WHERE ap.invoice_id = x_invoice_id
1097: AND ap.distribution_line_number = x_line_num