DBA Data[Home] [Help]

APPS.PER_PEOPLE4_PKG dependencies on PER_PAY_PROPOSALS

Line 139: from per_pay_proposals

135: --
136: cursor get_pay_proposal
137: is
138: select PAY_PROPOSAL_ID
139: from per_pay_proposals
140: where change_date = p_s_hire_date
141: and assignment_id = (select assignment_id
142: from per_assignments_f
143: where person_id = p_person_id

Line 814: update per_pay_proposals

810: IF g_debug THEN
811: hr_utility.set_location(g_package || l_proc, 260);
812: END IF;
813:
814: update per_pay_proposals
815: set change_date = p_hire_date
816: where change_date = p_s_hire_date
817: and assignment_id = (select assignment_id
818: from per_assignments_f