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.PQP_FEDHR_USPAY_INTG_PKG dependencies on PAY_INPUT_VALUES_F

Line 10: name pay_input_values_f.name%TYPE,

6: -- ********************************
7: TYPE input_vals_type IS RECORD
8: (
9: element_name pay_element_types_f.element_name%TYPE,
10: name pay_input_values_f.name%TYPE,
11: uom_code pay_input_values_f.uom%TYPE,
12: mandatory_flag pay_input_values_f.mandatory_flag%TYPE,
13: generate_db_items_flag pay_input_values_f.generate_db_items_flag%TYPE,
14: display_sequence pay_input_values_f.display_sequence%TYPE,

Line 11: uom_code pay_input_values_f.uom%TYPE,

7: TYPE input_vals_type IS RECORD
8: (
9: element_name pay_element_types_f.element_name%TYPE,
10: name pay_input_values_f.name%TYPE,
11: uom_code pay_input_values_f.uom%TYPE,
12: mandatory_flag pay_input_values_f.mandatory_flag%TYPE,
13: generate_db_items_flag pay_input_values_f.generate_db_items_flag%TYPE,
14: display_sequence pay_input_values_f.display_sequence%TYPE,
15: lookup_type pay_input_values_f.lookup_type%TYPE,

Line 12: mandatory_flag pay_input_values_f.mandatory_flag%TYPE,

8: (
9: element_name pay_element_types_f.element_name%TYPE,
10: name pay_input_values_f.name%TYPE,
11: uom_code pay_input_values_f.uom%TYPE,
12: mandatory_flag pay_input_values_f.mandatory_flag%TYPE,
13: generate_db_items_flag pay_input_values_f.generate_db_items_flag%TYPE,
14: display_sequence pay_input_values_f.display_sequence%TYPE,
15: lookup_type pay_input_values_f.lookup_type%TYPE,
16: effective_start_date pay_input_values_f.effective_start_date%TYPE,

Line 13: generate_db_items_flag pay_input_values_f.generate_db_items_flag%TYPE,

9: element_name pay_element_types_f.element_name%TYPE,
10: name pay_input_values_f.name%TYPE,
11: uom_code pay_input_values_f.uom%TYPE,
12: mandatory_flag pay_input_values_f.mandatory_flag%TYPE,
13: generate_db_items_flag pay_input_values_f.generate_db_items_flag%TYPE,
14: display_sequence pay_input_values_f.display_sequence%TYPE,
15: lookup_type pay_input_values_f.lookup_type%TYPE,
16: effective_start_date pay_input_values_f.effective_start_date%TYPE,
17: effective_end_date pay_input_values_f.effective_end_date%TYPE,

Line 14: display_sequence pay_input_values_f.display_sequence%TYPE,

10: name pay_input_values_f.name%TYPE,
11: uom_code pay_input_values_f.uom%TYPE,
12: mandatory_flag pay_input_values_f.mandatory_flag%TYPE,
13: generate_db_items_flag pay_input_values_f.generate_db_items_flag%TYPE,
14: display_sequence pay_input_values_f.display_sequence%TYPE,
15: lookup_type pay_input_values_f.lookup_type%TYPE,
16: effective_start_date pay_input_values_f.effective_start_date%TYPE,
17: effective_end_date pay_input_values_f.effective_end_date%TYPE,
18: warning_or_error pay_input_values_f.warning_or_error%TYPE,

Line 15: lookup_type pay_input_values_f.lookup_type%TYPE,

11: uom_code pay_input_values_f.uom%TYPE,
12: mandatory_flag pay_input_values_f.mandatory_flag%TYPE,
13: generate_db_items_flag pay_input_values_f.generate_db_items_flag%TYPE,
14: display_sequence pay_input_values_f.display_sequence%TYPE,
15: lookup_type pay_input_values_f.lookup_type%TYPE,
16: effective_start_date pay_input_values_f.effective_start_date%TYPE,
17: effective_end_date pay_input_values_f.effective_end_date%TYPE,
18: warning_or_error pay_input_values_f.warning_or_error%TYPE,
19: legislation_code pay_element_types_f.legislation_code%TYPE,

Line 16: effective_start_date pay_input_values_f.effective_start_date%TYPE,

12: mandatory_flag pay_input_values_f.mandatory_flag%TYPE,
13: generate_db_items_flag pay_input_values_f.generate_db_items_flag%TYPE,
14: display_sequence pay_input_values_f.display_sequence%TYPE,
15: lookup_type pay_input_values_f.lookup_type%TYPE,
16: effective_start_date pay_input_values_f.effective_start_date%TYPE,
17: effective_end_date pay_input_values_f.effective_end_date%TYPE,
18: warning_or_error pay_input_values_f.warning_or_error%TYPE,
19: legislation_code pay_element_types_f.legislation_code%TYPE,
20: formula_id ff_formulas_f.formula_id%TYPE,

Line 17: effective_end_date pay_input_values_f.effective_end_date%TYPE,

13: generate_db_items_flag pay_input_values_f.generate_db_items_flag%TYPE,
14: display_sequence pay_input_values_f.display_sequence%TYPE,
15: lookup_type pay_input_values_f.lookup_type%TYPE,
16: effective_start_date pay_input_values_f.effective_start_date%TYPE,
17: effective_end_date pay_input_values_f.effective_end_date%TYPE,
18: warning_or_error pay_input_values_f.warning_or_error%TYPE,
19: legislation_code pay_element_types_f.legislation_code%TYPE,
20: formula_id ff_formulas_f.formula_id%TYPE,
21: business_group_name per_business_groups.name%TYPE

Line 18: warning_or_error pay_input_values_f.warning_or_error%TYPE,

14: display_sequence pay_input_values_f.display_sequence%TYPE,
15: lookup_type pay_input_values_f.lookup_type%TYPE,
16: effective_start_date pay_input_values_f.effective_start_date%TYPE,
17: effective_end_date pay_input_values_f.effective_end_date%TYPE,
18: warning_or_error pay_input_values_f.warning_or_error%TYPE,
19: legislation_code pay_element_types_f.legislation_code%TYPE,
20: formula_id ff_formulas_f.formula_id%TYPE,
21: business_group_name per_business_groups.name%TYPE
22: );

Line 1220: FROM pay_input_values_f

1216:
1217: CURSOR c_no_of_input_vals(p_element_type_id IN NUMBER)
1218: IS
1219: SELECT max(display_sequence) count
1220: FROM pay_input_values_f
1221: WHERE element_type_id=p_element_type_id;
1222:
1223: TYPE PB_REC IS RECORD
1224: (

Line 1433: -- from pay_input_values_f

1429: --l_element_type_id NUMBER;
1430:
1431: --CURSOR c_no_of_input_vals(p_element_type_id in NUMBER) is
1432: -- select count(*) count
1433: -- from pay_input_values_f
1434: -- where element_type_id=p_element_type_id;
1435: --l_prefix VARCHAR2(13);
1436: --l_rec pqp_pcv_shd.g_rec_type;
1437: --l_ele_name VARCHAR2(80);