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.

[Home] [Help]

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

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

Line 1079: (input_name pay_input_values_f.name%TYPE

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

Line 1080: ,input_value_id pay_input_values_f.input_value_id%TYPE

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

Line 1081: ,value pay_input_values_f.default_value%TYPE

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

Line 1527: , pay_input_values_f inputs

1523: SELECT inputs.name name
1524: , inputs.input_value_id id
1525: , inputs.default_value value
1526: FROM pay_element_types_f types
1527: , pay_input_values_f inputs
1528: WHERE types.element_type_id = p_element_type_id
1529: AND inputs.element_type_id = types.element_type_id
1530: --AND inputs.legislation_code = 'IN'
1531: AND p_effective_date BETWEEN types.effective_start_date AND types.effective_end_date

Line 1555: (input_name pay_input_values_f.name%TYPE

1551:
1552:
1553: --Variables Initialization
1554: TYPE t_input_values_rec IS RECORD
1555: (input_name pay_input_values_f.name%TYPE
1556: ,input_value_id pay_input_values_f.input_value_id%TYPE
1557: ,value pay_input_values_f.default_value%TYPE
1558: );
1559:

Line 1556: ,input_value_id pay_input_values_f.input_value_id%TYPE

1552:
1553: --Variables Initialization
1554: TYPE t_input_values_rec IS RECORD
1555: (input_name pay_input_values_f.name%TYPE
1556: ,input_value_id pay_input_values_f.input_value_id%TYPE
1557: ,value pay_input_values_f.default_value%TYPE
1558: );
1559:
1560: TYPE t_input_values_tab IS TABLE OF t_input_values_rec INDEX BY BINARY_INTEGER;

Line 1557: ,value pay_input_values_f.default_value%TYPE

1553: --Variables Initialization
1554: TYPE t_input_values_rec IS RECORD
1555: (input_name pay_input_values_f.name%TYPE
1556: ,input_value_id pay_input_values_f.input_value_id%TYPE
1557: ,value pay_input_values_f.default_value%TYPE
1558: );
1559:
1560: TYPE t_input_values_tab IS TABLE OF t_input_values_rec INDEX BY BINARY_INTEGER;
1561: