APPS.PAY_US_GARN_UPGRADE dependencies on PAY_INPUT_VALUES_F

Line 935: pay_input_values_f pivf

931: ) IS
932: select petf.element_type_id,
933: pivf.input_value_id
934: from pay_element_types_f petf,
935: pay_input_values_f pivf
936: where petf.element_name like cp_ele_name
937: and petf.business_group_id = cp_business_group_id
938: and pivf.element_type_id = petf.element_type_id
939: and pivf.name = cp_inp_val_name;

Line 1069: FROM pay_input_values_f

1065: WHERE element_type_id = l_element_Type_id;
1066:
1067: /* Delete the Input Values associated with the Base Element */
1068: DELETE
1069: FROM pay_input_values_f
1070: WHERE element_type_id = l_element_type_id;
1071:
1072:
1073: /*

Line 1110: update pay_input_values_f pivf

1106: /*
1107: * Update statement for elements of category 'Alimony', 'Child Support' and
1108: * 'Spousal Support'.
1109: */
1110: update pay_input_values_f pivf
1111: set mandatory_flag = 'X'
1112: where pivf.element_type_id in (select distinct element_type_id
1113: from pay_element_types_f
1114: where element_name = p_ele_name

Line 1124: update pay_input_values_f pivf

1120:
1121: /*
1122: * Update statement for elements of category 'Credit Debt' and 'Garnishment'.
1123: */
1124: update pay_input_values_f pivf
1125: set mandatory_flag = 'X'
1126: where pivf.element_type_id in (select distinct element_type_id
1127: from pay_element_types_f
1128: where element_name = p_ele_name

Line 1140: update pay_input_values_f pivf

1136:
1137: /*
1138: * Update statement for elements of category 'Bankruptcy Order'.
1139: */
1140: update pay_input_values_f pivf
1141: set mandatory_flag = 'X'
1142: where pivf.element_type_id in (select distinct element_type_id
1143: from pay_element_types_f
1144: where element_name = p_ele_name

Line 1156: update pay_input_values_f pivf

1152:
1153: /*
1154: * Update statement for elements of category 'Education Loan'.
1155: */
1156: update pay_input_values_f pivf
1157: set mandatory_flag = 'X'
1158: where pivf.element_type_id in (select distinct element_type_id
1159: from pay_element_types_f
1160: where element_name = p_ele_name

Line 1174: update pay_input_values_f pivf

1170:
1171: /*
1172: * Update statement for elements of category 'Tax Levy'.
1173: */
1174: update pay_input_values_f pivf
1175: set mandatory_flag = 'X'
1176: where pivf.element_type_id in (select distinct element_type_id
1177: from pay_element_types_f
1178: where element_name = p_ele_name

Line 1190: update pay_input_values_f pivf

1186:
1187: /*
1188: * Update statement for elements of category 'Employee Requested'.
1189: */
1190: update pay_input_values_f pivf
1191: set mandatory_flag = 'X'
1192: where pivf.element_type_id in (select distinct element_type_id
1193: from pay_element_types_f
1194: where element_name = p_ele_name