APPS.PER_CEI_BUS dependencies on PAY_ELEMENT_TYPES_F

Line 1540: FROM pay_element_types_f p --pay_element_types_x p

1536: ,p_effective_date IN DATE) IS
1537: --
1538: CURSOR csr_get_pay_element IS
1539: SELECT multiple_entries_allowed_flag
1540: FROM pay_element_types_f p --pay_element_types_x p
1541: WHERE ((p.business_group_id = p_business_group_id) OR
1542: (p.business_group_id IS NULL))
1543: AND ((p.legislation_code = p_legislation_code) OR
1544: (p.legislation_code IS NULL))

Line 1948: ,p_legislation_code IN pay_element_types_f.legislation_code%TYPE

1944: ,p_cagr_api_id IN per_cagr_entitlement_items.cagr_api_id%TYPE
1945: ,p_element_type_id IN per_cagr_entitlement_items.element_type_id%TYPE
1946: ,p_input_value_id IN per_cagr_entitlement_items.input_value_id%TYPE
1947: ,p_effective_date IN DATE
1948: ,p_legislation_code IN pay_element_types_f.legislation_code%TYPE
1949: ,p_business_group_id IN pay_element_types_f.business_group_id%TYPE
1950: ) IS
1951: --
1952: l_proc varchar2(72) := g_package || 'chk_element_type_id';

Line 1949: ,p_business_group_id IN pay_element_types_f.business_group_id%TYPE

1945: ,p_element_type_id IN per_cagr_entitlement_items.element_type_id%TYPE
1946: ,p_input_value_id IN per_cagr_entitlement_items.input_value_id%TYPE
1947: ,p_effective_date IN DATE
1948: ,p_legislation_code IN pay_element_types_f.legislation_code%TYPE
1949: ,p_business_group_id IN pay_element_types_f.business_group_id%TYPE
1950: ) IS
1951: --
1952: l_proc varchar2(72) := g_package || 'chk_element_type_id';
1953: l_dummy pay_element_types_f.element_type_id%TYPE;

Line 1953: l_dummy pay_element_types_f.element_type_id%TYPE;

1949: ,p_business_group_id IN pay_element_types_f.business_group_id%TYPE
1950: ) IS
1951: --
1952: l_proc varchar2(72) := g_package || 'chk_element_type_id';
1953: l_dummy pay_element_types_f.element_type_id%TYPE;
1954: --
1955: CURSOR csr_chk_element IS
1956: SELECT pat.element_type_id
1957: FROM pay_element_types_f pat

Line 1957: FROM pay_element_types_f pat

1953: l_dummy pay_element_types_f.element_type_id%TYPE;
1954: --
1955: CURSOR csr_chk_element IS
1956: SELECT pat.element_type_id
1957: FROM pay_element_types_f pat
1958: WHERE pat.element_type_id = p_element_type_id
1959: AND ( ( pat.business_group_id IS NULL AND
1960: pat.legislation_code IS NULL) OR
1961: ( pat.business_group_id IS NULL AND