APPS.PER_CEL_BUS dependencies on PER_ALL_PEOPLE_F

Line 2048: -- per_all_people_f

2044: -- ----------------------------------------------------------------------------
2045: --
2046: -- Description:
2047: -- - Validates that the person_id and the party_id are matched in
2048: -- per_all_people_f
2049: -- and if person_id is not null and party_id is null, derive party_id
2050: -- from per_all_people_f from person_id
2051: --
2052: -- Pre_conditions:

Line 2050: -- from per_all_people_f from person_id

2046: -- Description:
2047: -- - Validates that the person_id and the party_id are matched in
2048: -- per_all_people_f
2049: -- and if person_id is not null and party_id is null, derive party_id
2050: -- from per_all_people_f from person_id
2051: --
2052: -- Pre_conditions:
2053: -- A valid business_group_id
2054: --

Line 2084: from per_all_people_f per

2080: -- cursor to check that the party_id maches person_id
2081: --
2082: cursor csr_get_party_id is
2083: select party_id
2084: from per_all_people_f per
2085: where per.person_id = p_rec.person_id
2086: and p_effective_date
2087: between per.effective_start_date
2088: and nvl(per.effective_end_date,hr_api.g_eot);

Line 2119: -- derive party_id from per_all_people_f using person_id

2115: end if;
2116: --
2117: else -- if party_id is null
2118: --
2119: -- derive party_id from per_all_people_f using person_id
2120: --
2121: hr_utility.set_location(l_proc,50);
2122: p_rec.party_id := l_party_id;
2123: end if;