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_F

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 3216: ,pay_element_entry_values_f peev

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

Line 3235: FROM pay_element_entry_values_f peev

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

Line 3245: l_loan_number pay_element_entry_values_f.screen_entry_value%TYPE;

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

Line 3246: l_loan_type pay_element_entry_values_f.screen_entry_value%TYPE;

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

Line 3411: ,pay_element_entry_values_f peev

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

Line 3430: FROM pay_element_entry_values_f peev

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

Line 3440: l_loan_number pay_element_entry_values_f.screen_entry_value%TYPE;

3436: AND peev.effective_end_date
3437: AND p_actual_termination_date BETWEEN piv.effective_start_date
3438: AND piv.effective_end_date;
3439:
3440: l_loan_number pay_element_entry_values_f.screen_entry_value%TYPE;
3441: l_loan_type pay_element_entry_values_f.screen_entry_value%TYPE;
3442:
3443:
3444: BEGIN

Line 3441: l_loan_type pay_element_entry_values_f.screen_entry_value%TYPE;

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