APPS.PAY_BEE_SS dependencies on PAY_INPUT_VALUES_F

Line 613: from pay_input_values_f

609: from pay_element_types_f
610: where ELEMENT_NAME = p_element_name;
611:
612: select INPUT_VALUE_ID into l_input_value_id
613: from pay_input_values_f
614: where ELEMENT_TYPE_ID = l_element_type_id
615: and NAME = p_input_value_name;
616:
617:

Line 714: from pay_input_values_f

710: from pay_element_types_f
711: where ELEMENT_NAME = p_element_name;
712:
713: select INPUT_VALUE_ID into l_input_value_id
714: from pay_input_values_f
715: where ELEMENT_TYPE_ID = l_element_type_id
716: and NAME = p_input_value_name; */
717:
718:

Line 886: select input_value_id from pay_input_values_f

882: group by regexp_replace(substr(name,instr(name,'@')+1), '[A-Z]','')
883: order by regexp_replace(substr(name,instr(name,'@')+1), '[A-Z]','');
884:
885: cursor input_values_cur is
886: select input_value_id from pay_input_values_f
887: where element_type_id=l_element_type_id
888: order by display_sequence;
889:
890: begin

Line 1297: select input_value_id from pay_input_values_f

1293: AND TRANSACTION_STEP_ID in (select TRANSACTION_STEP_ID from hr_api_transaction_steps where TRANSACTION_ID=l_transaction_id)
1294: group by regexp_replace(name, '[A-Z]','')
1295: order by regexp_replace(name, '[A-Z]','');
1296: cursor input_values_cur is
1297: select input_value_id from pay_input_values_f
1298: where element_type_id=l_element_type_id
1299: order by display_sequence;
1300:
1301: begin