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_DK_ARCHIVE dependencies on PAY_INPUT_VALUES_F

Line 27: TYPE tax_card_rec IS RECORD (inp_val_name pay_input_values_f.NAME%type , screen_entry_val pay_element_entry_values_f.SCREEN_ENTRY_VALUE%type );

23: balance_type_id NUMBER);
24:
25: TYPE lock_rec IS RECORD ( archive_assact_id NUMBER);
26:
27: TYPE tax_card_rec IS RECORD (inp_val_name pay_input_values_f.NAME%type , screen_entry_val pay_element_entry_values_f.SCREEN_ENTRY_VALUE%type );
28:
29: TYPE bal_val_rec IS RECORD ( bal_name ff_database_items.USER_NAME%type , bal_val NUMBER(10,2) );
30:
31:

Line 221: ,pay_input_values_f piv

217: FROM hr_organization_information hoi
218: ,hr_organization_information code
219: ,pay_element_classifications pec
220: ,pay_element_types_f pet
221: ,pay_input_values_f piv
222: WHERE hoi.organization_id = p_bus_grp_id
223: AND hoi.org_information_context = 'Business Group:Payslip Info'
224: AND hoi.org_information1 = 'ELEMENT'
225: AND hoi.org_information2 = pet.element_type_id

Line 1427: , pay_input_values_f iv

1423: ,iv.input_value_id input_value_id
1424: ,iv.uom uom
1425: FROM pay_element_types_f et
1426: , pay_element_types_f_tl pettl
1427: , pay_input_values_f iv
1428: , pay_element_classifications classification
1429: ,hr_organization_information code
1430: WHERE et.element_type_id = iv.element_type_id
1431: AND et.element_type_id = pettl.element_type_id

Line 1458: , pay_input_values_f iv

1454: ,iv.input_value_id input_value_id
1455: ,iv.uom uom
1456: FROM pay_element_types_f et
1457: , pay_element_types_f_tl pettl
1458: , pay_input_values_f iv
1459: , pay_element_classifications classification
1460: ,hr_organization_information code
1461: WHERE et.element_type_id = iv.element_type_id
1462: AND et.element_type_id = pettl.element_type_id

Line 2031: ,pay_input_values_f piv

2027: ,piv.uom
2028: FROM hr_organization_information hoi
2029: ,pay_element_classifications pec
2030: ,pay_element_types_f pet
2031: ,pay_input_values_f piv
2032: WHERE hoi.organization_id = p_bus_grp_id
2033: AND hoi.org_information_context = 'Business Group:Payslip Info'
2034: AND hoi.org_information1 = 'ELEMENT'
2035: AND hoi.org_information2 = pet.element_type_id

Line 3103: ,pay_input_values_f iv1

3099: ,per_all_assignments_f asg2
3100: ,per_all_people_f per
3101: ,pay_element_links_f el
3102: ,pay_element_types_f et
3103: ,pay_input_values_f iv1
3104: ,pay_element_entries_f ee
3105: ,pay_element_entry_values_f eev1
3106: WHERE asg1.assignment_id = p_assignment_id
3107: AND p_date_earned BETWEEN asg1.effective_start_date AND asg1.effective_end_date

Line 3131: ,pay_input_values_f iv1

3127: ,eev1.screen_entry_value screen_entry_value
3128: FROM per_all_assignments_f asg1
3129: ,pay_element_links_f el
3130: ,pay_element_types_f et
3131: ,pay_input_values_f iv1
3132: ,pay_element_entries_f ee
3133: ,pay_element_entry_values_f eev1
3134: WHERE asg1.assignment_id = p_assignment_id
3135: AND p_date_earned BETWEEN asg1.effective_start_date AND asg1.effective_end_date

Line 3234: TYPE tax_card_rec IS RECORD (inp_val_name pay_input_values_f.NAME%type , screen_entry_val pay_input_values_f.NAME%type );

3230: l_period_type VARCHAR2(80);
3231: l_hourly_salaried per_all_assignments_f.hourly_salaried_code%TYPE ;
3232: --------------
3233: /*
3234: TYPE tax_card_rec IS RECORD (inp_val_name pay_input_values_f.NAME%type , screen_entry_val pay_input_values_f.NAME%type );
3235:
3236: TYPE bal_val_rec IS RECORD ( bal_name ff_database_items.USER_NAME%type , bal_val NUMBER(10,2) );
3237:
3238:

Line 3661: , pay_input_values_f iv

3657: ,iv.uom uom
3658: ,et.processing_priority processing_priority
3659: FROM pay_element_types_f et
3660: , pay_element_types_f_tl pettl
3661: , pay_input_values_f iv
3662: , pay_element_classifications classification
3663: WHERE et.element_type_id = iv.element_type_id
3664: AND et.element_type_id = pettl.element_type_id
3665: AND pettl.language = USERENV('LANG')

Line 3686: , pay_input_values_f iv

3682: ,iv.uom uom
3683: ,et.processing_priority processing_priority
3684: FROM pay_element_types_f et
3685: , pay_element_types_f_tl pettl
3686: , pay_input_values_f iv
3687: , pay_element_classifications classification
3688: WHERE et.element_type_id = iv.element_type_id
3689: AND et.element_type_id = pettl.element_type_id
3690: AND pettl.language = USERENV('LANG')

Line 3743: FROM pay_input_values_f piv

3739: /* Added for Pension changes */
3740: CURSOR csr_get_pen_iv_id(p_effective_date DATE
3741: ,p_element_type_id NUMBER) IS
3742: SELECT piv.input_value_id
3743: FROM pay_input_values_f piv
3744: WHERE piv.element_type_id = p_element_type_id
3745: AND piv.name= 'Third Party Payee'
3746: AND p_effective_date between piv.effective_start_date and piv.effective_end_date;
3747: -------

Line 3753: , pay_input_values_f iv

3749: p_run_result_id NUMBER) IS
3750: SELECT hou.name
3751: FROM
3752: pay_run_result_values rrv
3753: , pay_input_values_f iv
3754: , hr_organization_units hou
3755: WHERE rrv.run_result_id = p_run_result_id
3756: AND rrv.input_value_id = iv.input_value_id
3757: AND iv.name = 'Third Party Payee'