APPS.PER_SSHR_CHANGE_PAY dependencies on PER_PAY_PROPOSAL_COMPONENTS

Line 1536: from per_pay_proposal_components

1532: attribute19 ,
1533: attribute20 ,
1534: change_amount_n ,
1535: object_version_number
1536: from per_pay_proposal_components
1537: where PAY_PROPOSAL_ID = c_parent_proposal_id;
1538:
1539:
1540: --

Line 3177: l_component_id per_pay_proposal_components.component_id%type;

3173: --
3174: --
3175: l_pay_proposal_id per_pay_proposals.pay_proposal_id%type;
3176: l_pay_ovn per_pay_proposals.object_version_number%type;
3177: l_component_id per_pay_proposal_components.component_id%type;
3178: l_comp_ovn per_pay_proposal_components.object_version_number%type;
3179: l_change_date per_pay_proposals.change_date%type;
3180: l_element_entry_id pay_element_entries_f.element_entry_id%type;
3181: l_inv_next_sal_date_warning boolean;

Line 3178: l_comp_ovn per_pay_proposal_components.object_version_number%type;

3174: --
3175: l_pay_proposal_id per_pay_proposals.pay_proposal_id%type;
3176: l_pay_ovn per_pay_proposals.object_version_number%type;
3177: l_component_id per_pay_proposal_components.component_id%type;
3178: l_comp_ovn per_pay_proposal_components.object_version_number%type;
3179: l_change_date per_pay_proposals.change_date%type;
3180: l_element_entry_id pay_element_entries_f.element_entry_id%type;
3181: l_inv_next_sal_date_warning boolean;
3182: l_proposed_salary_warning boolean;

Line 3357: l_component_id per_pay_proposal_components.component_id%type;

3353: order by PARENT_PAY_TRANSACTION_ID;
3354: --
3355: l_pay_proposal_id per_pay_proposals.pay_proposal_id%type;
3356: l_pay_ovn per_pay_proposals.object_version_number%type;
3357: l_component_id per_pay_proposal_components.component_id%type;
3358: l_comp_ovn per_pay_proposal_components.object_version_number%type;
3359: l_element_entry_id pay_element_entries_f.element_entry_id%type;
3360: l_inv_next_sal_date_warning boolean;
3361: l_proposed_salary_warning boolean;

Line 3358: l_comp_ovn per_pay_proposal_components.object_version_number%type;

3354: --
3355: l_pay_proposal_id per_pay_proposals.pay_proposal_id%type;
3356: l_pay_ovn per_pay_proposals.object_version_number%type;
3357: l_component_id per_pay_proposal_components.component_id%type;
3358: l_comp_ovn per_pay_proposal_components.object_version_number%type;
3359: l_element_entry_id pay_element_entries_f.element_entry_id%type;
3360: l_inv_next_sal_date_warning boolean;
3361: l_proposed_salary_warning boolean;
3362: l_approved_warning boolean;

Line 3428: from per_pay_proposal_components where component_id = l_comp_rec.component_id;

3424: For l_comp_rec in csr_update_comp loop
3425: --
3426: --start of code change for bug 12328478
3427: Select object_version_number into l_comp_ovn
3428: from per_pay_proposal_components where component_id = l_comp_rec.component_id;
3429: --end of code change for bug 12328478
3430:
3431: hr_maintain_proposal_api.update_proposal_component(
3432: --

Line 3496: l_comp_ovn per_pay_proposal_components.object_version_number%type;

3492: and PARENT_PAY_TRANSACTION_ID is not null
3493: order by PARENT_PAY_TRANSACTION_ID;
3494: --
3495: l_pay_ovn per_pay_proposals.object_version_number%type;
3496: l_comp_ovn per_pay_proposal_components.object_version_number%type;
3497: l_salary_warning boolean;
3498: l_proc varchar2(61) := 'process_delete_pay_action' ;
3499: --
3500: Begin

Line 3507: From per_pay_proposal_components where component_id = l_comp_rec.component_id;

3503: --
3504: For l_comp_rec in csr_delete_comp loop
3505: --
3506: Select object_version_number into l_comp_ovn
3507: From per_pay_proposal_components where component_id = l_comp_rec.component_id;
3508: --
3509: hr_maintain_proposal_api.delete_proposal_component(
3510: p_component_id => l_comp_rec.component_id,
3511: p_validation_strength => 'STRONG',