APPS.HR_MAINTAIN_PROPOSAL_API dependencies on PAY_INPUT_VALUES_F

Line 487: l_input_value_id pay_input_values_f.input_value_id%TYPE;

483: ,p_element_entry_id in out nocopy number
484: ,p_proposed_salary in number) is
485: --
486: l_element_type_id pay_element_types_f.element_type_id%TYPE;
487: l_input_value_id pay_input_values_f.input_value_id%TYPE;
488: l_element_link_id pay_element_links_f.element_link_id%TYPE;
489: l_effective_end_date date;
490: l_effective_start_date date := p_change_date;
491: l_first_date date;

Line 501: l_input_value_id2 pay_input_values_f.input_value_id%TYPE;

497: l_proc varchar2(72) := g_package||'maintain_elements_bsp';
498: l_dummy number;
499: l_dummy_v varchar2(300);
500: l_entry_value2 NUMBER;
501: l_input_value_id2 pay_input_values_f.input_value_id%TYPE;
502: l_payroll_value VARCHAR2(80);
503: l_next_change_date per_pay_proposals.change_date%TYPE;
504: l_Entry_End_Date pay_element_entries_f.effective_end_date%TYPE;
505: l_pay_basis per_pay_bases.pay_basis%TYPE;

Line 515: pay_input_values_f piv,

511: ppb.pay_annualization_factor,
512: ppb.pay_basis
513: from
514: pay_element_types_f pet,
515: pay_input_values_f piv,
516: per_pay_bases ppb,
517: per_all_assignments_f asg
518:
519: where

Line 550: from pay_input_values_f piv

546: and element_entry_id=p_element_entry_id;
547: --
548: cursor get_payroll_element(p_element_type_id NUMBER) is
549: select piv.input_value_id
550: from pay_input_values_f piv
551: , hr_lookups hrl
552: where piv.element_type_id=p_element_type_id
553: and piv.name=hrl.meaning
554: and p_change_date between

Line 1281: l_input_value_id pay_input_values_f.input_value_id%TYPE;

1277: p_payroll_warning out nocopy boolean) is
1278: --
1279: l_proc varchar2(72) := g_package||'update_salary_proposal';
1280: l_element_type_id pay_element_types_f.element_type_id%TYPE;
1281: l_input_value_id pay_input_values_f.input_value_id%TYPE;
1282: l_element_link_id pay_element_links_f.element_link_id%TYPE;
1283: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
1284: l_change_date per_pay_proposals.change_date%TYPE;
1285: l_next_sal_review_date per_pay_proposals.next_sal_review_date%TYPE;