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

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

Line 1412: , pay_input_values_f iv

1408: ,iv.input_value_id input_value_id
1409: ,iv.uom uom
1410: FROM pay_element_types_f et
1411: , pay_element_types_f_tl pettl
1412: , pay_input_values_f iv
1413: , pay_element_classifications classification
1414: WHERE et.element_type_id = iv.element_type_id
1415: AND et.element_type_id = pettl.element_type_id
1416: AND pettl.language = USERENV('LANG')

Line 1436: , pay_input_values_f iv

1432: ,iv.input_value_id input_value_id
1433: ,iv.uom uom
1434: FROM pay_element_types_f et
1435: , pay_element_types_f_tl pettl
1436: , pay_input_values_f iv
1437: , pay_element_classifications classification
1438: WHERE et.element_type_id = iv.element_type_id
1439: AND et.element_type_id = pettl.element_type_id
1440: AND pettl.language = USERENV('LANG')

Line 2003: ,pay_input_values_f piv

1999: ,piv.uom
2000: FROM hr_organization_information hoi
2001: ,pay_element_classifications pec
2002: ,pay_element_types_f pet
2003: ,pay_input_values_f piv
2004: WHERE hoi.organization_id = p_bus_grp_id
2005: AND hoi.org_information_context = 'Business Group:Payslip Info'
2006: AND hoi.org_information1 = 'ELEMENT'
2007: AND hoi.org_information2 = pet.element_type_id

Line 2661: ,pay_input_values_f iv1

2657: ,per_all_assignments_f asg2
2658: ,per_all_people_f per
2659: ,pay_element_links_f el
2660: ,pay_element_types_f et
2661: ,pay_input_values_f iv1
2662: ,pay_element_entries_f ee
2663: ,pay_element_entry_values_f eev1
2664: WHERE asg1.assignment_id = p_assignment_id
2665: AND p_date_earned BETWEEN asg1.effective_start_date AND asg1.effective_end_date

Line 2689: ,pay_input_values_f iv1

2685: ,eev1.screen_entry_value screen_entry_value
2686: FROM per_all_assignments_f asg1
2687: ,pay_element_links_f el
2688: ,pay_element_types_f et
2689: ,pay_input_values_f iv1
2690: ,pay_element_entries_f ee
2691: ,pay_element_entry_values_f eev1
2692: WHERE asg1.assignment_id = p_assignment_id
2693: AND p_date_earned BETWEEN asg1.effective_start_date AND asg1.effective_end_date

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

2788: l_period_type VARCHAR2(80);
2789: l_hourly_salaried per_all_assignments_f.hourly_salaried_code%TYPE ;
2790: --------------
2791: /*
2792: TYPE tax_card_rec IS RECORD (inp_val_name pay_input_values_f.NAME%type , screen_entry_val pay_input_values_f.NAME%type );
2793:
2794: TYPE bal_val_rec IS RECORD ( bal_name ff_database_items.USER_NAME%type , bal_val NUMBER(10,2) );
2795:
2796:

Line 3188: , pay_input_values_f iv

3184: ,iv.uom uom
3185: ,et.processing_priority processing_priority
3186: FROM pay_element_types_f et
3187: , pay_element_types_f_tl pettl
3188: , pay_input_values_f iv
3189: , pay_element_classifications classification
3190: WHERE et.element_type_id = iv.element_type_id
3191: AND et.element_type_id = pettl.element_type_id
3192: AND pettl.language = USERENV('LANG')

Line 3213: , pay_input_values_f iv

3209: ,iv.uom uom
3210: ,et.processing_priority processing_priority
3211: FROM pay_element_types_f et
3212: , pay_element_types_f_tl pettl
3213: , pay_input_values_f iv
3214: , pay_element_classifications classification
3215: WHERE et.element_type_id = iv.element_type_id
3216: AND et.element_type_id = pettl.element_type_id
3217: AND pettl.language = USERENV('LANG')

Line 3269: FROM pay_input_values_f piv

3265: /* Added for Pension changes */
3266: CURSOR csr_get_pen_iv_id(p_effective_date DATE
3267: ,p_element_type_id NUMBER) IS
3268: SELECT piv.input_value_id
3269: FROM pay_input_values_f piv
3270: WHERE piv.element_type_id = p_element_type_id
3271: AND piv.name= 'Third Party Payee'
3272: AND p_effective_date between piv.effective_start_date and piv.effective_end_date;
3273:

Line 3280: , pay_input_values_f iv

3276: p_run_result_id NUMBER) IS
3277: SELECT hou.name
3278: FROM
3279: pay_run_result_values rrv
3280: , pay_input_values_f iv
3281: , hr_organization_units hou
3282: WHERE rrv.run_result_id = p_run_result_id
3283: AND rrv.input_value_id = iv.input_value_id
3284: AND iv.name = 'Third Party Payee'