DBA Data[Home] [Help]

APPS.PER_CAGR_UTILITY_PKG dependencies on HR_GENERAL

Line 1104: and nvl(effective_end_date,hr_general.end_of_time);

1100: select collective_agreement_id
1101: from per_all_assignments_f
1102: where assignment_id = p_assignment_id
1103: and p_effective_date between effective_start_date
1104: and nvl(effective_end_date,hr_general.end_of_time);
1105:
1106: l_id per_all_assignments_f.collective_agreement_id%TYPE;
1107: BEGIN
1108: