APPS.PER_MEA_BUS dependencies on PER_ALL_PEOPLE_F

Line 210: -- it exists in per_all_people_f on the effective_date.

206: --
207: -- Desciption :
208: --
209: -- Validate that on insert PERSON_ID is not null and that
210: -- it exists in per_all_people_f on the effective_date.
211: --
212: --
213: -- Pre-conditions :
214: --

Line 327: ,p_business_group_id IN per_all_people_f.business_group_id%TYPE

323: --
324: PROCEDURE chk_organization_id
325: (p_medical_assessment_id IN per_medical_assessments.disability_id%TYPE
326: ,p_organization_id IN per_medical_assessments.organization_id%TYPE
327: ,p_business_group_id IN per_all_people_f.business_group_id%TYPE
328: ,p_effective_date IN date) IS
329: --
330: cursor csr_org is
331: select business_group_id

Line 1669: FROM per_all_people_f pap

1665: -- Declare cursors
1666: --
1667: CURSOR csr_business_group is
1668: SELECT business_group_id
1669: FROM per_all_people_f pap
1670: WHERE pap.person_id = p_rec.person_id
1671: AND p_effective_date BETWEEN pap.effective_start_date AND pap.effective_end_date;
1672: --
1673: -- Declare local variables

Line 1676: l_business_group_id per_all_people_f.business_group_id%TYPE;

1672: --
1673: -- Declare local variables
1674: --
1675: l_proc VARCHAR2(72) := g_package||'insert_validate';
1676: l_business_group_id per_all_people_f.business_group_id%TYPE;
1677: --
1678: BEGIN
1679: --
1680: hr_utility.set_location('Entering:'||l_proc, 10);

Line 1839: FROM per_all_people_f pap

1835: -- Declare cursors
1836: --
1837: CURSOR csr_business_group is
1838: SELECT business_group_id
1839: FROM per_all_people_f pap
1840: WHERE pap.person_id = p_rec.person_id
1841: AND p_effective_date BETWEEN pap.effective_start_date AND pap.effective_end_date;
1842: --
1843: -- Declare local variables

Line 1846: l_business_group_id per_all_people_f.business_group_id%TYPE;

1842: --
1843: -- Declare local variables
1844: --
1845: l_proc VARCHAR2(72) := g_package||'update_validate';
1846: l_business_group_id per_all_people_f.business_group_id%TYPE;
1847: --
1848: BEGIN
1849: --
1850: hr_utility.set_location('Entering:'||l_proc, 10);