APPS.PAY_SE_EXPIRY_SUPPORT dependencies on HR_SOFT_CODING_KEYFLEX
Line 198: ,HR_SOFT_CODING_KEYFLEX SCL
194: ,HR_ORGANIZATION_INFORMATION hoi3
195: ,HR_ORGANIZATION_INFORMATION hoi4
196: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
197: FROM PER_ALL_ASSIGNMENTS_F ASG 198: ,HR_SOFT_CODING_KEYFLEX SCL 199: WHERE ASG.ASSIGNMENT_ID = l_assignment_id
200: AND ASG.SOFT_CODING_KEYFLEX_ID = SCL.SOFT_CODING_KEYFLEX_ID
201: AND p_effective_date BETWEEN ASG.EFFECTIVE_START_DATE AND ASG.EFFECTIVE_END_DATE ) X
202: WHERE o1.business_group_id = l_business_group_id