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.HR_NL_CALC_TARGET_GROUP dependencies on PER_ALL_PEOPLE_F

Line 5: FUNCTION get_country_code (p_person_id per_all_people_f.person_id%type,

1: PACKAGE BODY HR_NL_CALC_TARGET_GROUP AS
2: /* $Header: pernlctg.pkb 115.3 2002/06/12 02:40:49 pkm ship $ */
3:
4: --
5: FUNCTION get_country_code (p_person_id per_all_people_f.person_id%type,
6: p_contact_type per_contact_relationships.contact_type%type,
7: p_session_date date)
8: return VARCHAR2 is
9:

Line 10: l_cnty_of_birth per_all_people_f.country_of_birth%type;

6: p_contact_type per_contact_relationships.contact_type%type,
7: p_session_date date)
8: return VARCHAR2 is
9:
10: l_cnty_of_birth per_all_people_f.country_of_birth%type;
11: l_data_flag varchar2(1);
12:
13: begin
14: l_data_flag := 'Y';

Line 18: from per_all_people_f a,

14: l_data_flag := 'Y';
15: begin
16: select a.country_of_birth
17: into l_cnty_of_birth
18: from per_all_people_f a,
19: per_contact_relationships b
20: where a.person_id = b.contact_person_id and
21: b.person_id = p_person_id and
22: b.contact_type = p_contact_type and

Line 38: from per_all_people_f a,

34: if l_data_flag = 'N' then
35: begin
36: select a.country_of_birth
37: into l_cnty_of_birth
38: from per_all_people_f a,
39: per_contact_relationships b
40: where a.person_id = b.contact_person_id and
41: b.person_id = p_person_id and
42: b.contact_type = p_contact_type and

Line 57: FUNCTION run_formula (p_country_of_birth_fth per_all_people_f.country_of_birth%type,

53: return l_cnty_of_birth ;
54:
55: end;
56: --
57: FUNCTION run_formula (p_country_of_birth_fth per_all_people_f.country_of_birth%type,
58: p_country_of_birth_mth per_all_people_f.country_of_birth%type,
59: p_country_of_birth_emp per_all_people_f.country_of_birth%type,
60: p_business_group_id per_all_people_f.business_group_id%type,
61: p_session_date date)

Line 58: p_country_of_birth_mth per_all_people_f.country_of_birth%type,

54:
55: end;
56: --
57: FUNCTION run_formula (p_country_of_birth_fth per_all_people_f.country_of_birth%type,
58: p_country_of_birth_mth per_all_people_f.country_of_birth%type,
59: p_country_of_birth_emp per_all_people_f.country_of_birth%type,
60: p_business_group_id per_all_people_f.business_group_id%type,
61: p_session_date date)
62: return VARCHAR2 is

Line 59: p_country_of_birth_emp per_all_people_f.country_of_birth%type,

55: end;
56: --
57: FUNCTION run_formula (p_country_of_birth_fth per_all_people_f.country_of_birth%type,
58: p_country_of_birth_mth per_all_people_f.country_of_birth%type,
59: p_country_of_birth_emp per_all_people_f.country_of_birth%type,
60: p_business_group_id per_all_people_f.business_group_id%type,
61: p_session_date date)
62: return VARCHAR2 is
63:

Line 60: p_business_group_id per_all_people_f.business_group_id%type,

56: --
57: FUNCTION run_formula (p_country_of_birth_fth per_all_people_f.country_of_birth%type,
58: p_country_of_birth_mth per_all_people_f.country_of_birth%type,
59: p_country_of_birth_emp per_all_people_f.country_of_birth%type,
60: p_business_group_id per_all_people_f.business_group_id%type,
61: p_session_date date)
62: return VARCHAR2 is
63:
64: l_formula_id ff_formulas_f_v.formula_id%type;

Line 94: FUNCTION get_target_group (p_person_id per_all_people_f.person_id%type,

90:
91: return l_target_group;
92: end;
93: --
94: FUNCTION get_target_group (p_person_id per_all_people_f.person_id%type,
95: p_session_date date) return VARCHAR2 is
96:
97: l_country_of_birth_fth per_all_people_f.country_of_birth%type;
98: l_country_of_birth_mth per_all_people_f.country_of_birth%type;

Line 97: l_country_of_birth_fth per_all_people_f.country_of_birth%type;

93: --
94: FUNCTION get_target_group (p_person_id per_all_people_f.person_id%type,
95: p_session_date date) return VARCHAR2 is
96:
97: l_country_of_birth_fth per_all_people_f.country_of_birth%type;
98: l_country_of_birth_mth per_all_people_f.country_of_birth%type;
99: l_country_of_birth_emp per_all_people_f.country_of_birth%type;
100: l_business_group_id per_all_people_f.business_group_id%type;
101: l_formula_id ff_formulas_f.formula_id%type;

Line 98: l_country_of_birth_mth per_all_people_f.country_of_birth%type;

94: FUNCTION get_target_group (p_person_id per_all_people_f.person_id%type,
95: p_session_date date) return VARCHAR2 is
96:
97: l_country_of_birth_fth per_all_people_f.country_of_birth%type;
98: l_country_of_birth_mth per_all_people_f.country_of_birth%type;
99: l_country_of_birth_emp per_all_people_f.country_of_birth%type;
100: l_business_group_id per_all_people_f.business_group_id%type;
101: l_formula_id ff_formulas_f.formula_id%type;
102: l_effective_start_date ff_formulas_f.effective_start_date%type;

Line 99: l_country_of_birth_emp per_all_people_f.country_of_birth%type;

95: p_session_date date) return VARCHAR2 is
96:
97: l_country_of_birth_fth per_all_people_f.country_of_birth%type;
98: l_country_of_birth_mth per_all_people_f.country_of_birth%type;
99: l_country_of_birth_emp per_all_people_f.country_of_birth%type;
100: l_business_group_id per_all_people_f.business_group_id%type;
101: l_formula_id ff_formulas_f.formula_id%type;
102: l_effective_start_date ff_formulas_f.effective_start_date%type;
103: l_target_group varchar2(10);

Line 100: l_business_group_id per_all_people_f.business_group_id%type;

96:
97: l_country_of_birth_fth per_all_people_f.country_of_birth%type;
98: l_country_of_birth_mth per_all_people_f.country_of_birth%type;
99: l_country_of_birth_emp per_all_people_f.country_of_birth%type;
100: l_business_group_id per_all_people_f.business_group_id%type;
101: l_formula_id ff_formulas_f.formula_id%type;
102: l_effective_start_date ff_formulas_f.effective_start_date%type;
103: l_target_group varchar2(10);
104: l_label_text hr_lookups.meaning%type;

Line 107: l_local_birth_country_fth per_all_people_f.per_information11%type;

103: l_target_group varchar2(10);
104: l_label_text hr_lookups.meaning%type;
105: l_rec_status varchar2(20);
106: l_return_target_group varchar2(1);
107: l_local_birth_country_fth per_all_people_f.per_information11%type;
108: l_local_birth_country_mth per_all_people_f.per_information12%type;
109:
110: begin
111: begin

Line 108: l_local_birth_country_mth per_all_people_f.per_information12%type;

104: l_label_text hr_lookups.meaning%type;
105: l_rec_status varchar2(20);
106: l_return_target_group varchar2(1);
107: l_local_birth_country_fth per_all_people_f.per_information11%type;
108: l_local_birth_country_mth per_all_people_f.per_information12%type;
109:
110: begin
111: begin
112: select per_information11, per_information12

Line 114: from per_all_people_f

110: begin
111: begin
112: select per_information11, per_information12
113: into l_local_birth_country_fth, l_local_birth_country_mth
114: from per_all_people_f
115: where person_id = p_person_id
116: and p_session_date between effective_start_date
117: and effective_end_date;
118: exception

Line 146: from per_all_people_f

142: select country_of_birth,
143: business_group_id
144: into l_country_of_birth_emp,
145: l_business_group_id
146: from per_all_people_f
147: where person_id = p_person_id and
148: p_session_date between effective_start_date and effective_end_date;
149: exception
150: when no_data_found then