APPS.IRC_OFFERS_API dependencies on PER_PAY_PROPOSALS

Line 1132: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;

1128: l_proc varchar2(72) := g_package||'copy_offer_pay_to_appl_pay';
1129: --
1130: -- Out and In Out variables
1131: --
1132: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;
1133: l_pay_proposal_ovn per_pay_proposals.object_version_number%TYPE;
1134: l_inv_next_sal_date_warning boolean;
1135: l_proposed_salary_warning boolean;
1136: l_approved_warning boolean;

Line 1133: l_pay_proposal_ovn per_pay_proposals.object_version_number%TYPE;

1129: --
1130: -- Out and In Out variables
1131: --
1132: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;
1133: l_pay_proposal_ovn per_pay_proposals.object_version_number%TYPE;
1134: l_inv_next_sal_date_warning boolean;
1135: l_proposed_salary_warning boolean;
1136: l_approved_warning boolean;
1137: l_payroll_warning boolean;

Line 1153: from per_pay_proposals

1149: --
1150: cursor csr_appl_pay_proposal is
1151: select pay_proposal_id
1152: ,object_version_number
1153: from per_pay_proposals
1154: where assignment_id = l_applicant_assignment_id
1155: and approved = 'N';
1156: --
1157: cursor csr_pay_proposal_record is

Line 1204: from per_pay_proposals

1200: ,multiple_components
1201: ,forced_ranking
1202: ,performance_review_id
1203: ,proposed_salary_n
1204: from per_pay_proposals
1205: where assignment_id = l_offer_assignment_id
1206: and approved = 'N';
1207:
1208: l_pay_proposal_record csr_pay_proposal_record%ROWTYPE;