APPS.PER_EVT_BUS dependencies on PER_ALL_PEOPLE_F

Line 662: l_business_group_id per_all_people_f.business_group_id%type;

658: is
659: --
660: l_proc varchar2(72) := g_package||'chk_internal_contact_person_id';
661: --
662: l_business_group_id per_all_people_f.business_group_id%type;
663: --
664: cursor csr_valid_pers is
665: select ppf.business_group_id
666: from per_all_people_f ppf

Line 666: from per_all_people_f ppf

662: l_business_group_id per_all_people_f.business_group_id%type;
663: --
664: cursor csr_valid_pers is
665: select ppf.business_group_id
666: from per_all_people_f ppf
667: where ppf.person_id = p_internal_contact_person_id
668: and p_date_start between
669: ppf.effective_start_date and ppf.effective_end_date
670: and (ppf.current_employee_flag = 'Y'

Line 982: -- per_all_people_f

978: --
979: --
980: -- Description:
981: -- - Validates that the person_id and the party_id are matched in
982: -- per_all_people_f
983: -- and if person_id is not null and party_id is null, derive party_id
984: -- from per_all_people_f from person_id
985: --
986: -- Pre_conditions:

Line 984: -- from per_all_people_f from person_id

980: -- Description:
981: -- - Validates that the person_id and the party_id are matched in
982: -- per_all_people_f
983: -- and if person_id is not null and party_id is null, derive party_id
984: -- from per_all_people_f from person_id
985: --
986: -- Pre_conditions:
987: -- A valid business_group_id
988: --

Line 1017: from per_all_people_f per

1013: -- cursor to get party_id
1014: --
1015: cursor csr_get_party_id is
1016: select max(per.party_id)
1017: from per_all_people_f per
1018: where per.person_id =
1019: (select asg.person_id from per_all_assignments_f asg
1020: where asg.assignment_id = p_rec.assignment_id
1021: and p_rec.date_start

Line 1050: -- derive party_id from per_all_people_f using assignment_id

1046: open csr_get_party_id;
1047: fetch csr_get_party_id into l_party_id;
1048: close csr_get_party_id;
1049: --
1050: -- derive party_id from per_all_people_f using assignment_id
1051: --
1052: hr_utility.set_location(l_proc,30);
1053: p_rec.party_id := l_party_id;
1054: end if;