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.PER_IN_PERQUISITE_PKG dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 42: FROM pay_element_entry_values_f peev

38: ,p_element_type_id NUMBER)
39: IS
40: SELECT peev.screen_entry_value,
41: peev.element_entry_value_id
42: FROM pay_element_entry_values_f peev
43: ,pay_input_values_f piv
44: WHERE peev.element_entry_id = p_element_entry_id
45: AND piv.name = p_input_name
46: AND peev.input_value_id = piv.input_value_id

Line 85: ,pay_element_entry_values_f peev1

81: IS
82: SELECT pee.element_entry_id
83: ,pee.effective_start_date
84: FROM pay_element_entries_f pee
85: ,pay_element_entry_values_f peev1
86: ,pay_element_entry_values_f peev2
87: ,pay_element_entry_values_f peev3
88: WHERE pee.assignment_id = p_assignment_id
89: AND pee.element_type_id = p_element_type_id

Line 86: ,pay_element_entry_values_f peev2

82: SELECT pee.element_entry_id
83: ,pee.effective_start_date
84: FROM pay_element_entries_f pee
85: ,pay_element_entry_values_f peev1
86: ,pay_element_entry_values_f peev2
87: ,pay_element_entry_values_f peev3
88: WHERE pee.assignment_id = p_assignment_id
89: AND pee.element_type_id = p_element_type_id
90: and pee.element_entry_id =peev1.element_entry_id

Line 87: ,pay_element_entry_values_f peev3

83: ,pee.effective_start_date
84: FROM pay_element_entries_f pee
85: ,pay_element_entry_values_f peev1
86: ,pay_element_entry_values_f peev2
87: ,pay_element_entry_values_f peev3
88: WHERE pee.assignment_id = p_assignment_id
89: AND pee.element_type_id = p_element_type_id
90: and pee.element_entry_id =peev1.element_entry_id
91: AND peev1.input_value_id = p_input_value_id

Line 111: FROM pay_element_entry_values_f peev

107: CURSOR c_element_entry_values(p_el_entry_id NUMBER
108: ,p_inp_value_id NUMBER
109: ,p_eff_start_date DATE) IS
110: SELECT peev.screen_entry_value
111: FROM pay_element_entry_values_f peev
112: WHERE peev.element_entry_id = p_el_entry_id
113: AND peev.input_value_id = p_inp_value_id
114: AND p_eff_start_date BETWEEN peev.effective_start_date AND peev.effective_end_date;
115:

Line 133: l_dep_value1 pay_element_entry_values_f.screen_entry_value%TYPE;

129:
130: l_get_migrator_status VARCHAR2(1);
131: l_procedure VARCHAR2(100);
132:
133: l_dep_value1 pay_element_entry_values_f.screen_entry_value%TYPE;
134: l_dep_value2 pay_element_entry_values_f.screen_entry_value%TYPE;
135:
136: TYPE tab_input_value_id IS TABLE OF pay_input_values_f.input_value_id%TYPE INDEX BY BINARY_INTEGER;
137: l_input_value_id tab_input_value_id;

Line 134: l_dep_value2 pay_element_entry_values_f.screen_entry_value%TYPE;

130: l_get_migrator_status VARCHAR2(1);
131: l_procedure VARCHAR2(100);
132:
133: l_dep_value1 pay_element_entry_values_f.screen_entry_value%TYPE;
134: l_dep_value2 pay_element_entry_values_f.screen_entry_value%TYPE;
135:
136: TYPE tab_input_value_id IS TABLE OF pay_input_values_f.input_value_id%TYPE INDEX BY BINARY_INTEGER;
137: l_input_value_id tab_input_value_id;
138:

Line 139: TYPE tab_element_entry_value IS TABLE OF pay_element_entry_values_f.screen_entry_value%TYPE INDEX BY BINARY_INTEGER;

135:
136: TYPE tab_input_value_id IS TABLE OF pay_input_values_f.input_value_id%TYPE INDEX BY BINARY_INTEGER;
137: l_input_value_id tab_input_value_id;
138:
139: TYPE tab_element_entry_value IS TABLE OF pay_element_entry_values_f.screen_entry_value%TYPE INDEX BY BINARY_INTEGER;
140: l_element_entry_value tab_element_entry_value;
141:
142: TYPE tab_element_entry_id IS TABLE OF pay_element_entries_f.element_entry_id%TYPE INDEX BY BINARY_INTEGER;
143: l_element_entry_id tab_element_entry_id;

Line 181: l_benefit_start_date pay_element_entry_values_f.screen_entry_value%TYPE;

177: ---------------------------------------------------------------------------
178:
179: PROCEDURE check_benefit_dates(l_element_entry_id number)
180: IS
181: l_benefit_start_date pay_element_entry_values_f.screen_entry_value%TYPE;
182: l_benefit_end_date pay_element_entry_values_f.screen_entry_value%TYPE;
183: l_procedure VARCHAR2(100);
184: BEGIN
185:

Line 182: l_benefit_end_date pay_element_entry_values_f.screen_entry_value%TYPE;

178:
179: PROCEDURE check_benefit_dates(l_element_entry_id number)
180: IS
181: l_benefit_start_date pay_element_entry_values_f.screen_entry_value%TYPE;
182: l_benefit_end_date pay_element_entry_values_f.screen_entry_value%TYPE;
183: l_procedure VARCHAR2(100);
184: BEGIN
185:
186: g_debug := hr_utility.debug_enabled ;

Line 212: UPDATE pay_element_entry_values_f

208: pay_in_utils.trace('l_entry_value_id : ',l_entry_value_id);
209: end if;
210: IF l_benefit_start_date IS NULL THEN
211: pay_in_utils.set_location(g_debug,l_procedure,30);
212: UPDATE pay_element_entry_values_f
213: SET screen_entry_value = to_char(p_effective_start_date,'YYYY/MM/DD HH24:MI:SS')
214: WHERE element_entry_value_id =l_entry_value_id
215: AND effective_start_date =p_effective_start_date;
216: END IF;

Line 285: l_loan_type pay_element_entry_values_f.screen_entry_value%TYPE;

281: l_curr_principal_amt NUMBER;
282: l_loan_input_value_id tab_input_value_id;
283: l_tax_input_value_id tab_input_value_id;
284: l_procedure VARCHAR2(100);
285: l_loan_type pay_element_entry_values_f.screen_entry_value%TYPE;
286: l_loan_interest_type pay_element_entry_values_f.screen_entry_value%TYPE;
287:
288: BEGIN
289:

Line 286: l_loan_interest_type pay_element_entry_values_f.screen_entry_value%TYPE;

282: l_loan_input_value_id tab_input_value_id;
283: l_tax_input_value_id tab_input_value_id;
284: l_procedure VARCHAR2(100);
285: l_loan_type pay_element_entry_values_f.screen_entry_value%TYPE;
286: l_loan_interest_type pay_element_entry_values_f.screen_entry_value%TYPE;
287:
288: BEGIN
289:
290: g_debug := hr_utility.debug_enabled;

Line 546: UPDATE pay_element_entry_values_f peev

542: pay_in_utils.set_location(g_debug,
543: 'Changing the following entries : ' ||
544: l_element_entry_id(j),
545: 70);
546: UPDATE pay_element_entry_values_f peev
547: SET peev.screen_entry_value = 'Y'
548: WHERE peev.element_entry_id = l_element_entry_id(j)
549: AND peev.input_value_id = l_tax_input_value_id(j)
550: AND p_effective_date BETWEEN peev.effective_start_date and

Line 561: UPDATE pay_element_entry_values_f peev

557: pay_in_utils.set_location(g_debug,
558: 'Changing the following entries : ' ||
559: l_element_entry_id(j),
560: 80);
561: UPDATE pay_element_entry_values_f peev
562: SET peev.screen_entry_value = 'N'
563: WHERE peev.element_entry_id = l_element_entry_id(j)
564: AND peev.input_value_id = l_tax_input_value_id(j)
565: AND p_effective_date BETWEEN peev.effective_start_date and

Line 635: l_benefit_start pay_element_entry_values_f.screen_entry_value%TYPE;

631: l_procedure VARCHAR2(100);
632: p_input_value_id_start number;
633: p_input_value_id_end number;
634:
635: l_benefit_start pay_element_entry_values_f.screen_entry_value%TYPE;
636: l_benefit_end pay_element_entry_values_f.screen_entry_value%TYPE;
637: l_benefit_start_date date;
638: l_benefit_end_date date;
639: l_type_automotive pay_element_entry_values_f.screen_entry_value%TYPE;

Line 636: l_benefit_end pay_element_entry_values_f.screen_entry_value%TYPE;

632: p_input_value_id_start number;
633: p_input_value_id_end number;
634:
635: l_benefit_start pay_element_entry_values_f.screen_entry_value%TYPE;
636: l_benefit_end pay_element_entry_values_f.screen_entry_value%TYPE;
637: l_benefit_start_date date;
638: l_benefit_end_date date;
639: l_type_automotive pay_element_entry_values_f.screen_entry_value%TYPE;
640:

Line 639: l_type_automotive pay_element_entry_values_f.screen_entry_value%TYPE;

635: l_benefit_start pay_element_entry_values_f.screen_entry_value%TYPE;
636: l_benefit_end pay_element_entry_values_f.screen_entry_value%TYPE;
637: l_benefit_start_date date;
638: l_benefit_end_date date;
639: l_type_automotive pay_element_entry_values_f.screen_entry_value%TYPE;
640:
641: BEGIN
642:
643: l_procedure := g_package ||'check_motorcar_entry';

Line 897: ,pay_element_entry_values_f peev1

893: ,p_prev_block VARCHAR2)
894: IS
895: SELECT count(*)
896: FROM pay_element_entries_f pee
897: ,pay_element_entry_values_f peev1
898: ,pay_element_entry_values_f peev2
899: WHERE pee.assignment_id = p_assignment_id
900: AND pee.element_type_id = p_element_Type_id
901: AND peev1.input_value_id = p_value_input

Line 898: ,pay_element_entry_values_f peev2

894: IS
895: SELECT count(*)
896: FROM pay_element_entries_f pee
897: ,pay_element_entry_values_f peev1
898: ,pay_element_entry_values_f peev2
899: WHERE pee.assignment_id = p_assignment_id
900: AND pee.element_type_id = p_element_Type_id
901: AND peev1.input_value_id = p_value_input
902: AND peev1.element_entry_id =peev2.element_entry_id

Line 922: ,pay_element_entry_values_f peev1

918: ,p_curr_block VARCHAR2)
919: IS
920: SELECT count(*)
921: FROM pay_element_entries_f pee
922: ,pay_element_entry_values_f peev1
923: ,pay_element_entry_values_f peev2
924: WHERE pee.assignment_id = p_assignment_id
925: AND pee.element_type_id = p_element_Type_id
926: AND peev1.input_value_id = p_value_input

Line 923: ,pay_element_entry_values_f peev2

919: IS
920: SELECT count(*)
921: FROM pay_element_entries_f pee
922: ,pay_element_entry_values_f peev1
923: ,pay_element_entry_values_f peev2
924: WHERE pee.assignment_id = p_assignment_id
925: AND pee.element_type_id = p_element_Type_id
926: AND peev1.input_value_id = p_value_input
927: AND peev1.element_entry_id =peev2.element_entry_id

Line 936: l_entry_value pay_element_entry_values_f.screen_entry_value%TYPE;

932: AND pee.effective_start_date BETWEEN p_start_date AND p_end_date
933: AND peev1.effective_start_date BETWEEN p_start_date AND p_end_date
934: AND peev2.effective_start_date BETWEEN p_start_date AND p_end_date;
935:
936: l_entry_value pay_element_entry_values_f.screen_entry_value%TYPE;
937:
938:
939: l_curr_block HR_LOOKUPS.LOOKUP_CODE%TYPE;
940: l_curr_period HR_LOOKUPS.meaning%TYPE;