DBA Data[Home] [Help]

APPS.PAY_BF_BAL_UPLOAD dependencies on HR_ORGANIZATION_INFORMATION

Line 146: ,hr_organization_information HOI

142: to_char(fnd_date.canonical_to_date(HOI.org_information11),'DDD') +1,'Y')
143: - 1 + to_char(fnd_date.canonical_to_date(HOI.org_information11),'DDD'),
144: END_OF_TIME)
145: from per_assignments_f ASS
146: ,hr_organization_information HOI
147: where ASS.assignment_id = p_assignment_id
148: and p_upload_date between ASS.effective_start_date
149: and ASS.effective_end_date
150: and HOI.organization_id = ASS.business_group_id

Line 167: ,hr_organization_information HOI

163: to_char(fnd_date.canonical_to_date(HOI.org_informatioN11),'MM') - 1) +
164: to_char(fnd_date.canonical_to_date(HOI.org_information11),'DD') - 1,
165: END_OF_TIME)
166: from per_assignments_f ASS
167: ,hr_organization_information HOI
168: where ASS.assignment_id = p_assignment_id
169: and p_upload_date between ASS.effective_start_date
170: and ASS.effective_end_date
171: and HOI.organization_id = ASS.business_group_id