DBA Data[Home] [Help]

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