DBA Data[Home] [Help]

APPS.PER_CTC_BUS dependencies on PER_PEOPLE_F

Line 130: from per_people_f ppf

126: l_proc varchar2(72) := g_package||'chk_person_id';
127: --
128: cursor csr_get_bus_grp is
129: select ppf.business_group_id
130: from per_people_f ppf
131: where ppf.person_id = p_person_id
132: and p_effective_date between ppf.effective_start_date
133: and ppf.effective_end_date;
134: --

Line 1591: (p_base_table_name => 'per_people_f',

1587: p_argument_value => p_validation_end_date);
1588: --
1589: If ((nvl(p_person_id, hr_api.g_number) <> hr_api.g_number) and
1590: NOT (dt_api.check_min_max_dates
1591: (p_base_table_name => 'per_people_f',
1592: p_base_key_column => 'person_id',
1593: p_base_key_value => p_person_id,
1594: p_from_date => p_validation_start_date,
1595: p_to_date => p_validation_end_date))) Then