APPS.PER_CAGR_UTILITY_PKG dependencies on BEN_OIPL_F

Line 384: FUNCTION get_next_order_number(p_pl_id IN ben_oipl_f.pl_id%TYPE) RETURN NUMBER IS

380: -- ----------------------------------------------------------------------------
381: -- |--------------------------< get_next_order_number >-----------------------|
382: -- ----------------------------------------------------------------------------
383: --
384: FUNCTION get_next_order_number(p_pl_id IN ben_oipl_f.pl_id%TYPE) RETURN NUMBER IS
385: --
386: -- Declare Cursors
387: --
388: CURSOR csr_order_number IS

Line 390: FROM ben_oipl_f b

386: -- Declare Cursors
387: --
388: CURSOR csr_order_number IS
389: SELECT MAX(b.ordr_num)+10
390: FROM ben_oipl_f b
391: WHERE b.pl_id = p_pl_id;
392: --
393: -- Declare Local Variables
394: --

Line 396: l_order_number ben_oipl_f.ordr_num%TYPE;

392: --
393: -- Declare Local Variables
394: --
395: l_proc VARCHAR2(72) := g_pkg||'get_order_number';
396: l_order_number ben_oipl_f.ordr_num%TYPE;
397: --
398: BEGIN
399: --
400: hr_utility.set_location('Entering:'|| l_proc, 10);