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_KR_ENTRIES_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 7: c_tax_en constant pay_element_types_f.element_name%TYPE := 'TAX';

3:
4: --
5: -- Constant values to store element name
6: --
7: c_tax_en constant pay_element_types_f.element_name%TYPE := 'TAX';
8: c_hi_prem_en constant pay_element_types_f.element_name%TYPE := 'HI_PREM';
9: c_np_prem_en constant pay_element_types_f.element_name%TYPE := 'NP_PREM';
10: c_ei_prem_en constant pay_element_types_f.element_name%TYPE := 'EI_PREM'; -- Bug 10434174
11:

Line 8: c_hi_prem_en constant pay_element_types_f.element_name%TYPE := 'HI_PREM';

4: --
5: -- Constant values to store element name
6: --
7: c_tax_en constant pay_element_types_f.element_name%TYPE := 'TAX';
8: c_hi_prem_en constant pay_element_types_f.element_name%TYPE := 'HI_PREM';
9: c_np_prem_en constant pay_element_types_f.element_name%TYPE := 'NP_PREM';
10: c_ei_prem_en constant pay_element_types_f.element_name%TYPE := 'EI_PREM'; -- Bug 10434174
11:
12: -- Global record definition

Line 9: c_np_prem_en constant pay_element_types_f.element_name%TYPE := 'NP_PREM';

5: -- Constant values to store element name
6: --
7: c_tax_en constant pay_element_types_f.element_name%TYPE := 'TAX';
8: c_hi_prem_en constant pay_element_types_f.element_name%TYPE := 'HI_PREM';
9: c_np_prem_en constant pay_element_types_f.element_name%TYPE := 'NP_PREM';
10: c_ei_prem_en constant pay_element_types_f.element_name%TYPE := 'EI_PREM'; -- Bug 10434174
11:
12: -- Global record definition
13: g_old_rec pay_element_entries_f%ROWTYPE;

Line 10: c_ei_prem_en constant pay_element_types_f.element_name%TYPE := 'EI_PREM'; -- Bug 10434174

6: --
7: c_tax_en constant pay_element_types_f.element_name%TYPE := 'TAX';
8: c_hi_prem_en constant pay_element_types_f.element_name%TYPE := 'HI_PREM';
9: c_np_prem_en constant pay_element_types_f.element_name%TYPE := 'NP_PREM';
10: c_ei_prem_en constant pay_element_types_f.element_name%TYPE := 'EI_PREM'; -- Bug 10434174
11:
12: -- Global record definition
13: g_old_rec pay_element_entries_f%ROWTYPE;
14:

Line 73: l_element_name pay_element_types_f.element_name%TYPE;

69: p_element_code in varchar2
70: )
71: return varchar2
72: is
73: l_element_name pay_element_types_f.element_name%TYPE;
74: begin
75: if p_element_code = 'TAX' then
76: l_element_name := c_tax_en;
77: elsif p_element_code = 'HI_PREM' then

Line 98: ) return PAY_ELEMENT_TYPES_F%ROWTYPE

94: (
95: p_element_name in varchar2,
96: p_business_group_id in number default null,
97: p_effective_date in date default hr_api.g_sys
98: ) return PAY_ELEMENT_TYPES_F%ROWTYPE
99: is
100:
101: l_legislation_code varchar2(30);
102: l_element_type_rec pay_element_types_f%rowtype;

Line 102: l_element_type_rec pay_element_types_f%rowtype;

98: ) return PAY_ELEMENT_TYPES_F%ROWTYPE
99: is
100:
101: l_legislation_code varchar2(30);
102: l_element_type_rec pay_element_types_f%rowtype;
103:
104: cursor csr( p_element_name varchar2,
105: p_business_group_id number,
106: p_legislation_code varchar2,

Line 109: from pay_element_types_f pet

105: p_business_group_id number,
106: p_legislation_code varchar2,
107: p_effective_date date ) is
108: select *
109: from pay_element_types_f pet
110: where pet.element_name = p_element_name
111: and p_effective_date between pet.effective_start_date
112: and pet.effective_end_date
113: and ( pet.legislation_code = p_legislation_code

Line 154: l_elm_rec pay_element_types_f%ROWTYPE;

150: )
151: is
152:
153: l_index number;
154: l_elm_rec pay_element_types_f%ROWTYPE;
155:
156: cursor csr_iv( p_element_type_id number ) is
157: select piv.input_value_id,
158: piv.display_sequence,

Line 326: l_element_type_rec pay_element_types_f%rowtype;

322: )
323: is
324:
325: l_element_type_id number;
326: l_element_type_rec pay_element_types_f%rowtype;
327: l_counter number;
328:
329: cursor csr_default_value is
330: select piv.input_value_id,

Line 534: from pay_element_types_f pet,

530: decode(piv.hot_default_flag,
531: 'Y',nvl(pliv.warning_or_error,piv.warning_or_error),
532: pliv.warning_or_error) WARNING_OR_ERROR,
533: pet.input_currency_code
534: from pay_element_types_f pet,
535: pay_input_values_f_tl pivtl,
536: pay_input_values_f piv,
537: pay_link_input_values_f pliv
538: where pliv.element_link_id = p_element_link_id

Line 767: l_processing_type pay_element_types_f.processing_type%TYPE;

763: is
764:
765: l_proc varchar2(72) := g_package||'find_dt_upd_modes';
766: l_entry_type pay_element_entries_f.entry_type%TYPE;
767: l_processing_type pay_element_types_f.processing_type%TYPE;
768:
769: cursor c_sel1 is
770: select pee.entry_type,
771: pet.processing_type

Line 772: from pay_element_types_f pet,

768:
769: cursor c_sel1 is
770: select pee.entry_type,
771: pet.processing_type
772: from pay_element_types_f pet,
773: pay_element_links_f pel,
774: pay_element_entries_f pee
775: where pee.element_entry_id = p_base_key_value
776: and p_effective_date between pee.effective_start_date

Line 853: l_processing_type pay_element_types_f.processing_type%TYPE;

849: l_proc varchar2(72) := g_package || 'find_dt_del_modes';
850: l_parent_key_value1 number;
851: l_parent_key_value2 number;
852: l_entry_type pay_element_entries_f.entry_type%TYPE;
853: l_processing_type pay_element_types_f.processing_type%TYPE;
854:
855: cursor c_sel1 is
856: select pee.assignment_id,
857: pee.element_link_id,

Line 860: from pay_element_types_f pet,

856: select pee.assignment_id,
857: pee.element_link_id,
858: pee.entry_type,
859: pet.processing_type
860: from pay_element_types_f pet,
861: pay_element_links_f pel,
862: pay_element_entries_f pee
863: where pee.element_entry_id = p_base_key_value
864: and p_effective_date between pee.effective_start_date