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_REPORT_PKG dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 918: pay_element_entry_values_f peev,

914: '1',hoi.org_information6||hoi.org_information7||hoi.org_information8,
915: hoi.org_information9||hoi.org_information10||hoi.org_information11),1,255) EMPLOYER_ADDRESS,
916: peev.effective_end_date PREV_SWOT_TERM_DATE
917: from hr_organization_information hoi,
918: pay_element_entry_values_f peev,
919: pay_element_entries_f pee
920: where hoi.organization_id(+) = cp_itax_organization_id
921: and hoi.org_information_context(+) = 'JP_TAX_SWOT_INFO'
922: -- Previous SWOT term date

Line 1086: INDEX(TAXABLE_AMT PAY_ELEMENT_ENTRY_VALUES_F_N50)

1082:
1083: cursor csr_get_entry_values is
1084: select /*+ ORDERED
1085: NO_MERGE(entry_type_v)
1086: INDEX(TAXABLE_AMT PAY_ELEMENT_ENTRY_VALUES_F_N50)
1087: INDEX(ITAX PAY_ELEMENT_ENTRY_VALUES_F_N50)
1088: INDEX(SI_PREM PAY_ELEMENT_ENTRY_VALUES_F_N50)
1089: INDEX(MUTUAL_AID PAY_ELEMENT_ENTRY_VALUES_F_N50)
1090: INDEX(TERM_DATE PAY_ELEMENT_ENTRY_VALUES_F_N50)

Line 1087: INDEX(ITAX PAY_ELEMENT_ENTRY_VALUES_F_N50)

1083: cursor csr_get_entry_values is
1084: select /*+ ORDERED
1085: NO_MERGE(entry_type_v)
1086: INDEX(TAXABLE_AMT PAY_ELEMENT_ENTRY_VALUES_F_N50)
1087: INDEX(ITAX PAY_ELEMENT_ENTRY_VALUES_F_N50)
1088: INDEX(SI_PREM PAY_ELEMENT_ENTRY_VALUES_F_N50)
1089: INDEX(MUTUAL_AID PAY_ELEMENT_ENTRY_VALUES_F_N50)
1090: INDEX(TERM_DATE PAY_ELEMENT_ENTRY_VALUES_F_N50)
1091: INDEX(ADDR PAY_ELEMENT_ENTRY_VALUES_F_N50)

Line 1088: INDEX(SI_PREM PAY_ELEMENT_ENTRY_VALUES_F_N50)

1084: select /*+ ORDERED
1085: NO_MERGE(entry_type_v)
1086: INDEX(TAXABLE_AMT PAY_ELEMENT_ENTRY_VALUES_F_N50)
1087: INDEX(ITAX PAY_ELEMENT_ENTRY_VALUES_F_N50)
1088: INDEX(SI_PREM PAY_ELEMENT_ENTRY_VALUES_F_N50)
1089: INDEX(MUTUAL_AID PAY_ELEMENT_ENTRY_VALUES_F_N50)
1090: INDEX(TERM_DATE PAY_ELEMENT_ENTRY_VALUES_F_N50)
1091: INDEX(ADDR PAY_ELEMENT_ENTRY_VALUES_F_N50)
1092: INDEX(EMPLOYER_NAME PAY_ELEMENT_ENTRY_VALUES_F_N50) */

Line 1089: INDEX(MUTUAL_AID PAY_ELEMENT_ENTRY_VALUES_F_N50)

1085: NO_MERGE(entry_type_v)
1086: INDEX(TAXABLE_AMT PAY_ELEMENT_ENTRY_VALUES_F_N50)
1087: INDEX(ITAX PAY_ELEMENT_ENTRY_VALUES_F_N50)
1088: INDEX(SI_PREM PAY_ELEMENT_ENTRY_VALUES_F_N50)
1089: INDEX(MUTUAL_AID PAY_ELEMENT_ENTRY_VALUES_F_N50)
1090: INDEX(TERM_DATE PAY_ELEMENT_ENTRY_VALUES_F_N50)
1091: INDEX(ADDR PAY_ELEMENT_ENTRY_VALUES_F_N50)
1092: INDEX(EMPLOYER_NAME PAY_ELEMENT_ENTRY_VALUES_F_N50) */
1093: nvl(taxable_amt.screen_entry_value,0) PJOB_TAXABLE_AMT,

Line 1090: INDEX(TERM_DATE PAY_ELEMENT_ENTRY_VALUES_F_N50)

1086: INDEX(TAXABLE_AMT PAY_ELEMENT_ENTRY_VALUES_F_N50)
1087: INDEX(ITAX PAY_ELEMENT_ENTRY_VALUES_F_N50)
1088: INDEX(SI_PREM PAY_ELEMENT_ENTRY_VALUES_F_N50)
1089: INDEX(MUTUAL_AID PAY_ELEMENT_ENTRY_VALUES_F_N50)
1090: INDEX(TERM_DATE PAY_ELEMENT_ENTRY_VALUES_F_N50)
1091: INDEX(ADDR PAY_ELEMENT_ENTRY_VALUES_F_N50)
1092: INDEX(EMPLOYER_NAME PAY_ELEMENT_ENTRY_VALUES_F_N50) */
1093: nvl(taxable_amt.screen_entry_value,0) PJOB_TAXABLE_AMT,
1094: nvl(itax.screen_entry_value,0) PJOB_ITAX,

Line 1091: INDEX(ADDR PAY_ELEMENT_ENTRY_VALUES_F_N50)

1087: INDEX(ITAX PAY_ELEMENT_ENTRY_VALUES_F_N50)
1088: INDEX(SI_PREM PAY_ELEMENT_ENTRY_VALUES_F_N50)
1089: INDEX(MUTUAL_AID PAY_ELEMENT_ENTRY_VALUES_F_N50)
1090: INDEX(TERM_DATE PAY_ELEMENT_ENTRY_VALUES_F_N50)
1091: INDEX(ADDR PAY_ELEMENT_ENTRY_VALUES_F_N50)
1092: INDEX(EMPLOYER_NAME PAY_ELEMENT_ENTRY_VALUES_F_N50) */
1093: nvl(taxable_amt.screen_entry_value,0) PJOB_TAXABLE_AMT,
1094: nvl(itax.screen_entry_value,0) PJOB_ITAX,
1095: nvl(si_prem.screen_entry_value,0) PJOB_SI_PREM,

Line 1092: INDEX(EMPLOYER_NAME PAY_ELEMENT_ENTRY_VALUES_F_N50) */

1088: INDEX(SI_PREM PAY_ELEMENT_ENTRY_VALUES_F_N50)
1089: INDEX(MUTUAL_AID PAY_ELEMENT_ENTRY_VALUES_F_N50)
1090: INDEX(TERM_DATE PAY_ELEMENT_ENTRY_VALUES_F_N50)
1091: INDEX(ADDR PAY_ELEMENT_ENTRY_VALUES_F_N50)
1092: INDEX(EMPLOYER_NAME PAY_ELEMENT_ENTRY_VALUES_F_N50) */
1093: nvl(taxable_amt.screen_entry_value,0) PJOB_TAXABLE_AMT,
1094: nvl(itax.screen_entry_value,0) PJOB_ITAX,
1095: nvl(si_prem.screen_entry_value,0) PJOB_SI_PREM,
1096: nvl(mutual_aid.screen_entry_value,0) PJOB_MUTUAL_AID,

Line 1113: pay_element_entry_values_f taxable_amt,

1109: and pelf.element_type_id = petf.element_type_id
1110: and pelf.business_group_id +0 = p_business_group_id
1111: and peef.element_link_id = pelf.element_link_id
1112: and peef.assignment_id = p_assignment_id) entry_type_v,
1113: pay_element_entry_values_f taxable_amt,
1114: pay_element_entry_values_f itax,
1115: pay_element_entry_values_f si_prem,
1116: pay_element_entry_values_f mutual_aid,
1117: pay_element_entry_values_f term_date,

Line 1114: pay_element_entry_values_f itax,

1110: and pelf.business_group_id +0 = p_business_group_id
1111: and peef.element_link_id = pelf.element_link_id
1112: and peef.assignment_id = p_assignment_id) entry_type_v,
1113: pay_element_entry_values_f taxable_amt,
1114: pay_element_entry_values_f itax,
1115: pay_element_entry_values_f si_prem,
1116: pay_element_entry_values_f mutual_aid,
1117: pay_element_entry_values_f term_date,
1118: pay_element_entry_values_f addr,

Line 1115: pay_element_entry_values_f si_prem,

1111: and peef.element_link_id = pelf.element_link_id
1112: and peef.assignment_id = p_assignment_id) entry_type_v,
1113: pay_element_entry_values_f taxable_amt,
1114: pay_element_entry_values_f itax,
1115: pay_element_entry_values_f si_prem,
1116: pay_element_entry_values_f mutual_aid,
1117: pay_element_entry_values_f term_date,
1118: pay_element_entry_values_f addr,
1119: pay_element_entry_values_f employer_name

Line 1116: pay_element_entry_values_f mutual_aid,

1112: and peef.assignment_id = p_assignment_id) entry_type_v,
1113: pay_element_entry_values_f taxable_amt,
1114: pay_element_entry_values_f itax,
1115: pay_element_entry_values_f si_prem,
1116: pay_element_entry_values_f mutual_aid,
1117: pay_element_entry_values_f term_date,
1118: pay_element_entry_values_f addr,
1119: pay_element_entry_values_f employer_name
1120: where taxable_amt.element_entry_id = entry_type_v.element_entry_id

Line 1117: pay_element_entry_values_f term_date,

1113: pay_element_entry_values_f taxable_amt,
1114: pay_element_entry_values_f itax,
1115: pay_element_entry_values_f si_prem,
1116: pay_element_entry_values_f mutual_aid,
1117: pay_element_entry_values_f term_date,
1118: pay_element_entry_values_f addr,
1119: pay_element_entry_values_f employer_name
1120: where taxable_amt.element_entry_id = entry_type_v.element_entry_id
1121: and taxable_amt.input_value_id = p_taxable_amt_iv_id

Line 1118: pay_element_entry_values_f addr,

1114: pay_element_entry_values_f itax,
1115: pay_element_entry_values_f si_prem,
1116: pay_element_entry_values_f mutual_aid,
1117: pay_element_entry_values_f term_date,
1118: pay_element_entry_values_f addr,
1119: pay_element_entry_values_f employer_name
1120: where taxable_amt.element_entry_id = entry_type_v.element_entry_id
1121: and taxable_amt.input_value_id = p_taxable_amt_iv_id
1122: and p_effective_date

Line 1119: pay_element_entry_values_f employer_name

1115: pay_element_entry_values_f si_prem,
1116: pay_element_entry_values_f mutual_aid,
1117: pay_element_entry_values_f term_date,
1118: pay_element_entry_values_f addr,
1119: pay_element_entry_values_f employer_name
1120: where taxable_amt.element_entry_id = entry_type_v.element_entry_id
1121: and taxable_amt.input_value_id = p_taxable_amt_iv_id
1122: and p_effective_date
1123: between taxable_amt.effective_start_date and taxable_amt.effective_end_date

Line 2089: INDEX(PAY_ELEMENT_ENTRY_VALUES_F_N50 PEEV1)

2085: USE_NL(PLIV1, PLIV2, PEE, PEEV1, PEEV2)
2086: INDEX(PAY_LINK_INPUT_VALUES_F_N2 PLIV1)
2087: INDEX(PAY_LINK_INPUT_VALUES_F_N2 PLIV2)
2088: INDEX(PAY_ELEMENT_ENTRIES_F_N51 PEE)
2089: INDEX(PAY_ELEMENT_ENTRY_VALUES_F_N50 PEEV1)
2090: INDEX(PAY_ELEMENT_ENTRY_VALUES_F_N50 PEEV2) */
2091: pee.element_entry_id ee_id,
2092: pee.effective_start_date ee_esd,
2093: pee.effective_end_date ee_eed,

Line 2090: INDEX(PAY_ELEMENT_ENTRY_VALUES_F_N50 PEEV2) */

2086: INDEX(PAY_LINK_INPUT_VALUES_F_N2 PLIV1)
2087: INDEX(PAY_LINK_INPUT_VALUES_F_N2 PLIV2)
2088: INDEX(PAY_ELEMENT_ENTRIES_F_N51 PEE)
2089: INDEX(PAY_ELEMENT_ENTRY_VALUES_F_N50 PEEV1)
2090: INDEX(PAY_ELEMENT_ENTRY_VALUES_F_N50 PEEV2) */
2091: pee.element_entry_id ee_id,
2092: pee.effective_start_date ee_esd,
2093: pee.effective_end_date ee_eed,
2094: peev1.screen_entry_value applied_mth,

Line 2099: pay_element_entry_values_f peev1,

2095: peev2.screen_entry_value new_std_mth_comp
2096: from pay_link_input_values_f pliv1,
2097: pay_link_input_values_f pliv2,
2098: pay_element_entries_f pee,
2099: pay_element_entry_values_f peev1,
2100: pay_element_entry_values_f peev2
2101: where pliv1.input_value_id = p_applied_mth_iv_id
2102: and pliv2.input_value_id = p_new_std_mth_comp_iv_id
2103: and pee.assignment_id = p_assignment_id

Line 2100: pay_element_entry_values_f peev2

2096: from pay_link_input_values_f pliv1,
2097: pay_link_input_values_f pliv2,
2098: pay_element_entries_f pee,
2099: pay_element_entry_values_f peev1,
2100: pay_element_entry_values_f peev2
2101: where pliv1.input_value_id = p_applied_mth_iv_id
2102: and pliv2.input_value_id = p_new_std_mth_comp_iv_id
2103: and pee.assignment_id = p_assignment_id
2104: /* use not eed but esd to include entry data as qualification */