APPS.PAY_DK_GENERAL dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 26: ,pay_element_entry_values_f eev1

22: ,pay_element_links_f el
23: ,pay_element_types_f et
24: ,pay_input_values_f iv1
25: ,pay_element_entries_f ee
26: ,pay_element_entry_values_f eev1
27: WHERE asg1.assignment_id = p_assignment_id
28: AND p_effective_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date
29: AND p_effective_date BETWEEN asg2.effective_start_date AND asg2.effective_end_date
30: AND per.person_id = asg1.person_id

Line 269: ,pay_element_entry_values_f eev1

265: ,pay_element_links_f el
266: ,pay_element_types_f et
267: ,pay_input_values_f iv1
268: ,pay_element_entries_f ee
269: ,pay_element_entry_values_f eev1
270: WHERE asg1.assignment_id = p_assignment_id
271: AND p_effective_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date
272: AND per.person_id = asg1.person_id
273: AND asg2.person_id = per.person_id

Line 321: ,pay_element_entry_values_f eev1

317: ,pay_element_links_f el
318: ,pay_element_types_f et
319: ,pay_input_values_f iv1
320: ,pay_element_entries_f ee
321: ,pay_element_entry_values_f eev1
322: WHERE asg1.assignment_id = p_assignment_id
323: AND p_effective_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date
324: AND p_effective_date BETWEEN asg2.effective_start_date AND asg2.effective_end_date
325: AND per.person_id = asg1.person_id

Line 343: eevalue pay_element_entry_values_f.screen_entry_value%TYPE,

339: AND p_effective_date BETWEEN per.effective_start_date AND per.effective_end_date
340: ORDER BY ee.element_entry_id;
341: --
342: TYPE l_record is record (eeid pay_element_entries_f.element_entry_id%TYPE,
343: eevalue pay_element_entry_values_f.screen_entry_value%TYPE,
344: eename pay_input_values_f.name%TYPE );
345: l_rec l_record;
346: TYPE l_table is table of l_record index by BINARY_INTEGER;
347: l_tab l_table;

Line 559: pay_element_entry_values_f peevf,

555: fnd_number.canonical_to_number(NVL(peevf1.screen_entry_value,'0')) Employer_Amount,
556: fnd_number.canonical_to_number(NVL(peevf2.screen_entry_value,'0')) Employee_Percent,
557: fnd_number.canonical_to_number(NVL(peevf3.screen_entry_value,'0')) Employer_Percent
558: from
559: pay_element_entry_values_f peevf,
560: pay_element_entry_values_f peevf1,
561: pay_element_entry_values_f peevf2,
562: pay_element_entry_values_f peevf3,
563: pay_input_values_f piv_ee_amt,

Line 560: pay_element_entry_values_f peevf1,

556: fnd_number.canonical_to_number(NVL(peevf2.screen_entry_value,'0')) Employee_Percent,
557: fnd_number.canonical_to_number(NVL(peevf3.screen_entry_value,'0')) Employer_Percent
558: from
559: pay_element_entry_values_f peevf,
560: pay_element_entry_values_f peevf1,
561: pay_element_entry_values_f peevf2,
562: pay_element_entry_values_f peevf3,
563: pay_input_values_f piv_ee_amt,
564: pay_input_values_f piv_er_amt,

Line 561: pay_element_entry_values_f peevf2,

557: fnd_number.canonical_to_number(NVL(peevf3.screen_entry_value,'0')) Employer_Percent
558: from
559: pay_element_entry_values_f peevf,
560: pay_element_entry_values_f peevf1,
561: pay_element_entry_values_f peevf2,
562: pay_element_entry_values_f peevf3,
563: pay_input_values_f piv_ee_amt,
564: pay_input_values_f piv_er_amt,
565: pay_input_values_f piv_ee_perc,

Line 562: pay_element_entry_values_f peevf3,

558: from
559: pay_element_entry_values_f peevf,
560: pay_element_entry_values_f peevf1,
561: pay_element_entry_values_f peevf2,
562: pay_element_entry_values_f peevf3,
563: pay_input_values_f piv_ee_amt,
564: pay_input_values_f piv_er_amt,
565: pay_input_values_f piv_ee_perc,
566: pay_input_values_f piv_er_perc