DBA Data[Home] [Help]

APPS.HR_MAINTAIN_PROPOSAL_API dependencies on PER_PAY_BASES

Line 505: l_pay_basis per_pay_bases.pay_basis%TYPE;

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;
506: --
507: --
508: cursor csr_get_element_detail is
509: select pet.element_type_id,

Line 516: per_pay_bases ppb,

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
520: pet.element_type_id = piv.element_type_id