APPS.PQP_GB_OSP_TEMPLATE dependencies on PAY_INPUT_VALUES_F

Line 330: FROM pay_input_values_f

326:
327: UPDATE ben_acty_base_rt_f
328: SET element_type_id = p_element_type_id
329: ,input_value_id = (SELECT input_value_id
330: FROM pay_input_values_f
331: WHERE element_type_id = p_element_type_id
332: AND UPPER(name) = l_input_name
333: AND p_effective_date BETWEEN effective_start_date
334: AND effective_end_date)

Line 369: FROM pay_input_values_f

365: ,DECODE(UPPER(name),'ABSENCE END DATE','U','C')
366: ,'L_'||TRANSLATE(UPPER(name),' ','_')
367: ,business_group_id
368: ,1
369: FROM pay_input_values_f
370: WHERE element_type_id = p_element_type_id
371: AND p_effective_date BETWEEN effective_start_date AND effective_end_date
372: AND UPPER(name) in ('ABSENCE TYPE','ABSENCE END DATE','ABSENCE START DATE','PLAN ID','ABSENCE ID')
373: );

Line 394: FROM pay_input_values_f

390: ,DECODE(UPPER(name),'MATERNITY END DATE','U','C')
391: ,'L_'||TRANSLATE(UPPER(name),' ','_')
392: ,business_group_id
393: ,1
394: FROM pay_input_values_f
395: WHERE element_type_id = p_element_type_id
396: AND p_effective_date BETWEEN effective_start_date AND effective_end_date
397: AND UPPER(name) in ('ABSENCE TYPE','MATERNITY END DATE','MATERNITY START DATE','PLAN ID','ABSENCE ID','EWC')
398: );

Line 1094: FROM pay_input_values_f piv

1090: IS
1091: SELECT input_value_id
1092: ,piv.name
1093: ,piv.element_type_id
1094: FROM pay_input_values_f piv
1095: ,pay_element_types_f pet
1096: WHERE element_name = c_ele_name
1097: AND piv.element_type_id = pet.element_type_id
1098: AND (piv.business_group_id = p_bg_id OR piv.business_group_id IS NULL)

Line 1106: FROM pay_input_values_f

1102: CURSOR csr_updinput(c_ip_id number
1103: ,c_element_type_id number)
1104: IS
1105: SELECT rowid
1106: FROM pay_input_values_f
1107: WHERE input_value_id = c_ip_id
1108: AND element_type_id = c_element_type_id
1109: FOR UPDATE NOWAIT;
1110:

Line 1155: UPDATE pay_input_values_f

1151: END IF;
1152:
1153: --
1154:
1155: UPDATE pay_input_values_f
1156: SET default_value = p_def_value
1157: WHERE rowid = csr_updinput_rec.rowid;
1158:
1159: END LOOP;