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 1594: (p_base_table_name => 'per_people_f',

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