DBA Data[Home] [Help]

APPS.PAY_SE_ABSENCE_USER dependencies on HR_SOFT_CODING_KEYFLEX

Line 475: ,HR_SOFT_CODING_KEYFLEX SCL

471: ,HR_ORGANIZATION_INFORMATION hoi3
472: ,HR_ORGANIZATION_INFORMATION hoi4
473: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
474: FROM PER_ALL_ASSIGNMENTS_F ASG
475: ,HR_SOFT_CODING_KEYFLEX SCL
476: WHERE ASG.ASSIGNMENT_ID = p_assignment_id
477: AND ASG.SOFT_CODING_KEYFLEX_ID = SCL.SOFT_CODING_KEYFLEX_ID
478: AND p_date_earned BETWEEN ASG.EFFECTIVE_START_DATE AND ASG.EFFECTIVE_END_DATE ) X
479: WHERE o1.business_group_id = l_business_group_id

Line 666: ,HR_SOFT_CODING_KEYFLEX SCL

662: ,HR_ORGANIZATION_INFORMATION hoi3
663: ,HR_ORGANIZATION_INFORMATION hoi4
664: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
665: FROM PER_ALL_ASSIGNMENTS_F ASG
666: ,HR_SOFT_CODING_KEYFLEX SCL
667: WHERE ASG.ASSIGNMENT_ID = csr_v_assignment_id
668: AND ASG.SOFT_CODING_KEYFLEX_ID = SCL.SOFT_CODING_KEYFLEX_ID
669: AND csr_v_effective_date BETWEEN ASG.EFFECTIVE_START_DATE AND ASG.EFFECTIVE_END_DATE ) X
670: WHERE o1.business_group_id = csr_v_business_group_id