DBA Data[Home] [Help]

APPS.PER_APL_BUS dependencies on PER_PERSON_TYPES

Line 416: l_system_person_type per_person_types.system_person_type%TYPE;

412: ) is
413: --
414: l_proc varchar2(72) := g_package||'chk_person_id';
415: l_business_group_id per_applications.business_group_id%TYPE;
416: l_system_person_type per_person_types.system_person_type%TYPE;
417: l_api_updating boolean;
418: l_application_id per_applications.application_id%TYPE;
419: --
420: --

Line 429: per_person_types typ

425: cursor csr_valid_person_per_people_f is
426: select per.business_group_id,
427: typ.system_person_type
428: from per_all_people_f per,
429: per_person_types typ
430: where per.person_id = p_person_id
431: and per.person_type_id = typ.person_type_id
432: and per.effective_start_date = p_date_received;
433: --