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 HR_LOOKUPS

Line 7: c_default_itax_dpnt_ref_type constant hr_lookups.lookup_code%type := 'CTR_EE';

3: --
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'));

Line 10: c_husband_kanji constant hr_lookups.meaning%type := fnd_message.get_string('PAY', 'PAY_JP_HUSBAND');

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'));
14: --

Line 11: c_husband_kana constant hr_lookups.meaning%type := hr_jp_standard_pkg.upper_kana(fnd_message.get_string('PAY', 'PAY_JP_HUSBAND_KANA'));

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'));
14: --
15: -- Global Variables

Line 12: c_wife_kanji constant hr_lookups.meaning%type := fnd_message.get_string('PAY', 'PAY_JP_WIFE');

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'));
14: --
15: -- Global Variables
16: -- Cache Information

Line 13: c_wife_kana constant hr_lookups.meaning%type := hr_jp_standard_pkg.upper_kana(fnd_message.get_string('PAY', 'PAY_JP_WIFE_KANA'));

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'));
14: --
15: -- Global Variables
16: -- Cache Information
17: --

Line 22: ref_type hr_lookups.lookup_code%type);

18: g_itax_dpnt_rec t_itax_dpnt_rec;
19: --
20: type t_bg_itax_dpnt_rec is record(
21: business_group_id number,
22: ref_type hr_lookups.lookup_code%type);
23: g_bg_itax_dpnt_rec t_bg_itax_dpnt_rec;
24: -- ----------------------------------------------------------------------------
25: -- |------------------------< bg_itax_dpnt_ref_type >-------------------------|
26: -- ----------------------------------------------------------------------------

Line 150: -- hr_lookups hrl1,

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

Line 151: -- hr_lookups hrl2

147: -- and nvl(trunc(per.date_of_death, 'YYYY'), l_soy) >= l_soy
148: -- ) v,
149: -- per_contact_extra_info_f cei,
150: -- hr_lookups hrl1,
151: -- hr_lookups hrl2
152: -- /* Here again narrows CTR date range either date_of_death or effective_date. */
153: -- where v.effective_date
154: -- between nvl(v.date_start, v.effective_date) and nvl(v.date_end, v.effective_date)
155: -- and cei.contact_relationship_id(+) = v.contact_relationship_id

Line 196: hr_lookups hrl1,

192: from per_all_assignments_f asg,
193: per_contact_relationships ctr,
194: per_contact_extra_info_f cei,
195: per_all_people_f per,
196: hr_lookups hrl1,
197: hr_lookups hrl2
198: where asg.assignment_id = p_assignment_id
199: and l_effective_date
200: between asg.effective_start_date and asg.effective_end_date

Line 197: hr_lookups hrl2

193: per_contact_relationships ctr,
194: per_contact_extra_info_f cei,
195: per_all_people_f per,
196: hr_lookups hrl1,
197: hr_lookups hrl2
198: where asg.assignment_id = p_assignment_id
199: and l_effective_date
200: between asg.effective_start_date and asg.effective_end_date
201: and ctr.person_id = asg.person_id