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

Line 121: , pay_input_values_f inputs

117: SELECT inputs.name name
118: , inputs.input_value_id id
119: , inputs.default_value value
120: FROM pay_element_types_f types
121: , pay_input_values_f inputs
122: WHERE types.element_type_id = p_element_type_id
123: AND inputs.element_type_id = types.element_type_id
124: AND p_effective_date BETWEEN types.effective_start_date AND types.effective_end_date
125: AND p_effective_date BETWEEN inputs.effective_start_date AND inputs.effective_end_date

Line 177: (input_name pay_input_values_f.name%TYPE

173:
174:
175: --Variables Initialization
176: TYPE t_input_values_rec IS RECORD
177: (input_name pay_input_values_f.name%TYPE
178: ,input_value_id pay_input_values_f.input_value_id%TYPE
179: ,value pay_input_values_f.default_value%TYPE
180: );
181:

Line 178: ,input_value_id pay_input_values_f.input_value_id%TYPE

174:
175: --Variables Initialization
176: TYPE t_input_values_rec IS RECORD
177: (input_name pay_input_values_f.name%TYPE
178: ,input_value_id pay_input_values_f.input_value_id%TYPE
179: ,value pay_input_values_f.default_value%TYPE
180: );
181:
182: TYPE t_input_values_tab IS TABLE OF t_input_values_rec INDEX BY BINARY_INTEGER;

Line 179: ,value pay_input_values_f.default_value%TYPE

175: --Variables Initialization
176: TYPE t_input_values_rec IS RECORD
177: (input_name pay_input_values_f.name%TYPE
178: ,input_value_id pay_input_values_f.input_value_id%TYPE
179: ,value pay_input_values_f.default_value%TYPE
180: );
181:
182: TYPE t_input_values_tab IS TABLE OF t_input_values_rec INDEX BY BINARY_INTEGER;
183:

Line 792: , pay_input_values_f inputs

788: SELECT inputs.name name
789: , inputs.input_value_id id
790: , inputs.default_value value
791: FROM pay_element_types_f types
792: , pay_input_values_f inputs
793: WHERE types.element_type_id = p_element_type_id
794: AND inputs.element_type_id = types.element_type_id
795: AND p_effective_date BETWEEN types.effective_start_date AND types.effective_end_date
796: AND p_effective_date BETWEEN inputs.effective_start_date AND inputs.effective_end_date

Line 817: (input_name pay_input_values_f.name%TYPE

813:
814:
815: --Variables Initialization
816: TYPE t_input_values_rec IS RECORD
817: (input_name pay_input_values_f.name%TYPE
818: ,input_value_id pay_input_values_f.input_value_id%TYPE
819: ,value pay_input_values_f.default_value%TYPE
820: );
821:

Line 818: ,input_value_id pay_input_values_f.input_value_id%TYPE

814:
815: --Variables Initialization
816: TYPE t_input_values_rec IS RECORD
817: (input_name pay_input_values_f.name%TYPE
818: ,input_value_id pay_input_values_f.input_value_id%TYPE
819: ,value pay_input_values_f.default_value%TYPE
820: );
821:
822: TYPE t_input_values_tab IS TABLE OF t_input_values_rec INDEX BY BINARY_INTEGER;

Line 819: ,value pay_input_values_f.default_value%TYPE

815: --Variables Initialization
816: TYPE t_input_values_rec IS RECORD
817: (input_name pay_input_values_f.name%TYPE
818: ,input_value_id pay_input_values_f.input_value_id%TYPE
819: ,value pay_input_values_f.default_value%TYPE
820: );
821:
822: TYPE t_input_values_tab IS TABLE OF t_input_values_rec INDEX BY BINARY_INTEGER;
823:

Line 1022: , pay_input_values_f inputs

1018: SELECT inputs.name name
1019: , inputs.input_value_id id
1020: , inputs.default_value value
1021: FROM pay_element_types_f types
1022: , pay_input_values_f inputs
1023: WHERE types.element_type_id = p_element_type_id
1024: AND inputs.element_type_id = types.element_type_id
1025: AND p_effective_date BETWEEN types.effective_start_date AND types.effective_end_date
1026: AND p_effective_date BETWEEN inputs.effective_start_date AND inputs.effective_end_date

Line 1078: (input_name pay_input_values_f.name%TYPE

1074: WHERE element_type_id = p_element_type_id ;
1075:
1076: --Variables Initialization
1077: TYPE t_input_values_rec IS RECORD
1078: (input_name pay_input_values_f.name%TYPE
1079: ,input_value_id pay_input_values_f.input_value_id%TYPE
1080: ,value pay_input_values_f.default_value%TYPE
1081: );
1082:

Line 1079: ,input_value_id pay_input_values_f.input_value_id%TYPE

1075:
1076: --Variables Initialization
1077: TYPE t_input_values_rec IS RECORD
1078: (input_name pay_input_values_f.name%TYPE
1079: ,input_value_id pay_input_values_f.input_value_id%TYPE
1080: ,value pay_input_values_f.default_value%TYPE
1081: );
1082:
1083: TYPE t_input_values_tab IS TABLE OF t_input_values_rec INDEX BY BINARY_INTEGER;

Line 1080: ,value pay_input_values_f.default_value%TYPE

1076: --Variables Initialization
1077: TYPE t_input_values_rec IS RECORD
1078: (input_name pay_input_values_f.name%TYPE
1079: ,input_value_id pay_input_values_f.input_value_id%TYPE
1080: ,value pay_input_values_f.default_value%TYPE
1081: );
1082:
1083: TYPE t_input_values_tab IS TABLE OF t_input_values_rec INDEX BY BINARY_INTEGER;
1084:

Line 1515: , pay_input_values_f inputs

1511: SELECT inputs.name name
1512: , inputs.input_value_id id
1513: , inputs.default_value value
1514: FROM pay_element_types_f types
1515: , pay_input_values_f inputs
1516: WHERE types.element_type_id = p_element_type_id
1517: AND inputs.element_type_id = types.element_type_id
1518: --AND inputs.legislation_code = 'IN'
1519: AND p_effective_date BETWEEN types.effective_start_date AND types.effective_end_date

Line 1543: (input_name pay_input_values_f.name%TYPE

1539:
1540:
1541: --Variables Initialization
1542: TYPE t_input_values_rec IS RECORD
1543: (input_name pay_input_values_f.name%TYPE
1544: ,input_value_id pay_input_values_f.input_value_id%TYPE
1545: ,value pay_input_values_f.default_value%TYPE
1546: );
1547:

Line 1544: ,input_value_id pay_input_values_f.input_value_id%TYPE

1540:
1541: --Variables Initialization
1542: TYPE t_input_values_rec IS RECORD
1543: (input_name pay_input_values_f.name%TYPE
1544: ,input_value_id pay_input_values_f.input_value_id%TYPE
1545: ,value pay_input_values_f.default_value%TYPE
1546: );
1547:
1548: TYPE t_input_values_tab IS TABLE OF t_input_values_rec INDEX BY BINARY_INTEGER;

Line 1545: ,value pay_input_values_f.default_value%TYPE

1541: --Variables Initialization
1542: TYPE t_input_values_rec IS RECORD
1543: (input_name pay_input_values_f.name%TYPE
1544: ,input_value_id pay_input_values_f.input_value_id%TYPE
1545: ,value pay_input_values_f.default_value%TYPE
1546: );
1547:
1548: TYPE t_input_values_tab IS TABLE OF t_input_values_rec INDEX BY BINARY_INTEGER;
1549: