DBA Data[Home] [Help]

APPS.PAY_NO_ABSENCE dependencies on HR_SOFT_CODING_KEYFLEX

Line 581: ,HR_SOFT_CODING_KEYFLEX SCL

577: ,HR_ORGANIZATION_INFORMATION hoi3
578: ,HR_ORGANIZATION_INFORMATION hoi4
579: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
580: FROM PER_ALL_ASSIGNMENTS_F ASG
581: ,HR_SOFT_CODING_KEYFLEX SCL
582: WHERE ASG.ASSIGNMENT_ID = p_assignment_id
583: AND ASG.SOFT_CODING_KEYFLEX_ID = SCL.SOFT_CODING_KEYFLEX_ID
584: AND P_EFFECTIVE_DATE BETWEEN ASG.EFFECTIVE_START_DATE AND ASG.EFFECTIVE_END_DATE ) X
585: WHERE o1.business_group_id = p_business_group_id

Line 7793: ,HR_SOFT_CODING_KEYFLEX SCL

7789: ,HR_ORGANIZATION_INFORMATION hoi3
7790: ,HR_ORGANIZATION_INFORMATION hoi4
7791: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
7792: FROM PER_ALL_ASSIGNMENTS_F ASG
7793: ,HR_SOFT_CODING_KEYFLEX SCL
7794: WHERE ASG.ASSIGNMENT_ID = p_assignment_id
7795: AND ASG.SOFT_CODING_KEYFLEX_ID = SCL.SOFT_CODING_KEYFLEX_ID
7796: AND P_EFFECTIVE_DATE BETWEEN ASG.EFFECTIVE_START_DATE AND ASG.EFFECTIVE_END_DATE ) X
7797: WHERE o1.business_group_id = p_business_group_id