APPS.PAY_NO_EERR_CONTINUOUS dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 628: pay_element_entry_values_f peev

624: select fnd_date.canonical_to_date (peev.screen_entry_value)
625: from pay_element_types_f pet,
626: pay_input_values_f piv,
627: pay_element_entries_f peef,
628: pay_element_entry_values_f peev
629: where pet.element_name = c_element_name
630: and pet.element_type_id = piv.element_type_id
631: and piv.name = c_input_val_name
632: and pet.legislation_code = 'NO'

Line 667: from pay_element_entry_values_f peev

663: c_eff_end_date date
664: ) is
665: select effective_start_date,
666: fnd_number.canonical_to_number (screen_entry_value) entry_value
667: from pay_element_entry_values_f peev
668: where element_entry_id = c_element_entry_id
669: and effective_start_date between c_eff_start_date and c_eff_end_date
670: and screen_entry_value is not null
671: and effective_start_date =

Line 673: from pay_element_entry_values_f peevf

669: and effective_start_date between c_eff_start_date and c_eff_end_date
670: and screen_entry_value is not null
671: and effective_start_date =
672: (select max (effective_start_date)
673: from pay_element_entry_values_f peevf
674: where element_entry_id = c_element_entry_id
675: and effective_start_date between c_eff_start_date
676: and c_eff_end_date
677: -- and peevf.effective_start_date = peev.effective_start_date

Line 687: from pay_element_entry_values_f

683: c_element_entry_id number,
684: c_effective_date date
685: ) is
686: select fnd_number.canonical_to_number (screen_entry_value) entry_value
687: from pay_element_entry_values_f
688: where element_entry_id = c_element_entry_id
689: and c_effective_date between effective_start_date
690: and effective_end_date
691: and screen_entry_value is not null;

Line 1014: open csr_get_table_id ('PAY_ELEMENT_ENTRY_VALUES_F');

1010: fetch csr_get_table_id into l_table1;
1011: close csr_get_table_id;
1012: --
1013: --
1014: open csr_get_table_id ('PAY_ELEMENT_ENTRY_VALUES_F');
1015: fetch csr_get_table_id into l_table2;
1016: close csr_get_table_id;
1017: --
1018: open csr_get_table_id ('PER_ALL_ASSIGNMENTS_F');