APPS.PAY_US_RULES dependencies on PAY_INPUT_VALUES_F

Line 995: vname pay_input_values_f.name%TYPE,

991: INDEX BY BINARY_INTEGER;
992:
993: TYPE tinputvalrec IS RECORD
994: (
995: vname pay_input_values_f.name%TYPE,
996: vresultname pay_formula_result_rules_f.result_name%TYPE,
997: vresultruletype pay_formula_result_rules_f.result_rule_type%TYPE,
998: vinputvalid pay_input_values_f.input_value_id%TYPE
999: );

Line 998: vinputvalid pay_input_values_f.input_value_id%TYPE

994: (
995: vname pay_input_values_f.name%TYPE,
996: vresultname pay_formula_result_rules_f.result_name%TYPE,
997: vresultruletype pay_formula_result_rules_f.result_rule_type%TYPE,
998: vinputvalid pay_input_values_f.input_value_id%TYPE
999: );
1000: TYPE tinputvalrectab IS TABLE OF tinputvalrec
1001: INDEX BY BINARY_INTEGER;
1002: tinputdetails tinputvalrectab;

Line 1082: FROM pay_input_values_f

1078:
1079: CURSOR c_inp_val(p_input_val_name IN VARCHAR2, p_element_type_id IN NUMBER)
1080: IS
1081: SELECT input_value_id
1082: FROM pay_input_values_f
1083: WHERE element_type_id = p_element_type_id
1084: AND UPPER (NAME) = UPPER (p_input_val_name);
1085:
1086: CURSOR c_pspr (

Line 1314: UPDATE pay_input_values_f

1310:
1311: --
1312: FOR i IN 1 .. 2
1313: LOOP
1314: UPDATE pay_input_values_f
1315: SET formula_id = t_form_id (i),
1316: warning_or_error = t_we_flag (i),
1317: DEFAULT_VALUE = t_def_val (i)
1318: WHERE input_value_id = t_ipv_id (i);

Line 1324: UPDATE pay_input_values_f

1320: -- Bug 4420211
1321: -- Set the Mandatory Flag to 'N' for input value 'Deduction Processing'
1322: -- if the classification is 'Non-payroll Payments'
1323: IF (lrec.element_classification = 'Non-payroll Payments' and i = 1) THEN
1324: UPDATE pay_input_values_f
1325: SET mandatory_flag = 'N'
1326: WHERE input_value_id = t_ipv_id (i);
1327: END IF;
1328: END LOOP;

Line 1877: FROM pay_input_values_f piv

1873:
1874: --
1875: CURSOR c_get_ipv_id IS -- Gets the input value id
1876: SELECT piv.input_value_id
1877: FROM pay_input_values_f piv
1878: WHERE piv.NAME = p_object_name
1879: AND piv.element_type_id = p_object_id
1880: AND piv.business_group_id = p_business_group_id;
1881:

Line 2308: pay_input_values_f piv,

2304: ,cp_date DATE
2305: ) IS
2306: SELECT peev.screen_entry_value
2307: FROM pay_element_types_f pet,
2308: pay_input_values_f piv,
2309: pay_element_entries_f peef,
2310: pay_element_entry_values_f peev
2311: WHERE pet.element_name = cp_ele_name
2312: AND pet.business_group_id is NULL