eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_EPY_BUS dependencies on BEN_ELIG_PYRL_PRTE_F

Line 121: from ben_elig_pyrl_prte_f

117: l_exists varchar2(1);
118: --
119: cursor c3 is
120: select null
121: from ben_elig_pyrl_prte_f
122: where payroll_id = p_payroll_id
123: and eligy_prfl_id = p_eligy_prfl_id
124: and elig_pyrl_prte_id <> nvl(p_elig_pyrl_prte_id,hr_api.g_number)
125: and business_group_id + 0 = p_business_group_id

Line 300: from ben_elig_pyrl_prte_f

296: l_proc varchar2(72) := g_package||'chk_duplicate_ordr_num';
297: l_dummy char(1);
298: cursor c1 is
299: select null
300: from ben_elig_pyrl_prte_f
301: where elig_pyrl_prte_id <> nvl(p_elig_pyrl_prte_id,-1)
302: and eligy_prfl_id = p_eligy_prfl_id
303: and ordr_num = p_ordr_num
304: and business_group_id = p_business_group_id;

Line 671: ben_elig_pyrl_prte_f b

667: --
668: cursor csr_leg_code is
669: select a.legislation_code
670: from per_business_groups a,
671: ben_elig_pyrl_prte_f b
672: where b.elig_pyrl_prte_id = p_elig_pyrl_prte_id
673: and a.business_group_id = b.business_group_id;
674: --
675: -- Declare local variables