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 909: pay_element_entry_values_f peev,

905: '1',hoi.org_information6||hoi.org_information7||hoi.org_information8,
906: hoi.org_information9||hoi.org_information10||hoi.org_information11),1,255) EMPLOYER_ADDRESS,
907: peev.effective_end_date PREV_SWOT_TERM_DATE
908: from hr_organization_information hoi,
909: pay_element_entry_values_f peev,
910: pay_element_entries_f pee
911: where hoi.organization_id(+) = cp_itax_organization_id
912: and hoi.org_information_context(+) = 'JP_TAX_SWOT_INFO'
913: -- Previous SWOT term date

Line 1077: INDEX(TAXABLE_AMT PAY_ELEMENT_ENTRY_VALUES_F_N50)

1073:
1074: cursor csr_get_entry_values is
1075: select /*+ ORDERED
1076: NO_MERGE(entry_type_v)
1077: INDEX(TAXABLE_AMT PAY_ELEMENT_ENTRY_VALUES_F_N50)
1078: INDEX(ITAX PAY_ELEMENT_ENTRY_VALUES_F_N50)
1079: INDEX(SI_PREM PAY_ELEMENT_ENTRY_VALUES_F_N50)
1080: INDEX(MUTUAL_AID PAY_ELEMENT_ENTRY_VALUES_F_N50)
1081: INDEX(TERM_DATE PAY_ELEMENT_ENTRY_VALUES_F_N50)

Line 1078: INDEX(ITAX PAY_ELEMENT_ENTRY_VALUES_F_N50)

1074: cursor csr_get_entry_values is
1075: select /*+ ORDERED
1076: NO_MERGE(entry_type_v)
1077: INDEX(TAXABLE_AMT PAY_ELEMENT_ENTRY_VALUES_F_N50)
1078: INDEX(ITAX PAY_ELEMENT_ENTRY_VALUES_F_N50)
1079: INDEX(SI_PREM PAY_ELEMENT_ENTRY_VALUES_F_N50)
1080: INDEX(MUTUAL_AID PAY_ELEMENT_ENTRY_VALUES_F_N50)
1081: INDEX(TERM_DATE PAY_ELEMENT_ENTRY_VALUES_F_N50)
1082: INDEX(ADDR PAY_ELEMENT_ENTRY_VALUES_F_N50)

Line 1079: INDEX(SI_PREM PAY_ELEMENT_ENTRY_VALUES_F_N50)

1075: select /*+ ORDERED
1076: NO_MERGE(entry_type_v)
1077: INDEX(TAXABLE_AMT PAY_ELEMENT_ENTRY_VALUES_F_N50)
1078: INDEX(ITAX PAY_ELEMENT_ENTRY_VALUES_F_N50)
1079: INDEX(SI_PREM PAY_ELEMENT_ENTRY_VALUES_F_N50)
1080: INDEX(MUTUAL_AID PAY_ELEMENT_ENTRY_VALUES_F_N50)
1081: INDEX(TERM_DATE PAY_ELEMENT_ENTRY_VALUES_F_N50)
1082: INDEX(ADDR PAY_ELEMENT_ENTRY_VALUES_F_N50)
1083: INDEX(EMPLOYER_NAME PAY_ELEMENT_ENTRY_VALUES_F_N50) */

Line 1080: INDEX(MUTUAL_AID PAY_ELEMENT_ENTRY_VALUES_F_N50)

1076: NO_MERGE(entry_type_v)
1077: INDEX(TAXABLE_AMT PAY_ELEMENT_ENTRY_VALUES_F_N50)
1078: INDEX(ITAX PAY_ELEMENT_ENTRY_VALUES_F_N50)
1079: INDEX(SI_PREM PAY_ELEMENT_ENTRY_VALUES_F_N50)
1080: INDEX(MUTUAL_AID PAY_ELEMENT_ENTRY_VALUES_F_N50)
1081: INDEX(TERM_DATE PAY_ELEMENT_ENTRY_VALUES_F_N50)
1082: INDEX(ADDR PAY_ELEMENT_ENTRY_VALUES_F_N50)
1083: INDEX(EMPLOYER_NAME PAY_ELEMENT_ENTRY_VALUES_F_N50) */
1084: nvl(taxable_amt.screen_entry_value,0) PJOB_TAXABLE_AMT,

Line 1081: INDEX(TERM_DATE PAY_ELEMENT_ENTRY_VALUES_F_N50)

1077: INDEX(TAXABLE_AMT PAY_ELEMENT_ENTRY_VALUES_F_N50)
1078: INDEX(ITAX PAY_ELEMENT_ENTRY_VALUES_F_N50)
1079: INDEX(SI_PREM PAY_ELEMENT_ENTRY_VALUES_F_N50)
1080: INDEX(MUTUAL_AID PAY_ELEMENT_ENTRY_VALUES_F_N50)
1081: INDEX(TERM_DATE PAY_ELEMENT_ENTRY_VALUES_F_N50)
1082: INDEX(ADDR PAY_ELEMENT_ENTRY_VALUES_F_N50)
1083: INDEX(EMPLOYER_NAME PAY_ELEMENT_ENTRY_VALUES_F_N50) */
1084: nvl(taxable_amt.screen_entry_value,0) PJOB_TAXABLE_AMT,
1085: nvl(itax.screen_entry_value,0) PJOB_ITAX,

Line 1082: INDEX(ADDR PAY_ELEMENT_ENTRY_VALUES_F_N50)

1078: INDEX(ITAX PAY_ELEMENT_ENTRY_VALUES_F_N50)
1079: INDEX(SI_PREM PAY_ELEMENT_ENTRY_VALUES_F_N50)
1080: INDEX(MUTUAL_AID PAY_ELEMENT_ENTRY_VALUES_F_N50)
1081: INDEX(TERM_DATE PAY_ELEMENT_ENTRY_VALUES_F_N50)
1082: INDEX(ADDR PAY_ELEMENT_ENTRY_VALUES_F_N50)
1083: INDEX(EMPLOYER_NAME PAY_ELEMENT_ENTRY_VALUES_F_N50) */
1084: nvl(taxable_amt.screen_entry_value,0) PJOB_TAXABLE_AMT,
1085: nvl(itax.screen_entry_value,0) PJOB_ITAX,
1086: nvl(si_prem.screen_entry_value,0) PJOB_SI_PREM,

Line 1083: INDEX(EMPLOYER_NAME PAY_ELEMENT_ENTRY_VALUES_F_N50) */

1079: INDEX(SI_PREM PAY_ELEMENT_ENTRY_VALUES_F_N50)
1080: INDEX(MUTUAL_AID PAY_ELEMENT_ENTRY_VALUES_F_N50)
1081: INDEX(TERM_DATE PAY_ELEMENT_ENTRY_VALUES_F_N50)
1082: INDEX(ADDR PAY_ELEMENT_ENTRY_VALUES_F_N50)
1083: INDEX(EMPLOYER_NAME PAY_ELEMENT_ENTRY_VALUES_F_N50) */
1084: nvl(taxable_amt.screen_entry_value,0) PJOB_TAXABLE_AMT,
1085: nvl(itax.screen_entry_value,0) PJOB_ITAX,
1086: nvl(si_prem.screen_entry_value,0) PJOB_SI_PREM,
1087: nvl(mutual_aid.screen_entry_value,0) PJOB_MUTUAL_AID,

Line 1104: pay_element_entry_values_f taxable_amt,

1100: and pelf.element_type_id = petf.element_type_id
1101: and pelf.business_group_id +0 = p_business_group_id
1102: and peef.element_link_id = pelf.element_link_id
1103: and peef.assignment_id = p_assignment_id) entry_type_v,
1104: pay_element_entry_values_f taxable_amt,
1105: pay_element_entry_values_f itax,
1106: pay_element_entry_values_f si_prem,
1107: pay_element_entry_values_f mutual_aid,
1108: pay_element_entry_values_f term_date,

Line 1105: pay_element_entry_values_f itax,

1101: and pelf.business_group_id +0 = p_business_group_id
1102: and peef.element_link_id = pelf.element_link_id
1103: and peef.assignment_id = p_assignment_id) entry_type_v,
1104: pay_element_entry_values_f taxable_amt,
1105: pay_element_entry_values_f itax,
1106: pay_element_entry_values_f si_prem,
1107: pay_element_entry_values_f mutual_aid,
1108: pay_element_entry_values_f term_date,
1109: pay_element_entry_values_f addr,

Line 1106: pay_element_entry_values_f si_prem,

1102: and peef.element_link_id = pelf.element_link_id
1103: and peef.assignment_id = p_assignment_id) entry_type_v,
1104: pay_element_entry_values_f taxable_amt,
1105: pay_element_entry_values_f itax,
1106: pay_element_entry_values_f si_prem,
1107: pay_element_entry_values_f mutual_aid,
1108: pay_element_entry_values_f term_date,
1109: pay_element_entry_values_f addr,
1110: pay_element_entry_values_f employer_name

Line 1107: pay_element_entry_values_f mutual_aid,

1103: and peef.assignment_id = p_assignment_id) entry_type_v,
1104: pay_element_entry_values_f taxable_amt,
1105: pay_element_entry_values_f itax,
1106: pay_element_entry_values_f si_prem,
1107: pay_element_entry_values_f mutual_aid,
1108: pay_element_entry_values_f term_date,
1109: pay_element_entry_values_f addr,
1110: pay_element_entry_values_f employer_name
1111: where taxable_amt.element_entry_id = entry_type_v.element_entry_id

Line 1108: pay_element_entry_values_f term_date,

1104: pay_element_entry_values_f taxable_amt,
1105: pay_element_entry_values_f itax,
1106: pay_element_entry_values_f si_prem,
1107: pay_element_entry_values_f mutual_aid,
1108: pay_element_entry_values_f term_date,
1109: pay_element_entry_values_f addr,
1110: pay_element_entry_values_f employer_name
1111: where taxable_amt.element_entry_id = entry_type_v.element_entry_id
1112: and taxable_amt.input_value_id = p_taxable_amt_iv_id

Line 1109: pay_element_entry_values_f addr,

1105: pay_element_entry_values_f itax,
1106: pay_element_entry_values_f si_prem,
1107: pay_element_entry_values_f mutual_aid,
1108: pay_element_entry_values_f term_date,
1109: pay_element_entry_values_f addr,
1110: pay_element_entry_values_f employer_name
1111: where taxable_amt.element_entry_id = entry_type_v.element_entry_id
1112: and taxable_amt.input_value_id = p_taxable_amt_iv_id
1113: and p_effective_date

Line 1110: pay_element_entry_values_f employer_name

1106: pay_element_entry_values_f si_prem,
1107: pay_element_entry_values_f mutual_aid,
1108: pay_element_entry_values_f term_date,
1109: pay_element_entry_values_f addr,
1110: pay_element_entry_values_f employer_name
1111: where taxable_amt.element_entry_id = entry_type_v.element_entry_id
1112: and taxable_amt.input_value_id = p_taxable_amt_iv_id
1113: and p_effective_date
1114: between taxable_amt.effective_start_date and taxable_amt.effective_end_date

Line 2080: INDEX(PAY_ELEMENT_ENTRY_VALUES_F_N50 PEEV1)

2076: USE_NL(PLIV1, PLIV2, PEE, PEEV1, PEEV2)
2077: INDEX(PAY_LINK_INPUT_VALUES_F_N2 PLIV1)
2078: INDEX(PAY_LINK_INPUT_VALUES_F_N2 PLIV2)
2079: INDEX(PAY_ELEMENT_ENTRIES_F_N51 PEE)
2080: INDEX(PAY_ELEMENT_ENTRY_VALUES_F_N50 PEEV1)
2081: INDEX(PAY_ELEMENT_ENTRY_VALUES_F_N50 PEEV2) */
2082: pee.element_entry_id ee_id,
2083: pee.effective_start_date ee_esd,
2084: pee.effective_end_date ee_eed,

Line 2081: INDEX(PAY_ELEMENT_ENTRY_VALUES_F_N50 PEEV2) */

2077: INDEX(PAY_LINK_INPUT_VALUES_F_N2 PLIV1)
2078: INDEX(PAY_LINK_INPUT_VALUES_F_N2 PLIV2)
2079: INDEX(PAY_ELEMENT_ENTRIES_F_N51 PEE)
2080: INDEX(PAY_ELEMENT_ENTRY_VALUES_F_N50 PEEV1)
2081: INDEX(PAY_ELEMENT_ENTRY_VALUES_F_N50 PEEV2) */
2082: pee.element_entry_id ee_id,
2083: pee.effective_start_date ee_esd,
2084: pee.effective_end_date ee_eed,
2085: peev1.screen_entry_value applied_mth,

Line 2090: pay_element_entry_values_f peev1,

2086: peev2.screen_entry_value new_std_mth_comp
2087: from pay_link_input_values_f pliv1,
2088: pay_link_input_values_f pliv2,
2089: pay_element_entries_f pee,
2090: pay_element_entry_values_f peev1,
2091: pay_element_entry_values_f peev2
2092: where pliv1.input_value_id = p_applied_mth_iv_id
2093: and pliv2.input_value_id = p_new_std_mth_comp_iv_id
2094: and pee.assignment_id = p_assignment_id

Line 2091: pay_element_entry_values_f peev2

2087: from pay_link_input_values_f pliv1,
2088: pay_link_input_values_f pliv2,
2089: pay_element_entries_f pee,
2090: pay_element_entry_values_f peev1,
2091: pay_element_entry_values_f peev2
2092: where pliv1.input_value_id = p_applied_mth_iv_id
2093: and pliv2.input_value_id = p_new_std_mth_comp_iv_id
2094: and pee.assignment_id = p_assignment_id
2095: /* use not eed but esd to include entry data as qualification */