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 1894: , pay_input_values_f iv

1890: ,iv.input_value_id input_value_id
1891: ,iv.uom uom
1892: FROM pay_element_types_f et
1893: , pay_element_types_f_tl pettl
1894: , pay_input_values_f iv
1895: , pay_element_classifications classification
1896: WHERE et.element_type_id = iv.element_type_id
1897: AND et.element_type_id = pettl.element_type_id
1898: AND pettl.language = USERENV('LANG')

Line 1921: , pay_input_values_f iv

1917: ,iv.input_value_id input_value_id
1918: ,iv.uom uom
1919: FROM pay_element_types_f et
1920: , pay_element_types_f_tl pettl
1921: , pay_input_values_f iv
1922: , pay_element_classifications classification
1923: WHERE et.element_type_id = iv.element_type_id
1924: AND et.element_type_id = pettl.element_type_id
1925: AND pettl.language = USERENV('LANG')

Line 1949: , pay_input_values_f iv

1945: ,iv.uom uom
1946: ,classification.classification_name ele_class
1947: FROM pay_element_types_f et
1948: , pay_element_types_f_tl pettl
1949: , pay_input_values_f iv
1950: , pay_element_classifications classification
1951: WHERE et.element_type_id = iv.element_type_id
1952: AND et.element_type_id = pettl.element_type_id
1953: AND pettl.language = USERENV('LANG')

Line 1980: , pay_input_values_f iv

1976: ,iv.uom uom
1977: ,classification.classification_name ele_class
1978: FROM pay_element_types_f et
1979: , pay_element_types_f_tl pettl
1980: , pay_input_values_f iv
1981: , pay_element_classifications classification
1982: WHERE et.element_type_id = iv.element_type_id
1983: AND et.element_type_id = pettl.element_type_id
1984: AND pettl.language = USERENV('LANG')

Line 2972: ,pay_input_values_f piv

2968: ,piv.uom
2969: FROM hr_organization_information hoi
2970: ,pay_element_classifications pec
2971: ,pay_element_types_f pet
2972: ,pay_input_values_f piv
2973: WHERE hoi.organization_id = p_bus_grp_id
2974: AND hoi.org_information_context = 'Business Group:Payslip Info'
2975: AND hoi.org_information1 = 'ELEMENT'
2976: AND hoi.org_information2 = pet.element_type_id

Line 3867: ,pay_input_values_f iv1

3863: ,per_all_assignments_f asg2
3864: ,per_all_people_f per
3865: ,pay_element_links_f el
3866: ,pay_element_types_f et
3867: ,pay_input_values_f iv1
3868: ,pay_element_entries_f ee
3869: ,pay_element_entry_values_f eev1
3870: WHERE asg1.assignment_id = p_assignment_id
3871: AND p_date_earned BETWEEN asg1.effective_start_date AND asg1.effective_end_date

Line 3895: ,pay_input_values_f iv1

3891: ,eev1.screen_entry_value screen_entry_value
3892: FROM per_all_assignments_f asg1
3893: ,pay_element_links_f el
3894: ,pay_element_types_f et
3895: ,pay_input_values_f iv1
3896: ,pay_element_entries_f ee
3897: ,pay_element_entry_values_f eev1
3898: WHERE asg1.assignment_id = p_assignment_id
3899: AND p_date_earned BETWEEN asg1.effective_start_date AND asg1.effective_end_date

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

4006: l_payroll_name VARCHAR2(80);
4007: l_period_type VARCHAR2(80);
4008: --------------
4009: /*
4010: TYPE tax_card_rec IS RECORD (inp_val_name pay_input_values_f.NAME%type , screen_entry_val pay_input_values_f.NAME%type );
4011:
4012: TYPE bal_val_rec IS RECORD ( bal_name ff_database_items.USER_NAME%type , bal_val NUMBER(10,2) );
4013:
4014:

Line 4229: , pay_input_values_f iv

4225: ,iv.input_value_id input_value_id
4226: ,iv.uom uom
4227: FROM pay_element_types_f et
4228: , pay_element_types_f_tl pettl
4229: , pay_input_values_f iv
4230: , pay_element_classifications classification
4231: WHERE et.element_type_id = iv.element_type_id
4232: AND et.element_type_id = pettl.element_type_id
4233: AND pettl.language = USERENV('LANG')

Line 4256: , pay_input_values_f iv

4252: ,iv.input_value_id input_value_id
4253: ,iv.uom uom
4254: FROM pay_element_types_f et
4255: , pay_element_types_f_tl pettl
4256: , pay_input_values_f iv
4257: , pay_element_classifications classification
4258: WHERE et.element_type_id = iv.element_type_id
4259: AND et.element_type_id = pettl.element_type_id
4260: AND pettl.language = USERENV('LANG')

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

4381: -----------------------------------------
4382:
4383: -- cursor to get the input value id
4384:
4385: cursor csr_inp_val_id (p_element_type_id NUMBER , p_inp_val_name pay_input_values_f.name%TYPE ) IS
4386: select input_value_id
4387: from pay_input_values_f
4388: where element_type_id = p_element_type_id
4389: and name = p_inp_val_name

Line 4387: from pay_input_values_f

4383: -- cursor to get the input value id
4384:
4385: cursor csr_inp_val_id (p_element_type_id NUMBER , p_inp_val_name pay_input_values_f.name%TYPE ) IS
4386: select input_value_id
4387: from pay_input_values_f
4388: where element_type_id = p_element_type_id
4389: and name = p_inp_val_name
4390: and business_group_id is null
4391: and legislation_code = 'NO'

Line 4410: ,pay_input_values_f iv1

4406: SELECT eev1.screen_entry_value screen_entry_value
4407: FROM per_all_assignments_f asg1
4408: ,pay_element_links_f el
4409: ,pay_element_types_f et
4410: ,pay_input_values_f iv1
4411: ,pay_element_entries_f ee
4412: ,pay_element_entry_values_f eev1
4413: WHERE asg1.assignment_id = p_assignment_id
4414: AND p_date_earned BETWEEN asg1.effective_start_date AND asg1.effective_end_date