DBA Data[Home] [Help]

APPS.PAY_DK_ABSENCE_USER dependencies on HR_ORGANIZATION_INFORMATION

Line 372: hr_organization_information hoi

368: CURSOR csr_asg_le IS SELECT
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

Line 1077: hr_organization_information hoi

1073: fnd_number.canonical_to_number(nvl(asg.normal_hours,hoi.org_information3)) hours
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