65: -- Cursor for fetching the Element Name
66: CURSOR csr_element_name IS
67: SELECT pet.element_name
68: FROM pay_element_entries_f pee
69: ,pay_element_types_f pet
70: WHERE pet.element_type_id = pee.element_type_id
71: AND pee.element_entry_id = p_ee_id;
72: --
73: --Cursor for fetching PF Org Id
226: -- Cursor for fetching the Element Name
227: CURSOR csr_element_name IS
228: SELECT pet.element_name
229: FROM pay_element_entries_f pee
230: ,pay_element_types_f pet
231: WHERE pet.element_type_id = pee.element_type_id
232: AND pee.element_entry_id = p_ee_id;
233: --
234: --Cursor for fetching PT Org Id
353:
354: CURSOR csr_context
355: IS
356: SELECT element_information1
357: FROM pay_element_types pet
358: ,pay_element_links pel
359: ,pay_element_entries pee
360: WHERE pet.element_type_id = pel.element_type_id
361: AND pel.element_link_id = pee.element_link_id