APPS.PAY_IN_ELEMENT_TEMPLATE_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 1516: FROM pay_element_types_f pet

1512: ,pet.object_version_number
1513: ,pec.classification_name
1514: ,pet.element_name
1515: ,pet.reporting_name
1516: FROM pay_element_types_f pet
1517: ,pay_element_templates tmp
1518: ,pay_element_classifications pec
1519: WHERE pet.element_name = tmp.base_name
1520: AND tmp.template_id = p_template_id

Line 1527: FROM pay_element_types_f pet

1523: CURSOR csr_ae_set(p_base_name VARCHAR2
1524: , p_business_group_id NUMBER) IS
1525: SELECT pet.element_type_id
1526: ,pet.object_version_number
1527: FROM pay_element_types_f pet
1528: ,pay_element_classifications pec
1529: WHERE pet.element_name = p_base_name || ' Paid MP'
1530: AND pet.classification_id = pec.classification_id
1531: AND pet.business_group_id = p_business_group_id

Line 1572: FROM pay_element_types_f

1568: ,p_business_group_id NUMBER
1569: ,p_effective_date DATE)
1570: IS
1571: SELECT element_type_id, object_version_number
1572: FROM pay_element_types_f
1573: WHERE element_name = p_element_name || ' Paid MP'
1574: AND business_group_id = p_business_group_id
1575: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
1576:

Line 1598: l_et_name pay_element_types_f.element_name%TYPE ;

1594: l_bf_end_date DATE ;
1595: l_bf_ovn NUMBER ;
1596: l_bf_warn BOOLEAN ;
1597:
1598: l_et_name pay_element_types_f.element_name%TYPE ;
1599: l_cr_result BOOLEAN ;
1600:
1601: l_element_id NUMBER ;
1602: l_input_value_id NUMBER ;

Line 1823: FROM pay_element_types_f

1819: CLOSE csr_ae_type_id;
1820: /*
1821: SELECT element_type_id, object_version_number
1822: INTO l_et_id, l_ovn
1823: FROM pay_element_types_f
1824: WHERE element_name = l_element.element_name || ' Paid MP'
1825: AND business_group_id = l_element.business_group_id
1826: AND l_element.effective_start_date between effective_start_date and effective_end_date;
1827: */

Line 2022: FROM pay_element_types_f pet,

2018:
2019: CURSOR csr_et IS
2020: SELECT pet.element_type_id
2021: , pet.effective_start_date
2022: FROM pay_element_types_f pet,
2023: pay_shadow_element_types pset
2024: WHERE pset.template_id = p_template_id
2025: AND pset.element_name = pet.element_name;
2026: