APPS.PER_DIS_BUS dependencies on PER_ALL_PEOPLE_F

Line 792: ,p_business_group_id in per_all_people_f.business_group_id%TYPE

788: --
789: procedure chk_organization_id
790: (p_disability_id in per_disabilities_f.disability_id%TYPE
791: ,p_organization_id in per_disabilities_f.organization_id%TYPE
792: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
793: ,p_validation_start_date in per_disabilities_f.effective_start_date%TYPE
794: )
795: is
796: --

Line 1446: (p_base_table_name => 'per_all_people_f'

1442: );
1443: --
1444: If ((nvl(p_person_id, hr_api.g_number) <> hr_api.g_number) and
1445: NOT (dt_api.check_min_max_dates
1446: (p_base_table_name => 'per_all_people_f'
1447: ,p_base_key_column => 'PERSON_ID'
1448: ,p_base_key_value => p_person_id
1449: ,p_from_date => p_validation_start_date
1450: ,p_to_date => p_validation_end_date))) Then

Line 1596: from per_all_people_f pap

1592: ) is
1593: --
1594: cursor csr_person is
1595: select business_group_id
1596: from per_all_people_f pap
1597: where pap.person_id = p_rec.person_id
1598: and p_validation_start_date between pap.effective_start_date and pap.effective_end_date;
1599: --
1600: l_proc varchar2(72) := g_package||'insert_validate';

Line 1601: l_business_group_id per_all_people_f.business_group_id%TYPE;

1597: where pap.person_id = p_rec.person_id
1598: and p_validation_start_date between pap.effective_start_date and pap.effective_end_date;
1599: --
1600: l_proc varchar2(72) := g_package||'insert_validate';
1601: l_business_group_id per_all_people_f.business_group_id%TYPE;
1602: --
1603: --
1604: Begin
1605: hr_utility.set_location('Entering:'||l_proc, 5);

Line 1711: from per_all_people_f pap

1707: ) is
1708: --
1709: cursor csr_person is
1710: select business_group_id
1711: from per_all_people_f pap
1712: where pap.person_id = p_rec.person_id
1713: and p_validation_start_date between pap.effective_start_date and pap.effective_end_date;
1714: --
1715: l_business_group_id per_all_people_f.business_group_id%TYPE;

Line 1715: l_business_group_id per_all_people_f.business_group_id%TYPE;

1711: from per_all_people_f pap
1712: where pap.person_id = p_rec.person_id
1713: and p_validation_start_date between pap.effective_start_date and pap.effective_end_date;
1714: --
1715: l_business_group_id per_all_people_f.business_group_id%TYPE;
1716: l_proc varchar2(72) := g_package||'update_validate';
1717: --
1718: Begin
1719: hr_utility.set_location('Entering:'||l_proc, 5);