APPS.PAY_NO_EERR_CONTINUOUS dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 794: pay_element_entry_values_f peev

790: select fnd_date.canonical_to_date (peev.screen_entry_value)
791: from pay_element_types_f pet,
792: pay_input_values_f piv,
793: pay_element_entries_f peef,
794: pay_element_entry_values_f peev
795: where pet.element_name = c_element_name
796: and pet.element_type_id = piv.element_type_id
797: and piv.name = c_input_val_name
798: and pet.legislation_code = 'NO'

Line 833: from pay_element_entry_values_f peev

829: c_eff_end_date date
830: ) is
831: select effective_start_date,
832: fnd_number.canonical_to_number (screen_entry_value) entry_value
833: from pay_element_entry_values_f peev
834: where element_entry_id = c_element_entry_id
835: and effective_start_date between c_eff_start_date and c_eff_end_date
836: and screen_entry_value is not null
837: and effective_start_date =

Line 839: from pay_element_entry_values_f peevf

835: and effective_start_date between c_eff_start_date and c_eff_end_date
836: and screen_entry_value is not null
837: and effective_start_date =
838: (select max (effective_start_date)
839: from pay_element_entry_values_f peevf
840: where element_entry_id = c_element_entry_id
841: and effective_start_date between c_eff_start_date
842: and c_eff_end_date
843: -- and peevf.effective_start_date = peev.effective_start_date

Line 853: from pay_element_entry_values_f

849: c_element_entry_id number,
850: c_effective_date date
851: ) is
852: select fnd_number.canonical_to_number (screen_entry_value) entry_value
853: from pay_element_entry_values_f
854: where element_entry_id = c_element_entry_id
855: and c_effective_date between effective_start_date
856: and effective_end_date
857: and screen_entry_value is not null;

Line 1180: open csr_get_table_id ('PAY_ELEMENT_ENTRY_VALUES_F');

1176: fetch csr_get_table_id into l_table1;
1177: close csr_get_table_id;
1178: --
1179: --
1180: open csr_get_table_id ('PAY_ELEMENT_ENTRY_VALUES_F');
1181: fetch csr_get_table_id into l_table2;
1182: close csr_get_table_id;
1183: --
1184: open csr_get_table_id ('PER_ALL_ASSIGNMENTS_F');