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:
11: -- Global record definition

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:
11: -- Global record definition
12: g_old_rec pay_element_entries_f%ROWTYPE;

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:
11: -- Global record definition
12: g_old_rec pay_element_entries_f%ROWTYPE;
13:

Line 72: l_element_name pay_element_types_f.element_name%TYPE;

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

Line 95: ) return PAY_ELEMENT_TYPES_F%ROWTYPE

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

Line 99: l_element_type_rec pay_element_types_f%rowtype;

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

Line 106: from pay_element_types_f pet

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

Line 151: l_elm_rec pay_element_types_f%ROWTYPE;

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

Line 323: l_element_type_rec pay_element_types_f%rowtype;

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

Line 531: from pay_element_types_f pet,

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

Line 764: l_processing_type pay_element_types_f.processing_type%TYPE;

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

Line 769: from pay_element_types_f pet,

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

Line 850: l_processing_type pay_element_types_f.processing_type%TYPE;

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

Line 857: from pay_element_types_f pet,

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