DBA Data[Home] [Help]

APPS.PAY_US_BAL_UPLOAD dependencies on HR_ORGANIZATION_INFORMATION

Line 191: ,hr_organization_information HOI

187: to_char(fnd_date.canonical_to_date(HOI.org_information11),'DDD') +1,'Y')
188: - 1 + to_char(fnd_date.canonical_to_date(HOI.org_information11),'DDD'),
189: END_OF_TIME)
190: from per_assignments_f ASS
191: ,hr_organization_information HOI
192: where ASS.assignment_id = p_assignment_id
193: and p_upload_date between ASS.effective_start_date
194: and ASS.effective_end_date
195: and HOI.organization_id = ASS.business_group_id

Line 212: ,hr_organization_information HOI

208: to_char(fnd_date.canonical_to_date(HOI.org_informatioN11),'MM') - 1) +
209: to_char(fnd_date.canonical_to_date(HOI.org_information11),'DD') - 1,
210: END_OF_TIME)
211: from per_assignments_f ASS
212: ,hr_organization_information HOI
213: where ASS.assignment_id = p_assignment_id
214: and p_upload_date between ASS.effective_start_date
215: and ASS.effective_end_date
216: and HOI.organization_id = ASS.business_group_id