APPS.PAY_NO_K27_REIM_UPLD dependencies on PAY_ELEMENT_TYPES_F

Line 43: FROM pay_element_types_f

39: )
40: IS
41: CURSOR element_csr IS
42: SELECT element_type_id
43: FROM pay_element_types_f
44: WHERE element_name = 'K27 Reimbursement File Details'
45: AND nvl(business_group_id, p_business_group_id) = p_business_group_id
46: AND nvl(legislation_code, 'NO') = 'NO'
47: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;

Line 208: ,p_element_name IN pay_element_types_f.ELEMENT_NAME%TYPE

204: (
205: p_assignment_id IN NUMBER
206: ,p_business_group_id IN NUMBER
207: ,p_date IN per_all_assignments_f.effective_start_date%TYPE
208: ,p_element_name IN pay_element_types_f.ELEMENT_NAME%TYPE
209: ) RETURN NUMBER
210: IS
211: l_element_link_id pay_element_links_f.ELEMENT_LINK_ID%TYPE;
212: CURSOR csr_get_ele_type_id IS

Line 214: FROM pay_element_types_f

210: IS
211: l_element_link_id pay_element_links_f.ELEMENT_LINK_ID%TYPE;
212: CURSOR csr_get_ele_type_id IS
213: SELECT element_type_id
214: FROM pay_element_types_f
215: WHERE
216: Element_name = p_element_name
217: AND p_date BETWEEN effective_start_date AND effective_end_date ;
218: