DBA Data[Home] [Help]

APPS.PAY_KR_REPORT_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 1189: pay_element_entries_f peef,

1185: is
1186:
1187: select peevf.screen_entry_value from
1188: pay_element_entry_values_f peevf,
1189: pay_element_entries_f peef,
1190: pay_element_types_f petf,
1191: pay_input_values_f pivf
1192: WHERE peevf.element_entry_id = peef.element_entry_id
1193: and peef.element_type_id = petf.element_type_id

Line 1207: pay_element_entries_f peef,

1203: and p_effective_date BETWEEN pivf.effective_start_date AND pivf.effective_end_date
1204: and peevf.element_entry_id = (
1205: SELECT peevf.element_entry_id element_entry_id
1206: FROM pay_element_entry_values_f peevf,
1207: pay_element_entries_f peef,
1208: pay_element_types_f petf,
1209: pay_input_values_f pivf
1210: WHERE peevf.element_entry_id = peef.element_entry_id
1211: and peef.element_type_id = petf.element_type_id