DBA Data[Home] [Help]

APPS.BEN_EXTRACT_SEED dependencies on PAY_INPUT_VALUES_F

Line 423: cursor cd is SELECT name from pay_input_values_f

419: = nvl(p_business_group_id,-1)
420: and element_type_id = p_val;
421:
422:
423: cursor cd is SELECT name from pay_input_values_f
424: WHERE nvl(business_group_id,nvl(p_business_group_id,-1))
425: = nvl(p_business_group_id,-1)
426: and input_value_id = p_val;
427:

Line 1186: cursor cd is SELECT input_value_id from pay_input_values_f

1182: = nvl(p_business_group_id,-1)
1183: and element_name = p_meaning;
1184:
1185:
1186: cursor cd is SELECT input_value_id from pay_input_values_f
1187: WHERE nvl(business_group_id ,nvl(p_business_group_id,-1))
1188: = nvl(p_business_group_id,-1)
1189: and name = p_meaning
1190: and element_type_id = (SELECT element_type_id from pay_element_types_f