DBA Data[Home] [Help]

APPS.PAY_NL_PAYSLIP_ARCHIVE dependencies on PAY_SUB_CLASSIFICATION_RULES_F

Line 2844: FROM pay_sub_classification_rules_f pscf

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

Line 2858: FROM pay_sub_classification_rules_f pscf

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