DBA Data[Home] [Help]

APPS.PAY_HK_BAL_UPLOAD dependencies on HR_ORGANIZATION_INFORMATION

Line 79: ,hr_organization_information HOI

75: 12*(floor(months_between(p_upload_date,
76: fnd_date.canonical_to_date(HOI.ORG_INFORMATION11))/12))),
77: END_OF_TIME)
78: from per_assignments_f ASS
79: ,hr_organization_information HOI
80: where ASS.assignment_id = p_assignment_id
81: and p_upload_date between ASS.effective_start_date
82: and ASS.effective_end_date
83: and HOI.organization_id = ASS.business_group_id

Line 114: ,hr_organization_information HOI

110: 3*(floor(months_between(p_upload_date,
111: fnd_date.canonical_to_date(HOI.ORG_INFORMATION11))/3))),
112: END_OF_TIME)
113: from per_assignments_f ASS
114: ,hr_organization_information HOI
115: where ASS.assignment_id = p_assignment_id
116: and p_upload_date between ASS.effective_start_date
117: and ASS.effective_end_date
118: and HOI.organization_id = ASS.business_group_id