DBA Data[Home] [Help]

APPS.PAY_JP_WIC_PKG dependencies on PER_JP_CTR_UTILITY_PKG

Line 707: l_dpnt_rec per_jp_ctr_utility_pkg.t_itax_dpnt_rec;

703: p_dpnts out nocopy t_dpnts)
704: is
705: c_proc constant varchar2(61) := c_package || 'get_dpnts';
706: l_index number := 0;
707: l_dpnt_rec per_jp_ctr_utility_pkg.t_itax_dpnt_rec;
708: --
709: cursor csr_dep is
710: select /*+ ORDERED USE_NL(PER) */
711: per.last_name LAST_NAME_KANA,

Line 757: per_jp_ctr_utility_pkg.get_itax_dpnt_info(

753: --
754: -- No need to care for performance issue for multiple calls of the following PL/SQL function.
755: -- The following function caches the output variable result for the same input parameter values.
756: --
757: per_jp_ctr_utility_pkg.get_itax_dpnt_info(
758: p_assignment_id => p_assignment_id,
759: p_itax_type => p_itax_category,
760: p_effective_date => p_dpnt_effective_date,
761: p_itax_dpnt_rec => l_dpnt_rec);

Line 1409: l_dpnt_rec per_jp_ctr_utility_pkg.t_itax_dpnt_rec;

1405: p_prev_jobs out nocopy t_prev_jobs)
1406: is
1407: c_proc constant varchar2(61) := c_package || 'get_basic_certificate_info (2)';
1408: --
1409: l_dpnt_rec per_jp_ctr_utility_pkg.t_itax_dpnt_rec;
1410: l_disabled_type varchar2(30);
1411: l_aged_type varchar2(30);
1412: l_widow_type varchar2(30);
1413: l_working_student_type varchar2(30);

Line 1587: per_jp_ctr_utility_pkg.get_itax_dpnt_info(

1583: or l_num_specifieds is null
1584: or l_num_disableds is null
1585: or l_num_svr_disableds is null
1586: or l_num_svr_disableds_lt is null then
1587: per_jp_ctr_utility_pkg.get_itax_dpnt_info(
1588: p_assignment_id => p_assignment_id,
1589: p_itax_type => p_itax_category,
1590: p_effective_date => p_dpnt_effective_date,
1591: p_itax_dpnt_rec => l_dpnt_rec);