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_PROPOSALS

Line 150: from per_pay_proposals

146: and status <> 'DELETE';
147: --
148: Cursor csr_prop is
149: select change_date
150: from per_pay_proposals
151: where assignment_id = p_assignment_id
152: and pay_proposal_id not in (select pay_proposal_id
153: from per_pay_transactions
154: where p_transaction_step_id is not null

Line 1470: from per_pay_proposals pay,

1466: null PRIOR_PAY_PROPOSAL_ID,
1467: null PRIOR_PAY_TRANSACTION_ID,
1468: null APPROVED,
1469: pay.object_version_number
1470: from per_pay_proposals pay,
1471: per_all_assignments_f paaf,
1472: per_pay_bases ppb,
1473: pay_input_values_f piv,
1474: pay_element_types_f pet

Line 3150: l_pay_proposal_id per_pay_proposals.pay_proposal_id%type;

3146: From hr_api_transactions
3147: Where transaction_id = (Select transaction_id from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id);
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;

Line 3151: l_pay_ovn per_pay_proposals.object_version_number%type;

3147: Where transaction_id = (Select transaction_id from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id);
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;

Line 3154: l_change_date per_pay_proposals.change_date%type;

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;
3158: l_approved_warning boolean;

Line 3341: l_pay_proposal_id per_pay_proposals.pay_proposal_id%type;

3337: and dml_operation = 'UPDATE'
3338: and PARENT_PAY_TRANSACTION_ID is not null
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;

Line 3342: l_pay_ovn per_pay_proposals.object_version_number%type;

3338: and PARENT_PAY_TRANSACTION_ID is not null
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;

Line 3364: From per_pay_proposals where pay_proposal_id = l_pay_rec.pay_proposal_id;

3360: -- Query update pay actions.
3361: -- Call Update API to Update salary proposal record.
3362: --
3363: Select object_version_number into l_pay_ovn
3364: From per_pay_proposals where pay_proposal_id = l_pay_rec.pay_proposal_id;
3365: --
3366:
3367: hr_maintain_proposal_api.update_salary_proposal(
3368: p_pay_proposal_id => l_pay_rec.pay_proposal_id,

Line 3476: l_pay_ovn per_pay_proposals.object_version_number%type;

3472: and dml_operation = 'DELETE'
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: --

Line 3500: From per_pay_proposals where pay_proposal_id = l_pay_rec.pay_proposal_id;

3496: --
3497: For l_pay_rec in csr_delete_pay loop
3498: --
3499: Select object_version_number into l_pay_ovn
3500: From per_pay_proposals where pay_proposal_id = l_pay_rec.pay_proposal_id;
3501: --
3502: hr_maintain_proposal_api.delete_salary_proposal
3503: (p_pay_proposal_id => l_pay_rec.pay_proposal_id
3504: ,p_business_group_id => l_pay_rec.business_group_id

Line 3721: from per_pay_proposals

3717: and p_effective_date between effective_start_date and effective_end_date;
3718: --
3719: Cursor csr_last_change_date Is
3720: select change_date
3721: from per_pay_proposals
3722: where assignment_id = p_assignment_id
3723: union
3724: select change_date
3725: from per_pay_transactions

Line 4316: from per_pay_proposals

4312: --
4313: --
4314: Cursor csr_last_change_date Is
4315: select change_date
4316: from per_pay_proposals
4317: where assignment_id = p_assignment_id
4318: union
4319: select change_date
4320: from per_pay_transactions

Line 5303: PER_PAY_PROPOSALS_POPULATE.get_norm_hours(p_assignment_id

5299: RETURN l_fte_factor;
5300: end if;
5301:
5302: if(nvl(l_hours_per_year,0) <> 0) then
5303: PER_PAY_PROPOSALS_POPULATE.get_norm_hours(p_assignment_id
5304: ,p_effective_date
5305: ,l_norm_hours_per_year);
5306:
5307: --changed by schowdhu for hire flow