DBA Data[Home] [Help]

APPS.PAY_SE_EXPIRY_SUPPORT dependencies on HR_SOFT_CODING_KEYFLEX

Line 184: ,HR_SOFT_CODING_KEYFLEX SCL

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
188: WHERE o1.business_group_id = l_business_group_id