APPS.PER_DIS_BUS dependencies on PER_PEOPLE_F

Line 30: , per_people_f per

26: cursor csr_sec_grp is
27: select pbg.security_group_id
28: from per_business_groups pbg
29: , per_disabilities_f dis
30: , per_people_f per
31: where dis.disability_id = p_disability_id
32: and dis.person_id = per.person_id
33: and pbg.business_group_id = per.business_group_id;
34: --

Line 92: , per_people_f per

88: cursor csr_leg_code is
89: select pbg.legislation_code
90: from per_business_groups pbg
91: , per_disabilities_f dis
92: , per_people_f per
93: where dis.disability_id = p_disability_id
94: and dis.person_id = per.person_id
95: and pbg.business_group_id = per.business_group_id;
96: --

Line 159: -- it exists in per_people_f on the effective_date.

155: --
156: -- Desciption :
157: --
158: -- Validate that PERSON_ID is not null and that
159: -- it exists in per_people_f on the effective_date.
160: -- (Insert only - non updateable)
161: --
162: -- Pre-conditions :
163: --

Line 190: from per_people_f ppf

186: is
187: --
188: cursor csr_person is
189: select null
190: from per_people_f ppf
191: where ppf.person_id = p_person_id
192: and p_effective_date between ppf.effective_start_date
193: and ppf.effective_end_date;
194: --