APPS.PAY_JP_WIC_PKG dependencies on PER_JP_CTR_UTILITY_PKG

Line 847: l_dpnt_rec per_jp_ctr_utility_pkg.t_itax_dpnt_rec;

843: p_dpnts out nocopy t_dpnts)
844: is
845: c_proc constant varchar2(61) := c_package || 'get_dpnts';
846: l_index number := 0;
847: l_dpnt_rec per_jp_ctr_utility_pkg.t_itax_dpnt_rec;
848: --
849: cursor csr_dep is
850: select /*+ ORDERED USE_NL(PER) */
851: per.last_name LAST_NAME_KANA,

Line 902: per_jp_ctr_utility_pkg.get_itax_dpnt_info(

898: --
899: -- No need to care for performance issue for multiple calls of the following PL/SQL function.
900: -- The following function caches the output variable result for the same input parameter values.
901: --
902: per_jp_ctr_utility_pkg.get_itax_dpnt_info(
903: p_assignment_id => p_assignment_id,
904: p_itax_type => p_itax_category,
905: p_effective_date => p_dpnt_effective_date,
906: p_itax_dpnt_rec => l_dpnt_rec);

Line 2469: l_dpnt_rec per_jp_ctr_utility_pkg.t_itax_dpnt_rec;

2465: is
2466: --
2467: c_proc constant varchar2(61) := c_package || 'get_basic_certificate_info (2)';
2468: --
2469: l_dpnt_rec per_jp_ctr_utility_pkg.t_itax_dpnt_rec;
2470: l_disabled_type varchar2(30);
2471: l_aged_type varchar2(30);
2472: l_widow_type varchar2(30);
2473: l_working_student_type varchar2(30);

Line 2750: per_jp_ctr_utility_pkg.get_itax_dpnt_info(

2746: or l_num_disableds is null
2747: or l_num_svr_disableds is null
2748: or l_num_svr_disableds_lt is null then
2749: --
2750: per_jp_ctr_utility_pkg.get_itax_dpnt_info(
2751: p_assignment_id => p_assignment_id,
2752: p_itax_type => p_itax_category,
2753: p_effective_date => p_dpnt_effective_date,
2754: p_itax_dpnt_rec => l_dpnt_rec);

Line 2797: per_jp_ctr_utility_pkg.get_itax_dpnt_info(

2793: --
2794: if l_dpnt_rec.assignment_id is null
2795: or l_dpnt_rec.assignment_id <> p_assignment_id then
2796: --
2797: per_jp_ctr_utility_pkg.get_itax_dpnt_info(
2798: p_assignment_id => p_assignment_id,
2799: p_itax_type => p_itax_category,
2800: p_effective_date => p_dpnt_effective_date,
2801: p_itax_dpnt_rec => l_dpnt_rec);