APPS.PER_SSHR_CHANGE_PAY dependencies on PER_PAY_PROPOSALS

Line 151: from per_pay_proposals

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

Line 1482: from per_pay_proposals pay,

1478: null PRIOR_PAY_PROPOSAL_ID,
1479: null PRIOR_PAY_TRANSACTION_ID,
1480: null APPROVED,
1481: pay.object_version_number
1482: from per_pay_proposals pay,
1483: per_all_assignments_f paaf,
1484: per_pay_bases ppb,
1485: pay_input_values_f piv,
1486: pay_element_types_f pet

Line 3175: l_pay_proposal_id per_pay_proposals.pay_proposal_id%type;

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

Line 3176: l_pay_ovn per_pay_proposals.object_version_number%type;

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

Line 3179: l_change_date per_pay_proposals.change_date%type;

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

Line 3355: l_pay_proposal_id per_pay_proposals.pay_proposal_id%type;

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

Line 3356: l_pay_ovn per_pay_proposals.object_version_number%type;

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

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

3374: -- Query update pay actions.
3375: -- Call Update API to Update salary proposal record.
3376: --
3377: Select object_version_number into l_pay_ovn
3378: From per_pay_proposals where pay_proposal_id = l_pay_rec.pay_proposal_id;
3379: --
3380:
3381: hr_maintain_proposal_api.update_salary_proposal(
3382: p_pay_proposal_id => l_pay_rec.pay_proposal_id,

Line 3495: l_pay_ovn per_pay_proposals.object_version_number%type;

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

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

3515: --
3516: For l_pay_rec in csr_delete_pay loop
3517: --
3518: Select object_version_number into l_pay_ovn
3519: From per_pay_proposals where pay_proposal_id = l_pay_rec.pay_proposal_id;
3520: --
3521: hr_maintain_proposal_api.delete_salary_proposal
3522: (p_pay_proposal_id => l_pay_rec.pay_proposal_id
3523: ,p_business_group_id => l_pay_rec.business_group_id

Line 3841: from per_pay_proposals

3837: and p_effective_date between effective_start_date and effective_end_date;
3838: --
3839: Cursor csr_last_change_date Is
3840: select change_date
3841: from per_pay_proposals
3842: where assignment_id = p_assignment_id
3843: union
3844: --vkodedal 08-Apr-2009 bug#8400759
3845: select ppt.change_date

Line 4448: from per_pay_proposals

4444: --
4445: --
4446: Cursor csr_last_change_date Is
4447: select change_date
4448: from per_pay_proposals
4449: where assignment_id = p_assignment_id
4450: union
4451: select change_date
4452: from per_pay_transactions ppt,

Line 5444: PER_PAY_PROPOSALS_POPULATE.get_norm_hours(p_assignment_id

5440: RETURN l_fte_factor;
5441: end if;
5442:
5443: if(nvl(l_hours_per_year,0) <> 0) then
5444: PER_PAY_PROPOSALS_POPULATE.get_norm_hours(p_assignment_id
5445: ,p_effective_date
5446: ,l_norm_hours_per_year);
5447:
5448: --changed by schowdhu for hire flow