111: )
112: RETURN VARCHAR2
113: IS
114: l_tax_method hr_organization_information.org_information3%type;
115: l_special_payment_type_id pay_element_classifications.classification_id%type;
116:
117: CURSOR csr_sp_pay_id ( p_special_payment_type IN VARCHAR2 ) IS
118: SELECT pri.classification_id
119: FROM pay_element_classifications pri,
115: l_special_payment_type_id pay_element_classifications.classification_id%type;
116:
117: CURSOR csr_sp_pay_id ( p_special_payment_type IN VARCHAR2 ) IS
118: SELECT pri.classification_id
119: FROM pay_element_classifications pri,
120: pay_element_classifications sec
121: WHERE sec.legislation_code = 'CN'
122: AND sec.classification_name = 'Special Payments'
123: AND pri.parent_classification_id = sec.classification_id
116:
117: CURSOR csr_sp_pay_id ( p_special_payment_type IN VARCHAR2 ) IS
118: SELECT pri.classification_id
119: FROM pay_element_classifications pri,
120: pay_element_classifications sec
121: WHERE sec.legislation_code = 'CN'
122: AND sec.classification_name = 'Special Payments'
123: AND pri.parent_classification_id = sec.classification_id
124: AND pri.classification_name = p_special_payment_type;