DBA Data[Home] [Help]

APPS.PER_PEOPLE4_PKG dependencies on PER_PAY_PROPOSALS

Line 135: from per_pay_proposals

131: --
132: cursor get_pay_proposal
133: is
134: select PAY_PROPOSAL_ID
135: from per_pay_proposals
136: where change_date = p_s_hire_date
137: and assignment_id = (select assignment_id
138: from per_assignments_f
139: where person_id = p_person_id

Line 726: update per_pay_proposals

722: if get_pay_proposal%FOUND
723: then
724: close get_pay_proposal;
725: begin
726: update per_pay_proposals
727: set change_date = p_hire_date
728: where change_date = p_s_hire_date
729: and assignment_id = (select assignment_id
730: from per_assignments_f