eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_JP_WIC_PKG dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 403: pay_element_entry_values_f peev,

399: min(decode(piv.display_sequence, 8, peev.screen_entry_value)) salary_payer_address_kanji,
400: min(decode(piv.display_sequence, 9, peev.screen_entry_value)) salary_payer_name_kana,
401: min(decode(piv.display_sequence, 10, peev.screen_entry_value)) salary_payer_name_kanji
402: from pay_input_values_f piv,
403: pay_element_entry_values_f peev,
404: pay_element_entries_f pee,
405: pay_element_links_f pel
406: where pel.element_type_id = g_prev_job_elm
407: and pel.business_group_id + 0 = p_business_group_id

Line 970: INDEX(PEEV_1 PAY_ELEMENT_ENTRY_VALUES_F_N50)

966: INDEX(PLIV_1 PAY_LINK_INPUT_VALUES_F_N2)
967: INDEX(PLIV_2 PAY_LINK_INPUT_VALUES_F_N2)
968: INDEX(PLIV_3 PAY_LINK_INPUT_VALUES_F_N2)
969: INDEX(PEE PAY_ELEMENT_ENTRIES_F_N51)
970: INDEX(PEEV_1 PAY_ELEMENT_ENTRY_VALUES_F_N50)
971: INDEX(PEEV_2 PAY_ELEMENT_ENTRY_VALUES_F_N50)
972: INDEX(PEEV_3 PAY_ELEMENT_ENTRY_VALUES_F_N50) */
973: decode(piv_1.uom,'D',fnd_date.canonical_to_date(peev_1.screen_entry_value),null) residence_date,
974: peev_2.screen_entry_value loan_type,

Line 971: INDEX(PEEV_2 PAY_ELEMENT_ENTRY_VALUES_F_N50)

967: INDEX(PLIV_2 PAY_LINK_INPUT_VALUES_F_N2)
968: INDEX(PLIV_3 PAY_LINK_INPUT_VALUES_F_N2)
969: INDEX(PEE PAY_ELEMENT_ENTRIES_F_N51)
970: INDEX(PEEV_1 PAY_ELEMENT_ENTRY_VALUES_F_N50)
971: INDEX(PEEV_2 PAY_ELEMENT_ENTRY_VALUES_F_N50)
972: INDEX(PEEV_3 PAY_ELEMENT_ENTRY_VALUES_F_N50) */
973: decode(piv_1.uom,'D',fnd_date.canonical_to_date(peev_1.screen_entry_value),null) residence_date,
974: peev_2.screen_entry_value loan_type,
975: decode(piv_3.uom,'M',fnd_number.canonical_to_number(peev_3.screen_entry_value),null) loan_balance

Line 972: INDEX(PEEV_3 PAY_ELEMENT_ENTRY_VALUES_F_N50) */

968: INDEX(PLIV_3 PAY_LINK_INPUT_VALUES_F_N2)
969: INDEX(PEE PAY_ELEMENT_ENTRIES_F_N51)
970: INDEX(PEEV_1 PAY_ELEMENT_ENTRY_VALUES_F_N50)
971: INDEX(PEEV_2 PAY_ELEMENT_ENTRY_VALUES_F_N50)
972: INDEX(PEEV_3 PAY_ELEMENT_ENTRY_VALUES_F_N50) */
973: decode(piv_1.uom,'D',fnd_date.canonical_to_date(peev_1.screen_entry_value),null) residence_date,
974: peev_2.screen_entry_value loan_type,
975: decode(piv_3.uom,'M',fnd_number.canonical_to_number(peev_3.screen_entry_value),null) loan_balance
976: from pay_input_values_f piv_1,

Line 982: pay_element_entry_values_f peev_1,

978: pay_link_input_values_f pliv_1,
979: pay_link_input_values_f pliv_2,
980: pay_link_input_values_f pliv_3,
981: pay_element_entries_f pee,
982: pay_element_entry_values_f peev_1,
983: pay_element_entry_values_f peev_2,
984: pay_element_entry_values_f peev_3
985: where piv_1.input_value_id = g_housing_loan_info_elm.res_date_iv
986: and p_date_earned

Line 983: pay_element_entry_values_f peev_2,

979: pay_link_input_values_f pliv_2,
980: pay_link_input_values_f pliv_3,
981: pay_element_entries_f pee,
982: pay_element_entry_values_f peev_1,
983: pay_element_entry_values_f peev_2,
984: pay_element_entry_values_f peev_3
985: where piv_1.input_value_id = g_housing_loan_info_elm.res_date_iv
986: and p_date_earned
987: between piv_1.effective_start_date and piv_1.effective_end_date

Line 984: pay_element_entry_values_f peev_3

980: pay_link_input_values_f pliv_3,
981: pay_element_entries_f pee,
982: pay_element_entry_values_f peev_1,
983: pay_element_entry_values_f peev_2,
984: pay_element_entry_values_f peev_3
985: where piv_1.input_value_id = g_housing_loan_info_elm.res_date_iv
986: and p_date_earned
987: between piv_1.effective_start_date and piv_1.effective_end_date
988: and piv_3.input_value_id = g_housing_loan_info_elm.loan_balance_iv

Line 1084: pay_element_entry_values_f peev,

1080: min(decode(piv.display_sequence, 11, peev.screen_entry_value)) wtm_description4,
1081: min(decode(piv.display_sequence, 12, peev.screen_entry_value)) wtm_description5
1082: from pay_element_links_f pel,
1083: pay_element_entries_f pee,
1084: pay_element_entry_values_f peev,
1085: pay_input_values_f piv
1086: where pel.element_type_id = g_desc_element_type_id
1087: and pel.business_group_id = p_business_group_id
1088: and p_effective_date