DBA Data[Home] [Help]

APPS.CST_UNINVOICEDRECEIPTS_PVT dependencies on GL_SETS_OF_BOOKS

Line 161: gl_sets_of_books sob

157: AND gps.set_of_books_id = l_sob_id
158: AND gps.period_name = NVL(p_period_name,
159: (SELECT gp.period_name
160: FROM gl_periods gp,
161: gl_sets_of_books sob
162: WHERE sob.set_of_books_id = l_sob_id
163: AND sob.period_set_name = gp.period_set_name
164: AND sob.accounted_period_type = gp.period_type
165: AND gp.start_date <= TRUNC(SYSDATE)

Line 246: FROM gl_sets_of_books gsb

242: :p_vendor_from vendor_from,
243: :p_vendor_to vendor_to,
244: :l_order_by order_by,
245: :l_row_count row_count
246: FROM gl_sets_of_books gsb
247: WHERE gsb.set_of_books_id = :l_sob_id'
248: USING
249: p_title,
250: p_accrued_receipts,

Line 346: gl_sets_of_books sob

342: fnd_currencies fnc2,
343: mtl_categories_kfv mca,
344: gl_code_combinations_kfv gcc1,
345: gl_code_combinations_kfv gcc2,
346: gl_sets_of_books sob
347: WHERE pod.po_distribution_id = cpea.distribution_id
348: AND poh.po_header_id = pol.po_header_id
349: AND pol.po_line_id = poll.po_line_id
350: AND poll.line_location_id = pod.line_location_id