APPS.BEN_EXT_CHLG dependencies on PER_CONTACT_RELATIONSHIPS

Line 476: FROM per_contact_relationships pcr,

472: where bbg.benfts_grp_id = p_benfts_grp_id;
473: --
474: cursor c_relationship(p_person_id number) is
475: SELECT pcr.contact_relationship_id,pcr.person_id
476: FROM per_contact_relationships pcr,
477: hr_lookups hl
478: WHERE pcr.contact_person_id = p_person_id
479: AND pcr.contact_type = hl.lookup_code
480: AND hl.lookup_type = 'CONTACT';

Line 490: FROM per_contact_relationships pcr

486:
487: -- Get all the contact relationship person
488: cursor c_con_relationship(p_person_id number , p_date date ) is
489: SELECT pcr.contact_relationship_id, pcr.person_id,pcr.contact_type
490: FROM per_contact_relationships pcr
491: WHERE pcr.contact_person_id = p_person_id
492: AND pcr.personal_flag = 'Y'
493: and p_date between pcr.date_start and nvl(pcr.date_end, p_date)
494: ;

Line 512: l_contact per_contact_relationships.contact_relationship_id%type;

508: l_new_student_status hr_lookups.meaning%type ;
509: l_old_ethnic_group hr_lookups.meaning%type ;
510: l_new_ethnic_group hr_lookups.meaning%type ;
511: l_relationship per_all_people_f.person_id%type;
512: l_contact per_contact_relationships.contact_relationship_id%type;
513: l_person_type per_person_types.system_person_type%type ;
514: --
515: l_proc varchar2(100) := 'ben_ext_chlg.log_per_chg';
516: --

Line 2022: l_contact per_contact_relationships.contact_relationship_id%type;

2018: l_person_id number;
2019: l_business_group_id number;
2020: l_relationship per_all_people_f.person_id%type;
2021: l_name per_all_people_f.full_name%type;
2022: l_contact per_contact_relationships.contact_relationship_id%type;
2023: --
2024: cursor c_relationship(p_person_id number) is
2025: SELECT pcr.contact_relationship_id,pcr.person_id,ppf.full_name
2026: FROM per_contact_relationships pcr,

Line 2026: FROM per_contact_relationships pcr,

2022: l_contact per_contact_relationships.contact_relationship_id%type;
2023: --
2024: cursor c_relationship(p_person_id number) is
2025: SELECT pcr.contact_relationship_id,pcr.person_id,ppf.full_name
2026: FROM per_contact_relationships pcr,
2027: per_all_people_f ppf,
2028: per_person_types ppt,
2029: hr_lookups hl
2030: WHERE pcr.contact_person_id = p_person_id

Line 2039: FROM per_contact_relationships pcr,

2035: AND hl.lookup_type = 'CONTACT';
2036:
2037: cursor c_con_relationship(p_person_id number,p_effective_date date) is
2038: SELECT pcr.contact_relationship_id,pcr.person_id,ppf.full_name
2039: FROM per_contact_relationships pcr,
2040: per_all_people_f ppf,
2041: hr_lookups hl
2042: WHERE pcr.contact_person_id = p_person_id
2043: AND ppf.person_id = p_person_id

Line 4649: FROM per_contact_relationships pcr,

4645: --
4646: cursor c_relationship(p_person_id number
4647: ,p_dpnt_person_id number)is
4648: SELECT hl.meaning
4649: FROM per_contact_relationships pcr,
4650: hr_lookups hl
4651: WHERE pcr.person_id = p_person_id
4652: AND pcr.contact_person_id = p_dpnt_person_id
4653: AND pcr.contact_type = hl.lookup_code

Line 4909: l_contact per_contact_relationships.contact_relationship_id%type;

4905: -- Local variable declarations
4906: --
4907: l_proc varchar2(72) := 'ben_ext_chlg.log_pcp_chg';
4908: l_relationship per_all_people_f.person_id%type;
4909: l_contact per_contact_relationships.contact_relationship_id%type;
4910: l_name per_all_people_f.full_name%type;
4911: --
4912: cursor c_relationship(p_person_id number) is
4913: SELECT pcr.contact_relationship_id,pcr.person_id,ppf.full_name

Line 4914: FROM per_contact_relationships pcr,

4910: l_name per_all_people_f.full_name%type;
4911: --
4912: cursor c_relationship(p_person_id number) is
4913: SELECT pcr.contact_relationship_id,pcr.person_id,ppf.full_name
4914: FROM per_contact_relationships pcr,
4915: per_all_people_f ppf,
4916: per_person_types ppt,
4917: hr_lookups hl
4918: WHERE pcr.contact_person_id = p_person_id

Line 4927: FROM per_contact_relationships pcr,

4923: AND hl.lookup_type = 'CONTACT';
4924:
4925: cursor c_con_relationship(p_person_id number) is
4926: SELECT pcr.contact_relationship_id,pcr.person_id,ppf.full_name
4927: FROM per_contact_relationships pcr,
4928: per_all_people_f ppf,
4929: hr_lookups hl
4930: WHERE pcr.contact_person_id = p_person_id
4931: AND ppf.person_id = p_person_id