APPS.HR_NL_CALC_TARGET_GROUP dependencies on PER_CONTACT_RELATIONSHIPS

Line 6: p_contact_type per_contact_relationships.contact_type%type,

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:
10: l_cnty_of_birth per_all_people_f.country_of_birth%type;

Line 19: per_contact_relationships b

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
23: p_session_date between a.effective_start_date and a.effective_end_date and

Line 39: per_contact_relationships b

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
43: p_session_date between nvl(b.date_start, p_session_date) and