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 2743: pay_input_values_f piv,

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

Line 2744: pay_input_values_f piv1,

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

Line 3215: ,pay_input_values_f piv

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

Line 3236: ,pay_input_values_f piv

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

Line 3410: ,pay_input_values_f piv

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

Line 3431: ,pay_input_values_f piv

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