APPS.PAY_CA_EMP_TAX_INF dependencies on PER_PAY_BASES

Line 908: select pay_basis from per_pay_bases

904:
905: function get_salary_basis(p_salary_basis_id in Number)
906: return VARCHAR2 is
907: cursor csr_salary_basis(l_pay_basis_id in number) is
908: select pay_basis from per_pay_bases
909: where pay_basis_id = l_pay_basis_id;
910:
911: l_salary_basis varchar2(30);
912: begin

Line 951: select input_value_id from per_pay_bases

947: between piv.effective_start_date AND piv.effective_end_date
948: AND piv.input_value_id = l_input_value_id;
949:
950: cursor csr_input_value_id(l_pay_basis_id in number) is
951: select input_value_id from per_pay_bases
952: where pay_basis_id = l_pay_basis_id;
953:
954: l_base_salary varchar2(30);
955: l_input_value_id number;