APPS.PAY_US_GARN_UPGRADE dependencies on PAY_INPUT_VALUES_F

Line 942: pay_input_values_f pivf

938: ) IS
939: select petf.element_type_id,
940: pivf.input_value_id
941: from pay_element_types_f petf,
942: pay_input_values_f pivf
943: where petf.element_name like cp_ele_name
944: and petf.business_group_id = cp_business_group_id
945: and pivf.element_type_id = petf.element_type_id
946: and pivf.name = cp_inp_val_name;

Line 1076: FROM pay_input_values_f

1072: WHERE element_type_id = l_element_Type_id;
1073:
1074: /* Delete the Input Values associated with the Base Element */
1075: DELETE
1076: FROM pay_input_values_f
1077: WHERE element_type_id = l_element_type_id;
1078:
1079:
1080: /*

Line 1117: update pay_input_values_f pivf

1113: /*
1114: * Update statement for elements of category 'Alimony', 'Child Support' and
1115: * 'Spousal Support'.
1116: */
1117: update pay_input_values_f pivf
1118: set mandatory_flag = 'X'
1119: where pivf.element_type_id in (select distinct element_type_id
1120: from pay_element_types_f
1121: where element_name = p_ele_name

Line 1131: update pay_input_values_f pivf

1127:
1128: /*
1129: * Update statement for elements of category 'Credit Debt' and 'Garnishment'.
1130: */
1131: update pay_input_values_f pivf
1132: set mandatory_flag = 'X'
1133: where pivf.element_type_id in (select distinct element_type_id
1134: from pay_element_types_f
1135: where element_name = p_ele_name

Line 1147: update pay_input_values_f pivf

1143:
1144: /*
1145: * Update statement for elements of category 'Bankruptcy Order'.
1146: */
1147: update pay_input_values_f pivf
1148: set mandatory_flag = 'X'
1149: where pivf.element_type_id in (select distinct element_type_id
1150: from pay_element_types_f
1151: where element_name = p_ele_name

Line 1163: update pay_input_values_f pivf

1159:
1160: /*
1161: * Update statement for elements of category 'Education Loan'.
1162: */
1163: update pay_input_values_f pivf
1164: set mandatory_flag = 'X'
1165: where pivf.element_type_id in (select distinct element_type_id
1166: from pay_element_types_f
1167: where element_name = p_ele_name

Line 1181: update pay_input_values_f pivf

1177:
1178: /*
1179: * Update statement for elements of category 'Tax Levy'.
1180: */
1181: update pay_input_values_f pivf
1182: set mandatory_flag = 'X'
1183: where pivf.element_type_id in (select distinct element_type_id
1184: from pay_element_types_f
1185: where element_name = p_ele_name

Line 1197: update pay_input_values_f pivf

1193:
1194: /*
1195: * Update statement for elements of category 'Employee Requested'.
1196: */
1197: update pay_input_values_f pivf
1198: set mandatory_flag = 'X'
1199: where pivf.element_type_id in (select distinct element_type_id
1200: from pay_element_types_f
1201: where element_name = p_ele_name