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

Line 21: (input_name pay_input_values_f.name%TYPE

17: -- The following type is declared to store all
18: -- the inputs values of tax elements.
19: --
20: type t_input_values_rec is record
21: (input_name pay_input_values_f.name%TYPE
22: ,input_value_id pay_input_values_f.input_value_id%TYPE
23: ,input_value pay_element_entry_values.screen_entry_value%TYPE);
24:
25: type t_input_values_tab is table of t_input_values_rec

Line 22: ,input_value_id pay_input_values_f.input_value_id%TYPE

18: -- the inputs values of tax elements.
19: --
20: type t_input_values_rec is record
21: (input_name pay_input_values_f.name%TYPE
22: ,input_value_id pay_input_values_f.input_value_id%TYPE
23: ,input_value pay_element_entry_values.screen_entry_value%TYPE);
24:
25: type t_input_values_tab is table of t_input_values_rec
26: index by binary_integer;

Line 97: , pay_input_values_f inputs

93: SELECT inputs.name name
94: , inputs.input_value_id id
95: , inputs.default_value value
96: FROM pay_element_types_f types
97: , pay_input_values_f inputs
98: WHERE types.element_type_id = p_element_type_id
99: AND inputs.element_type_id = types.element_type_id
100: AND p_effective_date BETWEEN types.effective_start_date AND types.effective_end_date
101: AND p_effective_date BETWEEN inputs.effective_start_date AND inputs.effective_end_date

Line 156: pay_input_values_f piv

152:
153: CURSOR c_ltc_carry_over(p_element_entry_id NUMBER)
154: IS SELECT nvl(peev.screen_entry_value,'N')
155: FROM pay_element_entry_values_f peev,
156: pay_input_values_f piv
157: WHERE peev.element_entry_id = p_element_entry_id
158: AND peev.input_value_id = piv.input_value_id
159: AND piv.name ='Carryover from Prev Block';
160:

Line 163: (input_name pay_input_values_f.name%TYPE

159: AND piv.name ='Carryover from Prev Block';
160:
161: --Variables Initialization
162: TYPE t_input_values_rec IS RECORD
163: (input_name pay_input_values_f.name%TYPE
164: ,input_value_id pay_input_values_f.input_value_id%TYPE
165: ,value pay_input_values_f.default_value%TYPE
166: );
167:

Line 164: ,input_value_id pay_input_values_f.input_value_id%TYPE

160:
161: --Variables Initialization
162: TYPE t_input_values_rec IS RECORD
163: (input_name pay_input_values_f.name%TYPE
164: ,input_value_id pay_input_values_f.input_value_id%TYPE
165: ,value pay_input_values_f.default_value%TYPE
166: );
167:
168: TYPE t_input_values_tab IS TABLE OF t_input_values_rec INDEX BY BINARY_INTEGER;

Line 165: ,value pay_input_values_f.default_value%TYPE

161: --Variables Initialization
162: TYPE t_input_values_rec IS RECORD
163: (input_name pay_input_values_f.name%TYPE
164: ,input_value_id pay_input_values_f.input_value_id%TYPE
165: ,value pay_input_values_f.default_value%TYPE
166: );
167:
168: TYPE t_input_values_tab IS TABLE OF t_input_values_rec INDEX BY BINARY_INTEGER;
169:

Line 1155: pay_input_values_f piv

1151: SELECT screen_entry_value
1152: FROM pay_element_entry_values_f peev,
1153: pay_element_entries_f pev,
1154: pay_element_types_f pet,
1155: pay_input_values_f piv
1156: WHERE pev.assignment_id = p_assignment_id
1157: AND pev.element_type_id = pet.element_type_id
1158: AND pev.element_entry_id = peev.element_entry_id
1159: AND peev.element_entry_id = p_entry_id

Line 1553: ,pay_input_values_f piv

1549: ,pay_assignment_actions ASSACT
1550: ,pay_assignment_actions BAL_ASSACT
1551: ,pay_payroll_actions PACT
1552: ,pay_payroll_actions BACT
1553: ,pay_input_values_f piv
1554: ,pay_run_result_values srcVal
1555: ,pay_input_values_f srcInp
1556: where BAL_ASSACT.assignment_action_id = p_asg_action_id
1557: AND BAL_ASSACT.payroll_action_id = BACT.payroll_action_id

Line 1555: ,pay_input_values_f srcInp

1551: ,pay_payroll_actions PACT
1552: ,pay_payroll_actions BACT
1553: ,pay_input_values_f piv
1554: ,pay_run_result_values srcVal
1555: ,pay_input_values_f srcInp
1556: where BAL_ASSACT.assignment_action_id = p_asg_action_id
1557: AND BAL_ASSACT.payroll_action_id = BACT.payroll_action_id
1558: AND FEED.input_value_id = TARGET.input_value_id
1559: AND nvl(TARGET.result_value, '0') <> '0'

Line 1871: , pay_input_values_f inputs

1867: SELECT inputs.name name
1868: , inputs.input_value_id id
1869: , inputs.default_value value
1870: FROM pay_element_types_f types
1871: , pay_input_values_f inputs
1872: WHERE types.element_type_id = p_element_type_id
1873: AND inputs.element_type_id = types.element_type_id
1874: --AND inputs.legislation_code = 'IN'
1875: AND p_effective_date BETWEEN types.effective_start_date AND types.effective_end_date

Line 1899: (input_name pay_input_values_f.name%TYPE

1895:
1896:
1897: --Variables Initialization
1898: TYPE t_input_values_rec IS RECORD
1899: (input_name pay_input_values_f.name%TYPE
1900: ,input_value_id pay_input_values_f.input_value_id%TYPE
1901: ,value pay_input_values_f.default_value%TYPE
1902: );
1903:

Line 1900: ,input_value_id pay_input_values_f.input_value_id%TYPE

1896:
1897: --Variables Initialization
1898: TYPE t_input_values_rec IS RECORD
1899: (input_name pay_input_values_f.name%TYPE
1900: ,input_value_id pay_input_values_f.input_value_id%TYPE
1901: ,value pay_input_values_f.default_value%TYPE
1902: );
1903:
1904: TYPE t_input_values_tab IS TABLE OF t_input_values_rec INDEX BY BINARY_INTEGER;

Line 1901: ,value pay_input_values_f.default_value%TYPE

1897: --Variables Initialization
1898: TYPE t_input_values_rec IS RECORD
1899: (input_name pay_input_values_f.name%TYPE
1900: ,input_value_id pay_input_values_f.input_value_id%TYPE
1901: ,value pay_input_values_f.default_value%TYPE
1902: );
1903:
1904: TYPE t_input_values_tab IS TABLE OF t_input_values_rec INDEX BY BINARY_INTEGER;
1905: