DBA Data[Home] [Help]

APPS.PAY_SG_BAL_UPLOAD dependencies on HR_ORGANIZATION_INFORMATION

Line 91: ,hr_organization_information HOI

87: 12*(floor(months_between(p_upload_date,
88: fnd_date.canonical_to_date(HOI.ORG_INFORMATION11))/12))),
89: END_OF_TIME)
90: from per_assignments_f ASS
91: ,hr_organization_information HOI
92: where ASS.assignment_id = p_assignment_id
93: and p_upload_date between ASS.effective_start_date
94: and ASS.effective_end_date
95: and HOI.organization_id = ASS.business_group_id

Line 110: ,hr_organization_information HOI

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