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 1528: FROM pay_element_types_f pet

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

Line 1573: FROM pay_element_types_f

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

Line 1599: l_et_name pay_element_types_f.element_name%TYPE ;

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

Line 1824: FROM pay_element_types_f

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

Line 2023: FROM pay_element_types_f pet,

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