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

Line 47: 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 );

43: balance_type_id NUMBER);
44:
45: TYPE lock_rec IS RECORD ( archive_assact_id NUMBER);
46:
47: 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 );
48:
49: TYPE bal_val_rec IS RECORD ( bal_name ff_database_items.USER_NAME%type , bal_val NUMBER(10,2) );
50:
51:

Line 251: ,pay_input_values_f piv

247: ,piv.uom uom
248: FROM hr_organization_information hoi
249: ,pay_element_classifications pec
250: ,pay_element_types_f pet
251: ,pay_input_values_f piv
252: WHERE hoi.organization_id = p_bus_grp_id
253: AND hoi.org_information_context = 'Business Group:Payslip Info'
254: AND hoi.org_information1 = 'ELEMENT'
255: AND hoi.org_information2 = pet.element_type_id

Line 272: ,pay_input_values_f piv

268: ,piv.value_set_id value_set_id
269: FROM hr_organization_information hoi
270: ,pay_element_classifications pec
271: ,pay_element_types_f pet
272: ,pay_input_values_f piv
273: WHERE hoi.organization_id = p_bus_grp_id
274: AND hoi.org_information_context = 'Business Group:Payslip Info'
275: AND hoi.org_information1 = 'ELEMENT'
276: AND hoi.org_information2 = pet.element_type_id

Line 1883: , pay_input_values_f iv

1879: ,iv.input_value_id input_value_id
1880: ,iv.uom uom
1881: FROM pay_element_types_f et
1882: , pay_element_types_f_tl pettl
1883: , pay_input_values_f iv
1884: , pay_element_classifications classification
1885: WHERE et.element_type_id = iv.element_type_id
1886: AND et.element_type_id = pettl.element_type_id
1887: AND pettl.language = USERENV('LANG')

Line 1910: , pay_input_values_f iv

1906: ,iv.input_value_id input_value_id
1907: ,iv.uom uom
1908: FROM pay_element_types_f et
1909: , pay_element_types_f_tl pettl
1910: , pay_input_values_f iv
1911: , pay_element_classifications classification
1912: WHERE et.element_type_id = iv.element_type_id
1913: AND et.element_type_id = pettl.element_type_id
1914: AND pettl.language = USERENV('LANG')

Line 1938: , pay_input_values_f iv

1934: ,iv.uom uom
1935: ,classification.classification_name ele_class
1936: FROM pay_element_types_f et
1937: , pay_element_types_f_tl pettl
1938: , pay_input_values_f iv
1939: , pay_element_classifications classification
1940: WHERE et.element_type_id = iv.element_type_id
1941: AND et.element_type_id = pettl.element_type_id
1942: AND pettl.language = USERENV('LANG')

Line 1969: , pay_input_values_f iv

1965: ,iv.uom uom
1966: ,classification.classification_name ele_class
1967: FROM pay_element_types_f et
1968: , pay_element_types_f_tl pettl
1969: , pay_input_values_f iv
1970: , pay_element_classifications classification
1971: WHERE et.element_type_id = iv.element_type_id
1972: AND et.element_type_id = pettl.element_type_id
1973: AND pettl.language = USERENV('LANG')

Line 2961: ,pay_input_values_f piv

2957: ,piv.uom
2958: FROM hr_organization_information hoi
2959: ,pay_element_classifications pec
2960: ,pay_element_types_f pet
2961: ,pay_input_values_f piv
2962: WHERE hoi.organization_id = p_bus_grp_id
2963: AND hoi.org_information_context = 'Business Group:Payslip Info'
2964: AND hoi.org_information1 = 'ELEMENT'
2965: AND hoi.org_information2 = pet.element_type_id

Line 3856: ,pay_input_values_f iv1

3852: ,per_all_assignments_f asg2
3853: ,per_all_people_f per
3854: ,pay_element_links_f el
3855: ,pay_element_types_f et
3856: ,pay_input_values_f iv1
3857: ,pay_element_entries_f ee
3858: ,pay_element_entry_values_f eev1
3859: WHERE asg1.assignment_id = p_assignment_id
3860: AND p_date_earned BETWEEN asg1.effective_start_date AND asg1.effective_end_date

Line 3884: ,pay_input_values_f iv1

3880: ,eev1.screen_entry_value screen_entry_value
3881: FROM per_all_assignments_f asg1
3882: ,pay_element_links_f el
3883: ,pay_element_types_f et
3884: ,pay_input_values_f iv1
3885: ,pay_element_entries_f ee
3886: ,pay_element_entry_values_f eev1
3887: WHERE asg1.assignment_id = p_assignment_id
3888: AND p_date_earned BETWEEN asg1.effective_start_date AND asg1.effective_end_date

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

3995: l_payroll_name VARCHAR2(80);
3996: l_period_type VARCHAR2(80);
3997: --------------
3998: /*
3999: TYPE tax_card_rec IS RECORD (inp_val_name pay_input_values_f.NAME%type , screen_entry_val pay_input_values_f.NAME%type );
4000:
4001: TYPE bal_val_rec IS RECORD ( bal_name ff_database_items.USER_NAME%type , bal_val NUMBER(10,2) );
4002:
4003:

Line 4218: , pay_input_values_f iv

4214: ,iv.input_value_id input_value_id
4215: ,iv.uom uom
4216: FROM pay_element_types_f et
4217: , pay_element_types_f_tl pettl
4218: , pay_input_values_f iv
4219: , pay_element_classifications classification
4220: WHERE et.element_type_id = iv.element_type_id
4221: AND et.element_type_id = pettl.element_type_id
4222: AND pettl.language = USERENV('LANG')

Line 4245: , pay_input_values_f iv

4241: ,iv.input_value_id input_value_id
4242: ,iv.uom uom
4243: FROM pay_element_types_f et
4244: , pay_element_types_f_tl pettl
4245: , pay_input_values_f iv
4246: , pay_element_classifications classification
4247: WHERE et.element_type_id = iv.element_type_id
4248: AND et.element_type_id = pettl.element_type_id
4249: AND pettl.language = USERENV('LANG')

Line 4374: cursor csr_inp_val_id (p_element_type_id NUMBER , p_inp_val_name pay_input_values_f.name%TYPE ) IS

4370: -----------------------------------------
4371:
4372: -- cursor to get the input value id
4373:
4374: cursor csr_inp_val_id (p_element_type_id NUMBER , p_inp_val_name pay_input_values_f.name%TYPE ) IS
4375: select input_value_id
4376: from pay_input_values_f
4377: where element_type_id = p_element_type_id
4378: and name = p_inp_val_name

Line 4376: from pay_input_values_f

4372: -- cursor to get the input value id
4373:
4374: cursor csr_inp_val_id (p_element_type_id NUMBER , p_inp_val_name pay_input_values_f.name%TYPE ) IS
4375: select input_value_id
4376: from pay_input_values_f
4377: where element_type_id = p_element_type_id
4378: and name = p_inp_val_name
4379: and business_group_id is null
4380: and legislation_code = 'NO'

Line 4399: ,pay_input_values_f iv1

4395: SELECT eev1.screen_entry_value screen_entry_value
4396: FROM per_all_assignments_f asg1
4397: ,pay_element_links_f el
4398: ,pay_element_types_f et
4399: ,pay_input_values_f iv1
4400: ,pay_element_entries_f ee
4401: ,pay_element_entry_values_f eev1
4402: WHERE asg1.assignment_id = p_assignment_id
4403: AND p_date_earned BETWEEN asg1.effective_start_date AND asg1.effective_end_date