DBA Data[Home] [Help]

APPS.PAY_GB_WORKING_TAX_CREDIT dependencies on PAY_ELEMENT_TYPES_F

Line 75: pay_element_types_f petf

71: -- BUG 3221422 Changed Query for improving performance
72: cursor csr_daily_amt_iv_id is
73: select piv.input_value_id
74: from pay_input_values_f piv,
75: pay_element_types_f petf
76: where petf.element_type_id = piv.element_type_id
77: and petf.element_name = 'Working Tax Credit'
78: and piv.name = 'Daily Amount'
79: and petf.legislation_code = 'GB';

Line 93: pay_element_types_f petf

89: fnd_number.canonical_to_number(peev.Screen_entry_value),null)) as daily_amount
90: from pay_element_entry_values_f peev,
91: pay_element_entries_f peef,
92: pay_element_links_f pelf,
93: pay_element_types_f petf
94: where pelf.element_link_id = peef.element_link_id
95: and peef.element_entry_id = peev.element_entry_id
96: and petf.element_type_id = pelf.element_type_id
97: and peev.effective_start_date = peef.effective_start_date