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_TYPES_F

Line 17: c_com_hi_smr_info_elm pay_element_types_f.element_name%type := 'COM_HI_SMR_INFO';

13: g_husband_user_name fnd_new_messages.message_text%type := fnd_message.get_string('PAY','PAY_JP_HUSBAND');
14: g_wife_user_name fnd_new_messages.message_text%type := fnd_message.get_string('PAY','PAY_JP_WIFE');
15: --
16: c_legislation_code varchar2(2) := 'JP';
17: c_com_hi_smr_info_elm pay_element_types_f.element_name%type := 'COM_HI_SMR_INFO';
18: c_com_wp_smr_info_elm pay_element_types_f.element_name%type := 'COM_WP_SMR_INFO';
19: c_appl_mth_iv pay_input_values_f.name%type := 'APPLY_MTH';
20: c_appl_cat_iv pay_input_values_f.name%type := 'APPLY_TYPE';
21: c_com_si_info_elm pay_element_types_f.element_name%type := 'COM_SI_INFO';

Line 18: c_com_wp_smr_info_elm pay_element_types_f.element_name%type := 'COM_WP_SMR_INFO';

14: g_wife_user_name fnd_new_messages.message_text%type := fnd_message.get_string('PAY','PAY_JP_WIFE');
15: --
16: c_legislation_code varchar2(2) := 'JP';
17: c_com_hi_smr_info_elm pay_element_types_f.element_name%type := 'COM_HI_SMR_INFO';
18: c_com_wp_smr_info_elm pay_element_types_f.element_name%type := 'COM_WP_SMR_INFO';
19: c_appl_mth_iv pay_input_values_f.name%type := 'APPLY_MTH';
20: c_appl_cat_iv pay_input_values_f.name%type := 'APPLY_TYPE';
21: c_com_si_info_elm pay_element_types_f.element_name%type := 'COM_SI_INFO';
22: c_hi_org_iv pay_input_values_f.name%type := 'HI_LOCATION';

Line 21: c_com_si_info_elm pay_element_types_f.element_name%type := 'COM_SI_INFO';

17: c_com_hi_smr_info_elm pay_element_types_f.element_name%type := 'COM_HI_SMR_INFO';
18: c_com_wp_smr_info_elm pay_element_types_f.element_name%type := 'COM_WP_SMR_INFO';
19: c_appl_mth_iv pay_input_values_f.name%type := 'APPLY_MTH';
20: c_appl_cat_iv pay_input_values_f.name%type := 'APPLY_TYPE';
21: c_com_si_info_elm pay_element_types_f.element_name%type := 'COM_SI_INFO';
22: c_hi_org_iv pay_input_values_f.name%type := 'HI_LOCATION';
23: c_wp_org_iv pay_input_values_f.name%type := 'WP_LOCATION';
24: c_wpf_org_iv pay_input_values_f.name%type := 'WPF_LOCATION';
25: c_hi_num_iv pay_input_values_f.name%type := 'HI_CARD_NUM';

Line 28: c_com_si_rep_elm pay_element_types_f.element_name%type := 'COM_SI_REPORT_INFO';

24: c_wpf_org_iv pay_input_values_f.name%type := 'WPF_LOCATION';
25: c_hi_num_iv pay_input_values_f.name%type := 'HI_CARD_NUM';
26: c_wp_num_iv pay_input_values_f.name%type := 'WP_SERIAL_NUM';
27: c_bp_num_iv pay_input_values_f.name%type := 'BASIC_PENSION_NUM';
28: c_com_si_rep_elm pay_element_types_f.element_name%type := 'COM_SI_REPORT_INFO';
29: c_exc_iv pay_input_values_f.name%type := 'OUTPUT_FLAG';
30: c_san_ele_set pay_element_sets.element_set_name%type := 'SAN';
31: c_gep_ele_set pay_element_sets.element_set_name%type := 'GEP';
32: c_iku_ele_set pay_element_sets.element_set_name%type := 'IKU';

Line 34: c_com_hi_q_info_elm pay_element_types_f.element_name%type := 'COM_HI_QUALIFY_INFO';

30: c_san_ele_set pay_element_sets.element_set_name%type := 'SAN';
31: c_gep_ele_set pay_element_sets.element_set_name%type := 'GEP';
32: c_iku_ele_set pay_element_sets.element_set_name%type := 'IKU';
33: --
34: c_com_hi_q_info_elm pay_element_types_f.element_name%type := 'COM_HI_QUALIFY_INFO';
35: c_com_wp_q_info_elm pay_element_types_f.element_name%type := 'COM_WP_QUALIFY_INFO';
36: c_com_wpf_q_info_elm pay_element_types_f.element_name%type := 'COM_WPF_QUALIFY_INFO';
37: c_qd_iv pay_input_values_f.name%type := 'QUALIFY_DATE';
38: c_dqd_iv pay_input_values_f.name%type := 'DISQUALIFY_DATE';

Line 35: c_com_wp_q_info_elm pay_element_types_f.element_name%type := 'COM_WP_QUALIFY_INFO';

31: c_gep_ele_set pay_element_sets.element_set_name%type := 'GEP';
32: c_iku_ele_set pay_element_sets.element_set_name%type := 'IKU';
33: --
34: c_com_hi_q_info_elm pay_element_types_f.element_name%type := 'COM_HI_QUALIFY_INFO';
35: c_com_wp_q_info_elm pay_element_types_f.element_name%type := 'COM_WP_QUALIFY_INFO';
36: c_com_wpf_q_info_elm pay_element_types_f.element_name%type := 'COM_WPF_QUALIFY_INFO';
37: c_qd_iv pay_input_values_f.name%type := 'QUALIFY_DATE';
38: c_dqd_iv pay_input_values_f.name%type := 'DISQUALIFY_DATE';
39: --

Line 36: c_com_wpf_q_info_elm pay_element_types_f.element_name%type := 'COM_WPF_QUALIFY_INFO';

32: c_iku_ele_set pay_element_sets.element_set_name%type := 'IKU';
33: --
34: c_com_hi_q_info_elm pay_element_types_f.element_name%type := 'COM_HI_QUALIFY_INFO';
35: c_com_wp_q_info_elm pay_element_types_f.element_name%type := 'COM_WP_QUALIFY_INFO';
36: c_com_wpf_q_info_elm pay_element_types_f.element_name%type := 'COM_WPF_QUALIFY_INFO';
37: c_qd_iv pay_input_values_f.name%type := 'QUALIFY_DATE';
38: c_dqd_iv pay_input_values_f.name%type := 'DISQUALIFY_DATE';
39: --
40: c_hi_number varchar2(20) := 'HI_NUMBER';

Line 1101: INDEX(PETF PAY_ELEMENT_TYPES_F_PK)

1097: fnd_date.canonical_to_date(term_date.screen_entry_value) PJOB_TERM_DATE,
1098: addr.screen_entry_value PJOB_ADDR,
1099: employer_name.screen_entry_value PJOB_EMPLOYER_NAME
1100: from (select /*+ ORDERED
1101: INDEX(PETF PAY_ELEMENT_TYPES_F_PK)
1102: INDEX(PELF PAY_ELEMENT_LINKS_F_N7)
1103: INDEX(PEEF PAY_ELEMENT_ENTRIES_F_N51) */
1104: peef.element_entry_id
1105: from pay_element_types_f petf,

Line 1105: from pay_element_types_f petf,

1101: INDEX(PETF PAY_ELEMENT_TYPES_F_PK)
1102: INDEX(PELF PAY_ELEMENT_LINKS_F_N7)
1103: INDEX(PEEF PAY_ELEMENT_ENTRIES_F_N51) */
1104: peef.element_entry_id
1105: from pay_element_types_f petf,
1106: pay_element_links_f pelf,
1107: pay_element_entries_f peef
1108: where petf.element_type_id = p_pjob_ele_type_id
1109: and pelf.element_type_id = petf.element_type_id

Line 2282: l_user_elm_name pay_element_types_f_tl.element_name%type;

2278: function get_user_elm_name(p_base_elm_name in varchar2)
2279: return varchar2
2280: is
2281: --
2282: l_user_elm_name pay_element_types_f_tl.element_name%type;
2283: --
2284: cursor csr_user_elm_name
2285: is
2286: select pett.element_name

Line 2287: from pay_element_types_f pet,

2283: --
2284: cursor csr_user_elm_name
2285: is
2286: select pett.element_name
2287: from pay_element_types_f pet,
2288: pay_element_types_f_tl pett
2289: where pet.element_name = p_base_elm_name
2290: and pett.element_type_id = pet.element_type_id
2291: and pett.language = userenv('LANG');

Line 2288: pay_element_types_f_tl pett

2284: cursor csr_user_elm_name
2285: is
2286: select pett.element_name
2287: from pay_element_types_f pet,
2288: pay_element_types_f_tl pett
2289: where pet.element_name = p_base_elm_name
2290: and pett.element_type_id = pet.element_type_id
2291: and pett.language = userenv('LANG');
2292: --