DBA Data[Home] [Help]

APPS.PAY_DK_ABSENCE_USER dependencies on HR_SOFT_CODING_KEYFLEX

Line 373: ,HR_SOFT_CODING_KEYFLEX SCL

369: nvl(asg.normal_hours,hoi.org_information3) hours
370: ,nvl(asg.frequency,hoi.org_information4) frequency
371: FROM
372: hr_organization_information hoi
373: ,HR_SOFT_CODING_KEYFLEX SCL
374: ,PER_ALL_ASSIGNMENTS_F ASG
375: WHERE ASG.ASSIGNMENT_ID = p_assignment_id
376: AND hoi.organization_id = scl.segment1
377: AND org_information_context = 'DK_EMPLOYMENT_DEFAULTS'

Line 1078: ,HR_SOFT_CODING_KEYFLEX SCL

1074: ,nvl(asg.frequency,hoi.org_information4) frequency
1075: ,segment10 work_pattern
1076: FROM
1077: hr_organization_information hoi
1078: ,HR_SOFT_CODING_KEYFLEX SCL
1079: ,PER_ALL_ASSIGNMENTS_F ASG
1080: WHERE ASG.ASSIGNMENT_ID = p_assignment_id
1081: AND hoi.organization_id = scl.segment1
1082: AND org_information_context = 'DK_EMPLOYMENT_DEFAULTS'