APPS.PAY_CA_EMP_TAX_INF dependencies on PER_PAY_BASES

Line 955: select pay_basis from per_pay_bases

951:
952: function get_salary_basis(p_salary_basis_id in Number)
953: return VARCHAR2 is
954: cursor csr_salary_basis(l_pay_basis_id in number) is
955: select pay_basis from per_pay_bases
956: where pay_basis_id = l_pay_basis_id;
957:
958: l_salary_basis varchar2(30);
959: begin

Line 998: select input_value_id from per_pay_bases

994: between piv.effective_start_date AND piv.effective_end_date
995: AND piv.input_value_id = l_input_value_id;
996:
997: cursor csr_input_value_id(l_pay_basis_id in number) is
998: select input_value_id from per_pay_bases
999: where pay_basis_id = l_pay_basis_id;
1000:
1001: l_base_salary varchar2(30);
1002: l_input_value_id number;