DBA Data[Home] [Help]

APPS.PER_US_VALIDATE_AEI dependencies on HR_ORGANIZATION_INFORMATION

Line 60: FROM hr_organization_information orgi,

56: CURSOR c2 (p_assignment_id number,
57: p_aei_information1 varchar2,
58: p_aei_information3 varchar2) is
59: SELECT count(*) ct
60: FROM hr_organization_information orgi,
61: per_assignments_f paf,
62: hr_soft_coding_keyflex sft
63: WHERE orgi.organization_id = to_number(sft.segment1)
64: AND sft.soft_coding_keyflex_id = paf.soft_coding_keyflex_id