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_IN_TERMINATION_PKG dependencies on PAY_ELEMENT_ENTRY_VALUES

Line 33: (entry_value pay_element_entry_values.screen_entry_value%TYPE);

29: (input_name pay_input_values_f.name%TYPE
30: ,input_value_id pay_input_values_f.input_value_id%TYPE);
31:
32: TYPE t_entry_values_rec IS RECORD
33: (entry_value pay_element_entry_values.screen_entry_value%TYPE);
34:
35: TYPE t_input_values_tab IS TABLE OF t_input_values_rec
36: INDEX BY BINARY_INTEGER;
37:

Line 206: FROM pay_element_entry_values_f peev

202: ,p_element_type_id NUMBER
203: ,p_effective_date DATE)
204: IS
205: SELECT 'TRUE'
206: FROM pay_element_entry_values_f peev
207: ,pay_input_values_f piv
208: WHERE peev.element_entry_id = p_element_entry_id
209: AND piv.element_Type_id = p_element_type_id
210: AND peev.input_value_id = piv.input_value_id

Line 226: FROM pay_element_entry_values_f peev

222: ,p_element_type_id NUMBER
223: ,p_effective_date DATE)
224: IS
225: SELECT 'TRUE'
226: FROM pay_element_entry_values_f peev
227: ,pay_input_values_f piv
228: WHERE peev.element_entry_id = p_element_entry_id
229: AND piv.element_Type_id = p_element_type_id
230: AND peev.input_value_id = piv.input_value_id

Line 1205: ,pay_element_entry_values_f pev

1201: SELECT pef.element_entry_id
1202: ,pef.object_version_number
1203: ,pef.effective_start_date
1204: FROM pay_element_entries_f pef
1205: ,pay_element_entry_values_f pev
1206: ,pay_input_values_f piv
1207: WHERE pef.assignment_id = p_assignment_id
1208: AND pef.element_link_id = c_element_link_id
1209: AND pef.element_entry_id = pev.element_entry_id

Line 1396: pay_element_entry_values_f peev,

1392: ,pee.effective_start_date
1393: FROM pay_element_types_f pet,
1394: pay_element_classifications pec,
1395: pay_element_entries_f pee,
1396: pay_element_entry_values_f peev,
1397: pay_input_values_f piv
1398: WHERE pet.classification_id = pec.classification_id
1399: AND pec.classification_name = 'Information'
1400: AND pet.element_name LIKE '%Excess Advance'

Line 3219: ,pay_element_entry_values_f peev

3215: CURSOR c_ee_dtls IS
3216: SELECT pee.element_entry_id
3217: FROM pay_element_entries_f pee
3218: ,pay_input_values_f piv
3219: ,pay_element_entry_values_f peev
3220: WHERE pee.assignment_id = g_assignment_id
3221: AND pee.element_entry_id = peev.element_entry_id
3222: AND peev.input_value_id = piv.input_value_id
3223: AND piv.name = 'Component Name'

Line 3238: FROM pay_element_entry_values_f peev

3234: CURSOR c_iv_dtls (p_element_entry_id IN NUMBER
3235: , p_name IN VARCHAR2)
3236: IS
3237: SELECT peev.screen_entry_value
3238: FROM pay_element_entry_values_f peev
3239: ,pay_input_values_f piv
3240: WHERE peev.element_entry_id = p_element_entry_id
3241: AND peev.input_value_id = piv.input_value_id
3242: AND piv.NAME = p_name

Line 3248: l_loan_number pay_element_entry_values_f.screen_entry_value%TYPE;

3244: AND peev.effective_end_date
3245: AND p_actual_termination_date BETWEEN piv.effective_start_date
3246: AND piv.effective_end_date;
3247:
3248: l_loan_number pay_element_entry_values_f.screen_entry_value%TYPE;
3249: l_loan_type pay_element_entry_values_f.screen_entry_value%TYPE;
3250:
3251: l_def_bal_id pay_defined_balances.defined_balance_id%TYPE;
3252:

Line 3249: l_loan_type pay_element_entry_values_f.screen_entry_value%TYPE;

3245: AND p_actual_termination_date BETWEEN piv.effective_start_date
3246: AND piv.effective_end_date;
3247:
3248: l_loan_number pay_element_entry_values_f.screen_entry_value%TYPE;
3249: l_loan_type pay_element_entry_values_f.screen_entry_value%TYPE;
3250:
3251: l_def_bal_id pay_defined_balances.defined_balance_id%TYPE;
3252:
3253: CURSOR csr_asact_id IS

Line 3414: ,pay_element_entry_values_f peev

3410: CURSOR c_ee_dtls IS
3411: SELECT pee.element_entry_id
3412: FROM pay_element_entries_f pee
3413: ,pay_input_values_f piv
3414: ,pay_element_entry_values_f peev
3415: WHERE pee.assignment_id = g_assignment_id
3416: AND pee.element_entry_id = peev.element_entry_id
3417: AND peev.input_value_id = piv.input_value_id
3418: AND piv.name = 'Component Name'

Line 3433: FROM pay_element_entry_values_f peev

3429: CURSOR c_iv_dtls (p_element_entry_id IN NUMBER
3430: , p_name IN VARCHAR2)
3431: IS
3432: SELECT peev.screen_entry_value
3433: FROM pay_element_entry_values_f peev
3434: ,pay_input_values_f piv
3435: WHERE peev.element_entry_id = p_element_entry_id
3436: AND peev.input_value_id = piv.input_value_id
3437: AND piv.NAME = p_name

Line 3443: l_loan_number pay_element_entry_values_f.screen_entry_value%TYPE;

3439: AND peev.effective_end_date
3440: AND p_actual_termination_date BETWEEN piv.effective_start_date
3441: AND piv.effective_end_date;
3442:
3443: l_loan_number pay_element_entry_values_f.screen_entry_value%TYPE;
3444: l_loan_type pay_element_entry_values_f.screen_entry_value%TYPE;
3445:
3446:
3447: BEGIN

Line 3444: l_loan_type pay_element_entry_values_f.screen_entry_value%TYPE;

3440: AND p_actual_termination_date BETWEEN piv.effective_start_date
3441: AND piv.effective_end_date;
3442:
3443: l_loan_number pay_element_entry_values_f.screen_entry_value%TYPE;
3444: l_loan_type pay_element_entry_values_f.screen_entry_value%TYPE;
3445:
3446:
3447: BEGIN
3448: g_debug := hr_utility.debug_enabled ;