DBA Data[Home] [Help]

APPS.PAY_NO_ABSENCE dependencies on HR_SOFT_CODING_KEYFLEX

Line 554: ,HR_SOFT_CODING_KEYFLEX SCL

550: ,HR_ORGANIZATION_INFORMATION hoi3
551: ,HR_ORGANIZATION_INFORMATION hoi4
552: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
553: FROM PER_ALL_ASSIGNMENTS_F ASG
554: ,HR_SOFT_CODING_KEYFLEX SCL
555: WHERE ASG.ASSIGNMENT_ID = p_assignment_id
556: AND ASG.SOFT_CODING_KEYFLEX_ID = SCL.SOFT_CODING_KEYFLEX_ID
557: AND P_EFFECTIVE_DATE BETWEEN ASG.EFFECTIVE_START_DATE AND ASG.EFFECTIVE_END_DATE ) X
558: WHERE o1.business_group_id = p_business_group_id

Line 7688: ,HR_SOFT_CODING_KEYFLEX SCL

7684: ,HR_ORGANIZATION_INFORMATION hoi3
7685: ,HR_ORGANIZATION_INFORMATION hoi4
7686: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
7687: FROM PER_ALL_ASSIGNMENTS_F ASG
7688: ,HR_SOFT_CODING_KEYFLEX SCL
7689: WHERE ASG.ASSIGNMENT_ID = p_assignment_id
7690: AND ASG.SOFT_CODING_KEYFLEX_ID = SCL.SOFT_CODING_KEYFLEX_ID
7691: AND P_EFFECTIVE_DATE BETWEEN ASG.EFFECTIVE_START_DATE AND ASG.EFFECTIVE_END_DATE ) X
7692: WHERE o1.business_group_id = p_business_group_id