DBA Data[Home] [Help]

APPS.PER_US_VALIDATE_AEI dependencies on PER_ASSIGNMENTS_F

Line 61: per_assignments_f paf,

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