APPS.HR_CHANGE_START_DATE_API dependencies on PER_PAY_PROPOSALS

Line 1288: from per_pay_proposals

1284: ,p_type VARCHAR2) is
1285: cursor get_pay_proposal
1286: is
1287: select pay_proposal_id
1288: from per_pay_proposals
1289: where change_date = p_old_start_date
1290: and exists (select 1
1291: from per_assignments_f
1292: where person_id = p_person_id

Line 1293: and per_pay_proposals.assignment_id = per_assignments_f.assignment_id

1289: where change_date = p_old_start_date
1290: and exists (select 1
1291: from per_assignments_f
1292: where person_id = p_person_id
1293: and per_pay_proposals.assignment_id = per_assignments_f.assignment_id
1294: -- and primary_flag = 'Y'
1295: and effective_start_date = p_new_start_date
1296: and assignment_type = p_type);
1297: --

Line 1301: from per_pay_proposals

1297: --
1298: cursor prv_pay_proposals
1299: is
1300: select count(*)
1301: from per_pay_proposals
1302: where change_date <= p_new_start_date
1303: and assignment_id =
1304: (select assignment_id
1305: from per_assignments_f

Line 1351: update per_pay_proposals

1347: hr_utility.set_location('update_pay_proposal.p_person_id = '||p_person_id,40);
1348: hr_utility.set_location('update_pay_proposal.p_type = '||p_type,40);
1349: hr_utility.set_location('update_pay_proposal.pay_proposal_id = '||l_pay_proposal_id,40);
1350: --
1351: update per_pay_proposals
1352: set change_date = p_new_start_date
1353: where change_date = p_old_start_date
1354: and pay_proposal_id = l_pay_proposal_id;
1355: /* and assignment_id =