DBA Data[Home] [Help]

APPS.PER_PEOPLE12_PKG dependencies on PER_PAY_PROPOSALS

Line 563: from per_pay_proposals

559:
560: cursor get_pay_proposal
561: is
562: select PAY_PROPOSAL_ID
563: from per_pay_proposals
564: where change_date = p_s_hire_date
565: and assignment_id = (select assignment_id
566: from per_assignments_f
567: where person_id = p_person_id

Line 1681: -- update per_pay_proposals

1677: -- if get_pay_proposal%FOUND
1678: -- then
1679: -- close get_pay_proposal;
1680: -- begin
1681: -- update per_pay_proposals
1682: -- set change_date = p_hire_date
1683: -- where change_date = p_s_hire_date
1684: -- and assignment_id = (select assignment_id
1685: -- from per_assignments_f