2840: CURSOR csr_sec_classification (p_element_type_id NUMBER
2841: ,p_sub_class_name VARCHAR2
2842: ,p_date_earned DATE) IS
2843: SELECT 1
2844: FROM pay_sub_classification_rules_f pscf
2845: ,pay_element_classifications pec
2846: WHERE pscf.element_type_id = p_element_type_id
2847: AND pscf.classification_id = pec.classification_id
2848: AND pec.classification_name = p_sub_class_name
2854: --6359807
2855: CURSOR csr_sec_classification_psi_ptx (p_element_type_id NUMBER
2856: ,p_date_earned DATE) IS
2857: SELECT pec.classification_name
2858: FROM pay_sub_classification_rules_f pscf
2859: ,pay_element_classifications pec
2860: WHERE pscf.element_type_id = p_element_type_id
2861: AND pscf.classification_id = pec.classification_id
2862: AND pec.classification_name