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_INPUT_VALUES_F

Line 29: (input_name pay_input_values_f.name%TYPE

25: g_gratuity_et CONSTANT VARCHAR2(80):= 'Gratuity Information';
26: g_gratuity_cn CONSTANT VARCHAR2(80):= 'Gratuity';
27:
28: TYPE t_input_values_rec IS RECORD
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);

Line 30: ,input_value_id pay_input_values_f.input_value_id%TYPE);

26: g_gratuity_cn CONSTANT VARCHAR2(80):= 'Gratuity';
27:
28: TYPE t_input_values_rec IS RECORD
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:

Line 207: ,pay_input_values_f piv

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
211: AND piv.name = 'Forfeiture Amount'

Line 227: ,pay_input_values_f piv

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
231: AND piv.name = 'Forfeiture Reason'

Line 690: , pay_input_values_f inputs

686: IS
687: SELECT inputs.name
688: , inputs.input_value_id
689: FROM pay_element_types_f types
690: , pay_input_values_f inputs
691: WHERE types.element_type_id = p_element_type_id
692: AND inputs.element_type_id = types.element_type_id
693: AND (inputs.legislation_code = g_legislation_code OR inputs.business_group_id = p_business_group_id)
694: AND p_effective_date BETWEEN types.effective_start_date

Line 1206: ,pay_input_values_f piv

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
1210: AND pev.input_value_id = piv.input_value_id

Line 1397: pay_input_values_f piv

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'
1401: AND pet.element_type_id = piv.element_type_id

Line 2746: pay_input_values_f piv,

2742: FROM pay_element_types_f pet,
2743: pay_element_classifications pec,
2744: pay_balance_feeds_f pbf,
2745: pay_balance_types pbt,
2746: pay_input_values_f piv,
2747: pay_input_values_f piv1,
2748: pay_element_types_f pet2
2749: WHERE pet.classification_id = pec.classification_id
2750: AND pec.classification_name = 'Voluntary Deductions'

Line 2747: pay_input_values_f piv1,

2743: pay_element_classifications pec,
2744: pay_balance_feeds_f pbf,
2745: pay_balance_types pbt,
2746: pay_input_values_f piv,
2747: pay_input_values_f piv1,
2748: pay_element_types_f pet2
2749: WHERE pet.classification_id = pec.classification_id
2750: AND pec.classification_name = 'Voluntary Deductions'
2751: AND pec.legislation_code = 'IN'

Line 3218: ,pay_input_values_f piv

3214:
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

Line 3239: ,pay_input_values_f piv

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
3243: AND p_actual_termination_date BETWEEN peev.effective_start_date

Line 3413: ,pay_input_values_f piv

3409:
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

Line 3434: ,pay_input_values_f piv

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
3438: AND p_actual_termination_date BETWEEN peev.effective_start_date