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 93: , pay_input_values_f inputs

89: SELECT inputs.name name
90: , inputs.input_value_id id
91: , inputs.default_value value
92: FROM pay_element_types_f types
93: , pay_input_values_f inputs
94: WHERE types.element_type_id = p_element_type_id
95: AND inputs.element_type_id = types.element_type_id
96: AND p_effective_date BETWEEN types.effective_start_date AND types.effective_end_date
97: AND p_effective_date BETWEEN inputs.effective_start_date AND inputs.effective_end_date

Line 150: pay_input_values_f piv

146:
147: CURSOR c_ltc_carry_over(p_element_entry_id NUMBER)
148: IS SELECT nvl(peev.screen_entry_value,'N')
149: FROM pay_element_entry_values_f peev,
150: pay_input_values_f piv
151: WHERE peev.element_entry_id = p_element_entry_id
152: AND peev.input_value_id = piv.input_value_id
153: AND piv.name ='Carryover from Prev Block';
154:

Line 157: (input_name pay_input_values_f.name%TYPE

153: AND piv.name ='Carryover from Prev Block';
154:
155: --Variables Initialization
156: TYPE t_input_values_rec IS RECORD
157: (input_name pay_input_values_f.name%TYPE
158: ,input_value_id pay_input_values_f.input_value_id%TYPE
159: ,value pay_input_values_f.default_value%TYPE
160: );
161:

Line 158: ,input_value_id pay_input_values_f.input_value_id%TYPE

154:
155: --Variables Initialization
156: TYPE t_input_values_rec IS RECORD
157: (input_name pay_input_values_f.name%TYPE
158: ,input_value_id pay_input_values_f.input_value_id%TYPE
159: ,value pay_input_values_f.default_value%TYPE
160: );
161:
162: TYPE t_input_values_tab IS TABLE OF t_input_values_rec INDEX BY BINARY_INTEGER;

Line 159: ,value pay_input_values_f.default_value%TYPE

155: --Variables Initialization
156: TYPE t_input_values_rec IS RECORD
157: (input_name pay_input_values_f.name%TYPE
158: ,input_value_id pay_input_values_f.input_value_id%TYPE
159: ,value pay_input_values_f.default_value%TYPE
160: );
161:
162: TYPE t_input_values_tab IS TABLE OF t_input_values_rec INDEX BY BINARY_INTEGER;
163:

Line 1106: pay_input_values_f piv

1102: SELECT screen_entry_value
1103: FROM pay_element_entry_values_f peev,
1104: pay_element_entries_f pev,
1105: pay_element_types_f pet,
1106: pay_input_values_f piv
1107: WHERE pev.assignment_id = p_assignment_id
1108: AND pev.element_type_id = pet.element_type_id
1109: AND pev.element_entry_id = peev.element_entry_id
1110: AND peev.element_entry_id = p_entry_id

Line 1496: ,pay_input_values_f piv

1492: ,pay_assignment_actions ASSACT
1493: ,pay_assignment_actions BAL_ASSACT
1494: ,pay_payroll_actions PACT
1495: ,pay_payroll_actions BACT
1496: ,pay_input_values_f piv
1497: ,pay_run_result_values srcVal
1498: ,pay_input_values_f srcInp
1499: where BAL_ASSACT.assignment_action_id = p_asg_action_id
1500: AND BAL_ASSACT.payroll_action_id = BACT.payroll_action_id

Line 1498: ,pay_input_values_f srcInp

1494: ,pay_payroll_actions PACT
1495: ,pay_payroll_actions BACT
1496: ,pay_input_values_f piv
1497: ,pay_run_result_values srcVal
1498: ,pay_input_values_f srcInp
1499: where BAL_ASSACT.assignment_action_id = p_asg_action_id
1500: AND BAL_ASSACT.payroll_action_id = BACT.payroll_action_id
1501: AND FEED.input_value_id = TARGET.input_value_id
1502: AND nvl(TARGET.result_value, '0') <> '0'

Line 1798: , pay_input_values_f inputs

1794: SELECT inputs.name name
1795: , inputs.input_value_id id
1796: , inputs.default_value value
1797: FROM pay_element_types_f types
1798: , pay_input_values_f inputs
1799: WHERE types.element_type_id = p_element_type_id
1800: AND inputs.element_type_id = types.element_type_id
1801: --AND inputs.legislation_code = 'IN'
1802: AND p_effective_date BETWEEN types.effective_start_date AND types.effective_end_date

Line 1826: (input_name pay_input_values_f.name%TYPE

1822:
1823:
1824: --Variables Initialization
1825: TYPE t_input_values_rec IS RECORD
1826: (input_name pay_input_values_f.name%TYPE
1827: ,input_value_id pay_input_values_f.input_value_id%TYPE
1828: ,value pay_input_values_f.default_value%TYPE
1829: );
1830:

Line 1827: ,input_value_id pay_input_values_f.input_value_id%TYPE

1823:
1824: --Variables Initialization
1825: TYPE t_input_values_rec IS RECORD
1826: (input_name pay_input_values_f.name%TYPE
1827: ,input_value_id pay_input_values_f.input_value_id%TYPE
1828: ,value pay_input_values_f.default_value%TYPE
1829: );
1830:
1831: TYPE t_input_values_tab IS TABLE OF t_input_values_rec INDEX BY BINARY_INTEGER;

Line 1828: ,value pay_input_values_f.default_value%TYPE

1824: --Variables Initialization
1825: TYPE t_input_values_rec IS RECORD
1826: (input_name pay_input_values_f.name%TYPE
1827: ,input_value_id pay_input_values_f.input_value_id%TYPE
1828: ,value pay_input_values_f.default_value%TYPE
1829: );
1830:
1831: TYPE t_input_values_tab IS TABLE OF t_input_values_rec INDEX BY BINARY_INTEGER;
1832: