DBA Data[Home] [Help]

APPS.PER_CTR_BUS dependencies on PER_PEOPLE_F

Line 51: -- Validates that the person ID exists in PER_PEOPLE_F.

47: -- |--------------------------< chk_person_id >------------------------------|
48: -- ---------------------------------------------------------------------------
49: --
50: -- Description:
51: -- Validates that the person ID exists in PER_PEOPLE_F.
52: --
53: -- Pre-Requisites:
54: -- None.
55: --

Line 134: -- Validates that the contact_person ID exists in PER_PEOPLE_F.

130: -- |--------------------------< chk_contact_person_id >------------------------------|
131: -- ---------------------------------------------------------------------------
132: --
133: -- Description:
134: -- Validates that the contact_person ID exists in PER_PEOPLE_F.
135: --
136: -- Pre-Requisites:
137: -- None.
138: --

Line 850: from per_people_f ppf

846: l_proc varchar2(72) := g_package||'chk_date_of_birth';
847: --
848: cursor csr_get_date_of_birth( l_person_id number ) is
849: select date_of_birth
850: from per_people_f ppf
851: where ppf.person_id = l_person_id;
852: --
853: l_contact_date_of_birth date;
854: l_person_date_of_birth date;