DBA Data[Home] [Help]

APPS.PER_PEOPLE12_PKG dependencies on PER_PAY_PROPOSALS

Line 237: from per_pay_proposals

233:
234: cursor get_pay_proposal
235: is
236: select PAY_PROPOSAL_ID
237: from per_pay_proposals
238: where change_date = p_s_hire_date
239: and assignment_id = (select assignment_id
240: from per_assignments_f
241: where person_id = p_person_id

Line 1958: -- update per_pay_proposals

1954: -- if get_pay_proposal%FOUND
1955: -- then
1956: -- close get_pay_proposal;
1957: -- begin
1958: -- update per_pay_proposals
1959: -- set change_date = p_hire_date
1960: -- where change_date = p_s_hire_date
1961: -- and assignment_id = (select assignment_id
1962: -- from per_assignments_f

Line 2577: from per_pay_proposals

2573:
2574: cursor get_pay_proposal
2575: is
2576: select PAY_PROPOSAL_ID
2577: from per_pay_proposals
2578: where change_date = p_s_hire_date
2579: and assignment_id = (select assignment_id
2580: from per_assignments_f
2581: where person_id = p_person_id

Line 3963: -- update per_pay_proposals

3959: -- if get_pay_proposal%FOUND
3960: -- then
3961: -- close get_pay_proposal;
3962: -- begin
3963: -- update per_pay_proposals
3964: -- set change_date = p_hire_date
3965: -- where change_date = p_s_hire_date
3966: -- and assignment_id = (select assignment_id
3967: -- from per_assignments_f