DBA Data[Home] [Help]

APPS.HR_CHANGE_START_DATE_API dependencies on PQP_ASSIGNMENT_ATTRIBUTES_F

Line 1624: from pqp_assignment_attributes_f paa

1620: -- Cursor to check for any updates in between old and new start dates.
1621: --
1622: cursor csr_extra_details IS
1623: select 'Y'
1624: from pqp_assignment_attributes_f paa
1625: ,per_assignments_f paf
1626: where paf.person_id = p_person_id
1627: and paa.assignment_id = paf.assignment_id
1628: and paf.effective_start_date = trunc(p_old_start_date)

Line 2490: update pqp_assignment_attributes_f paa

2486: hr_utility.set_location(l_proc, 220);
2487: --
2488: -- Fix for bug 3738058 starts here.
2489: --
2490: update pqp_assignment_attributes_f paa
2491: set paa.effective_start_date = l_new_start_date
2492: where paa.effective_start_date = l_old_start_date
2493: and paa.assignment_id in
2494: (select paf.assignment_id