1197: l_proc varchar2(72) := g_package||'copy_offer_pay_to_appl_pay';
1198: --
1199: -- Out and In Out variables
1200: --
1201: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;
1202: l_pay_proposal_ovn per_pay_proposals.object_version_number%TYPE;
1203: l_inv_next_sal_date_warning boolean;
1204: l_proposed_salary_warning boolean;
1205: l_approved_warning boolean;
1198: --
1199: -- Out and In Out variables
1200: --
1201: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;
1202: l_pay_proposal_ovn per_pay_proposals.object_version_number%TYPE;
1203: l_inv_next_sal_date_warning boolean;
1204: l_proposed_salary_warning boolean;
1205: l_approved_warning boolean;
1206: l_payroll_warning boolean;
1219: --
1220: cursor csr_appl_pay_proposal is
1221: select pay_proposal_id
1222: ,object_version_number
1223: from per_pay_proposals
1224: where assignment_id = l_applicant_assignment_id
1225: and approved = 'N';
1226: --
1227: cursor csr_pay_proposal_record(p_assignment_id per_pay_proposals.assignment_id%TYPE) is
1223: from per_pay_proposals
1224: where assignment_id = l_applicant_assignment_id
1225: and approved = 'N';
1226: --
1227: cursor csr_pay_proposal_record(p_assignment_id per_pay_proposals.assignment_id%TYPE) is
1228: select
1229: pay_proposal_id
1230: ,assignment_id
1231: ,event_id
1270: ,multiple_components
1271: ,forced_ranking
1272: ,performance_review_id
1273: ,proposed_salary_n
1274: from per_pay_proposals
1275: where assignment_id = p_assignment_id
1276: and approved = 'N';
1277:
1278: l_pay_proposal_record csr_pay_proposal_record%ROWTYPE;