DBA Data[Home] [Help]

APPS.PER_ADDRESSES_PKG dependencies on PER_ALL_PEOPLE_F

Line 344: from per_all_people_f

340: -- rpinjala
341: --
342: cursor csr_get_party_id is
343: select max(party_id)
344: from per_all_people_f
345: where person_id = p_person_id;
346:
347: --
348: /* Need to check that US payroll is installed */

Line 1512: from per_all_people_f p, per_person_types t

1508: ));
1509: --
1510: cursor check_other_person_type is
1511: select 'Y'
1512: from per_all_people_f p, per_person_types t
1513: where p.person_id = p_person_id
1514: and p.person_type_id = t.person_type_id
1515: and t.system_person_type = 'OTHER';
1516: --