DBA Data[Home] [Help]

APPS.PAY_DK_ABSENCE_USER dependencies on HR_ORGANIZATION_INFORMATION

Line 406: hr_organization_information hoi

402: CURSOR csr_asg_le IS SELECT
403: nvl(asg.normal_hours,hoi.org_information3) hours
404: ,nvl(asg.frequency,hoi.org_information4) frequency
405: FROM
406: hr_organization_information hoi
407: ,HR_SOFT_CODING_KEYFLEX SCL
408: ,PER_ALL_ASSIGNMENTS_F ASG
409: WHERE ASG.ASSIGNMENT_ID = p_assignment_id
410: AND hoi.organization_id = scl.segment1

Line 1115: hr_organization_information hoi

1111: fnd_number.canonical_to_number(nvl(asg.normal_hours,hoi.org_information3)) hours
1112: ,nvl(asg.frequency,hoi.org_information4) frequency
1113: ,segment10 work_pattern
1114: FROM
1115: hr_organization_information hoi
1116: ,HR_SOFT_CODING_KEYFLEX SCL
1117: ,PER_ALL_ASSIGNMENTS_F ASG
1118: WHERE ASG.ASSIGNMENT_ID = p_assignment_id
1119: AND hoi.organization_id = scl.segment1