APPS.BEN_EXT_CHLG dependencies on PER_CONTACT_RELATIONSHIPS

Line 475: FROM per_contact_relationships pcr,

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

Line 489: FROM per_contact_relationships pcr

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

Line 511: l_contact per_contact_relationships.contact_relationship_id%type;

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

Line 2021: l_contact per_contact_relationships.contact_relationship_id%type;

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

Line 2025: FROM per_contact_relationships pcr,

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

Line 2038: FROM per_contact_relationships pcr,

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

Line 4553: FROM per_contact_relationships pcr,

4549: --
4550: cursor c_relationship(p_person_id number
4551: ,p_dpnt_person_id number)is
4552: SELECT hl.meaning
4553: FROM per_contact_relationships pcr,
4554: hr_lookups hl
4555: WHERE pcr.person_id = p_person_id
4556: AND pcr.contact_person_id = p_dpnt_person_id
4557: AND pcr.contact_type = hl.lookup_code

Line 4813: l_contact per_contact_relationships.contact_relationship_id%type;

4809: -- Local variable declarations
4810: --
4811: l_proc varchar2(72) := 'ben_ext_chlg.log_pcp_chg';
4812: l_relationship per_all_people_f.person_id%type;
4813: l_contact per_contact_relationships.contact_relationship_id%type;
4814: l_name per_all_people_f.full_name%type;
4815: --
4816: cursor c_relationship(p_person_id number) is
4817: SELECT pcr.contact_relationship_id,pcr.person_id,ppf.full_name

Line 4818: FROM per_contact_relationships pcr,

4814: l_name per_all_people_f.full_name%type;
4815: --
4816: cursor c_relationship(p_person_id number) is
4817: SELECT pcr.contact_relationship_id,pcr.person_id,ppf.full_name
4818: FROM per_contact_relationships pcr,
4819: per_all_people_f ppf,
4820: per_person_types ppt,
4821: hr_lookups hl
4822: WHERE pcr.contact_person_id = p_person_id

Line 4831: FROM per_contact_relationships pcr,

4827: AND hl.lookup_type = 'CONTACT';
4828:
4829: cursor c_con_relationship(p_person_id number) is
4830: SELECT pcr.contact_relationship_id,pcr.person_id,ppf.full_name
4831: FROM per_contact_relationships pcr,
4832: per_all_people_f ppf,
4833: hr_lookups hl
4834: WHERE pcr.contact_person_id = p_person_id
4835: AND ppf.person_id = p_person_id