eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_SSHR_CHANGE_PAY dependencies on PER_PAY_PROPOSAL_COMPONENTS

Line 1524: from per_pay_proposal_components

1520: attribute19 ,
1521: attribute20 ,
1522: change_amount_n ,
1523: object_version_number
1524: from per_pay_proposal_components
1525: where PAY_PROPOSAL_ID = c_parent_proposal_id;
1526:
1527:
1528: --

Line 3152: l_component_id per_pay_proposal_components.component_id%type;

3148: --
3149: --
3150: l_pay_proposal_id per_pay_proposals.pay_proposal_id%type;
3151: l_pay_ovn per_pay_proposals.object_version_number%type;
3152: l_component_id per_pay_proposal_components.component_id%type;
3153: l_comp_ovn per_pay_proposal_components.object_version_number%type;
3154: l_change_date per_pay_proposals.change_date%type;
3155: l_element_entry_id pay_element_entries_f.element_entry_id%type;
3156: l_inv_next_sal_date_warning boolean;

Line 3153: l_comp_ovn per_pay_proposal_components.object_version_number%type;

3149: --
3150: l_pay_proposal_id per_pay_proposals.pay_proposal_id%type;
3151: l_pay_ovn per_pay_proposals.object_version_number%type;
3152: l_component_id per_pay_proposal_components.component_id%type;
3153: l_comp_ovn per_pay_proposal_components.object_version_number%type;
3154: l_change_date per_pay_proposals.change_date%type;
3155: l_element_entry_id pay_element_entries_f.element_entry_id%type;
3156: l_inv_next_sal_date_warning boolean;
3157: l_proposed_salary_warning boolean;

Line 3343: l_component_id per_pay_proposal_components.component_id%type;

3339: order by PARENT_PAY_TRANSACTION_ID;
3340: --
3341: l_pay_proposal_id per_pay_proposals.pay_proposal_id%type;
3342: l_pay_ovn per_pay_proposals.object_version_number%type;
3343: l_component_id per_pay_proposal_components.component_id%type;
3344: l_comp_ovn per_pay_proposal_components.object_version_number%type;
3345: l_element_entry_id pay_element_entries_f.element_entry_id%type;
3346: l_inv_next_sal_date_warning boolean;
3347: l_proposed_salary_warning boolean;

Line 3344: l_comp_ovn per_pay_proposal_components.object_version_number%type;

3340: --
3341: l_pay_proposal_id per_pay_proposals.pay_proposal_id%type;
3342: l_pay_ovn per_pay_proposals.object_version_number%type;
3343: l_component_id per_pay_proposal_components.component_id%type;
3344: l_comp_ovn per_pay_proposal_components.object_version_number%type;
3345: l_element_entry_id pay_element_entries_f.element_entry_id%type;
3346: l_inv_next_sal_date_warning boolean;
3347: l_proposed_salary_warning boolean;
3348: l_approved_warning boolean;

Line 3477: l_comp_ovn per_pay_proposal_components.object_version_number%type;

3473: and PARENT_PAY_TRANSACTION_ID is not null
3474: order by PARENT_PAY_TRANSACTION_ID;
3475: --
3476: l_pay_ovn per_pay_proposals.object_version_number%type;
3477: l_comp_ovn per_pay_proposal_components.object_version_number%type;
3478: l_salary_warning boolean;
3479: l_proc varchar2(61) := 'process_delete_pay_action' ;
3480: --
3481: Begin

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

3484: --
3485: For l_comp_rec in csr_delete_comp loop
3486: --
3487: Select object_version_number into l_comp_ovn
3488: From per_pay_proposal_components where component_id = l_comp_rec.component_id;
3489: --
3490: hr_maintain_proposal_api.delete_proposal_component(
3491: p_component_id => l_comp_rec.component_id,
3492: p_validation_strength => 'STRONG',