DBA Data[Home] [Help]

APPS.HR_CHANGE_START_DATE_API dependencies on PQP_ASSIGNMENT_ATTRIBUTES_F

Line 2062: from pqp_assignment_attributes_f paa

2058: -- Cursor to check for any updates in between old and new start dates.
2059: --
2060: cursor csr_extra_details IS
2061: select 'Y'
2062: from pqp_assignment_attributes_f paa
2063: ,per_assignments_f paf
2064: where paf.person_id = p_person_id
2065: and paa.assignment_id = paf.assignment_id
2066: and paf.effective_start_date = trunc(p_old_start_date)

Line 2972: update pqp_assignment_attributes_f paa

2968: hr_utility.set_location(l_proc, 220);
2969: --
2970: -- Fix for bug 3738058 starts here.
2971: --
2972: update pqp_assignment_attributes_f paa
2973: set paa.effective_start_date = l_new_start_date
2974: where paa.effective_start_date = l_old_start_date
2975: and paa.assignment_id in
2976: (select paf.assignment_id