DBA Data[Home] [Help]

APPS.PAY_SE_EXPIRY_SUPPORT dependencies on PER_ALL_ASSIGNMENTS_F

Line 183: FROM PER_ALL_ASSIGNMENTS_F ASG

179: ,HR_ORGANIZATION_INFORMATION hoi2
180: ,HR_ORGANIZATION_INFORMATION hoi3
181: ,HR_ORGANIZATION_INFORMATION hoi4
182: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
183: FROM PER_ALL_ASSIGNMENTS_F ASG
184: ,HR_SOFT_CODING_KEYFLEX SCL
185: WHERE ASG.ASSIGNMENT_ID = l_assignment_id
186: AND ASG.SOFT_CODING_KEYFLEX_ID = SCL.SOFT_CODING_KEYFLEX_ID
187: AND p_effective_date BETWEEN ASG.EFFECTIVE_START_DATE AND ASG.EFFECTIVE_END_DATE ) X