DBA Data[Home] [Help]

APPS.PAY_KR_BAL_UPLOAD dependencies on HR_ORGANIZATION_INFORMATION

Line 64: from hr_organization_information hoi,

60: select nvl(add_months(fnd_date.canonical_to_date(org_information11),
61: (floor(floor(months_between(p_upload_date,
62: fnd_date.canonical_to_date(org_information11)))/12)*12)),
63: g_eot)
64: from hr_organization_information hoi,
65: per_assignments_f pa
66: where pa.assignment_id = p_assignment_id
67: and p_upload_date
68: between pa.effective_start_date and pa.effective_end_date