APPS.PAY_DK_EHOL_CARD_REQUEST dependencies on PAY_ELEMENT_ENTRIES_F

Line 135: ,pay_element_entries_f ee

131: ,per_all_people_f per
132: ,pay_element_links_f el
133: ,pay_element_types_f et
134: ,pay_input_values_f iv1
135: ,pay_element_entries_f ee
136: ,pay_element_entry_values_f eev1
137: WHERE asg1.assignment_id = p_assignment_id
138: AND p_effective_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date
139: AND p_effective_date BETWEEN asg2.effective_start_date AND asg2.effective_end_date

Line 157: TYPE l_record is record (eeid pay_element_entries_f.element_entry_id%TYPE,

153: AND p_effective_date BETWEEN eev1.effective_start_date AND eev1.effective_end_date
154: AND p_effective_date BETWEEN per.effective_start_date AND per.effective_end_date
155: ORDER BY ee.element_entry_id;
156: --
157: TYPE l_record is record (eeid pay_element_entries_f.element_entry_id%TYPE,
158: eevalue pay_element_entry_values_f.screen_entry_value%TYPE,
159: eename pay_input_values_f.name%TYPE );
160: l_rec l_record;
161: TYPE l_table is table of l_record index by BINARY_INTEGER;

Line 762: ,pay_element_entries_f ee

758: SELECT 1
759: FROM per_all_assignments_f asg1
760: ,pay_element_types_f et
761: ,pay_input_values_f iv1
762: ,pay_element_entries_f ee
763: ,pay_element_entry_values_f eev1
764: WHERE asg1.assignment_id = p_assg_id
765: -- AND p_effective_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date
766: AND et.element_name = 'Holiday Card Payment Request'