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.PER_JP_CTR_UTILITY_PKG dependencies on PER_CONTACT_EXTRA_INFO_F

Line 8: c_kou_information_type constant per_contact_extra_info_f.information_type%TYPE := 'JP_ITAX_DEPENDENT';

4: -- Constants
5: --
6: c_package constant varchar2(31) := 'per_jp_ctr_utility_pkg.';
7: c_default_itax_dpnt_ref_type constant hr_lookups.lookup_code%type := 'CTR_EE';
8: c_kou_information_type constant per_contact_extra_info_f.information_type%TYPE := 'JP_ITAX_DEPENDENT';
9: c_otsu_information_type constant per_contact_extra_info_f.information_type%TYPE := 'JP_ITAX_DEPENDENT_ON_OTHER_PAY';
10: c_husband_kanji constant hr_lookups.meaning%type := fnd_message.get_string('PAY', 'PAY_JP_HUSBAND');
11: c_husband_kana constant hr_lookups.meaning%type := hr_jp_standard_pkg.upper_kana(fnd_message.get_string('PAY', 'PAY_JP_HUSBAND_KANA'));
12: c_wife_kanji constant hr_lookups.meaning%type := fnd_message.get_string('PAY', 'PAY_JP_WIFE');

Line 9: c_otsu_information_type constant per_contact_extra_info_f.information_type%TYPE := 'JP_ITAX_DEPENDENT_ON_OTHER_PAY';

5: --
6: c_package constant varchar2(31) := 'per_jp_ctr_utility_pkg.';
7: c_default_itax_dpnt_ref_type constant hr_lookups.lookup_code%type := 'CTR_EE';
8: c_kou_information_type constant per_contact_extra_info_f.information_type%TYPE := 'JP_ITAX_DEPENDENT';
9: c_otsu_information_type constant per_contact_extra_info_f.information_type%TYPE := 'JP_ITAX_DEPENDENT_ON_OTHER_PAY';
10: c_husband_kanji constant hr_lookups.meaning%type := fnd_message.get_string('PAY', 'PAY_JP_HUSBAND');
11: c_husband_kana constant hr_lookups.meaning%type := hr_jp_standard_pkg.upper_kana(fnd_message.get_string('PAY', 'PAY_JP_HUSBAND_KANA'));
12: c_wife_kanji constant hr_lookups.meaning%type := fnd_message.get_string('PAY', 'PAY_JP_WIFE');
13: c_wife_kana constant hr_lookups.meaning%type := hr_jp_standard_pkg.upper_kana(fnd_message.get_string('PAY', 'PAY_JP_WIFE_KANA'));

Line 58: -- PER_CONTACT_EXTRA_INFO_F

54: -- ----------------------------------------------------------------------------
55: --
56: -- Procedure to derive dependent information from
57: -- PER_CONTACT_RELATIONSHIPS
58: -- PER_CONTACT_EXTRA_INFO_F
59: --
60: -- ----------------------------------------------------------------------------
61: procedure get_itax_dpnt_info(
62: p_assignment_id in number,

Line 73: l_information_type per_contact_extra_info_f.information_type%TYPE;

69: l_proc varchar2(61) := c_package || 'get_itax_dpnt_info';
70: l_effective_date date := p_effective_date;
71: l_soy date;
72: l_eoy date;
73: l_information_type per_contact_extra_info_f.information_type%TYPE;
74: l_index number := 0;
75: --
76: -- Note that the age used below is January 1st in the next calendar year.
77: -- Normally, effective date used is date paid, but if contact person is deceased,

Line 150: -- per_contact_extra_info_f cei,

146: -- )
147: -- /* Deceased person is available until the end of year in which the effective_date falls. */
148: -- and nvl(trunc(per.date_of_death, 'YYYY'), l_soy) >= l_soy
149: -- ) v,
150: -- per_contact_extra_info_f cei,
151: -- hr_lookups hrl1,
152: -- hr_lookups hrl2
153: -- /* Here again narrows CTR date range either date_of_death or effective_date. */
154: -- where v.effective_date

Line 197: per_contact_extra_info_f cei,

193: per.last_name LAST_NAME_KANA,
194: per.first_name FIRST_NAME_KANA
195: from per_all_assignments_f asg,
196: per_contact_relationships ctr,
197: per_contact_extra_info_f cei,
198: per_all_people_f per,
199: hr_lookups hrl1,
200: hr_lookups hrl2
201: where asg.assignment_id = p_assignment_id