DBA Data[Home] [Help]

APPS.CST_UNINVOICEDRECEIPTS_PVT dependencies on GL_SETS_OF_BOOKS

Line 220: gl_sets_of_books sob

216: AND gps.set_of_books_id = l_sob_id
217: AND gps.period_name = NVL(p_period_name,
218: (SELECT gp.period_name
219: FROM gl_periods gp,
220: gl_sets_of_books sob
221: WHERE sob.set_of_books_id = l_sob_id
222: AND sob.period_set_name = gp.period_set_name
223: AND sob.accounted_period_type = gp.period_type
224: AND gp.ADJUSTMENT_PERIOD_FLAG = 'N'

Line 348: FROM gl_sets_of_books gsb

344: :p_vendor_to vendor_to,
345: :l_order_by order_by,
346: :l_row_count row_count,
347: :l_qty_precision qty_precision
348: FROM gl_sets_of_books gsb
349: WHERE gsb.set_of_books_id = :l_sob_id'
350: USING
351: p_title,
352: l_accrued_receipts,

Line 453: gl_sets_of_books sob

449: fnd_currencies fnc2,
450: mtl_categories_kfv mca,
451: gl_code_combinations_kfv gcc1,
452: gl_code_combinations_kfv gcc2,
453: gl_sets_of_books sob
454: WHERE pod.po_distribution_id = cpea.distribution_id
455: AND poh.po_header_id = pol.po_header_id
456: AND pol.po_line_id = poll.po_line_id
457: AND poll.line_location_id = pod.line_location_id