DBA Data[Home] [Help]

APPS.PER_US_VALIDATE_AEI dependencies on HR_SOFT_CODING_KEYFLEX

Line 62: hr_soft_coding_keyflex sft

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
65: AND paf.assignment_id = p_assignment_id
66: AND orgi.org_information1 = p_aei_information1