APPS.PAY_US_RULES dependencies on PAY_INPUT_VALUES_F

Line 940: vname pay_input_values_f.name%TYPE,

936: INDEX BY BINARY_INTEGER;
937:
938: TYPE tinputvalrec IS RECORD
939: (
940: vname pay_input_values_f.name%TYPE,
941: vresultname pay_formula_result_rules_f.result_name%TYPE,
942: vresultruletype pay_formula_result_rules_f.result_rule_type%TYPE,
943: vinputvalid pay_input_values_f.input_value_id%TYPE
944: );

Line 943: vinputvalid pay_input_values_f.input_value_id%TYPE

939: (
940: vname pay_input_values_f.name%TYPE,
941: vresultname pay_formula_result_rules_f.result_name%TYPE,
942: vresultruletype pay_formula_result_rules_f.result_rule_type%TYPE,
943: vinputvalid pay_input_values_f.input_value_id%TYPE
944: );
945: TYPE tinputvalrectab IS TABLE OF tinputvalrec
946: INDEX BY BINARY_INTEGER;
947: tinputdetails tinputvalrectab;

Line 1027: FROM pay_input_values_f

1023:
1024: CURSOR c_inp_val(p_input_val_name IN VARCHAR2, p_element_type_id IN NUMBER)
1025: IS
1026: SELECT input_value_id
1027: FROM pay_input_values_f
1028: WHERE element_type_id = p_element_type_id
1029: AND UPPER (NAME) = UPPER (p_input_val_name);
1030:
1031: CURSOR c_pspr (

Line 1259: UPDATE pay_input_values_f

1255:
1256: --
1257: FOR i IN 1 .. 2
1258: LOOP
1259: UPDATE pay_input_values_f
1260: SET formula_id = t_form_id (i),
1261: warning_or_error = t_we_flag (i),
1262: DEFAULT_VALUE = t_def_val (i)
1263: WHERE input_value_id = t_ipv_id (i);

Line 1269: UPDATE pay_input_values_f

1265: -- Bug 4420211
1266: -- Set the Mandatory Flag to 'N' for input value 'Deduction Processing'
1267: -- if the classification is 'Non-payroll Payments'
1268: IF (lrec.element_classification = 'Non-payroll Payments' and i = 1) THEN
1269: UPDATE pay_input_values_f
1270: SET mandatory_flag = 'N'
1271: WHERE input_value_id = t_ipv_id (i);
1272: END IF;
1273: END LOOP;

Line 1822: FROM pay_input_values_f piv

1818:
1819: --
1820: CURSOR c_get_ipv_id IS -- Gets the input value id
1821: SELECT piv.input_value_id
1822: FROM pay_input_values_f piv
1823: WHERE piv.NAME = p_object_name
1824: AND piv.element_type_id = p_object_id
1825: AND piv.business_group_id = p_business_group_id;
1826:

Line 2248: pay_input_values_f piv,

2244: ,cp_date DATE
2245: ) IS
2246: SELECT peev.screen_entry_value
2247: FROM pay_element_types_f pet,
2248: pay_input_values_f piv,
2249: pay_element_entries_f peef,
2250: pay_element_entry_values_f peev
2251: WHERE pet.element_name = cp_ele_name
2252: AND pet.business_group_id is NULL