DBA Data[Home] [Help]

APPS.BEN_EXTRACT_SEED dependencies on PAY_INPUT_VALUES_F

Line 476: cursor cd is SELECT name from pay_input_values_f

472: = nvl(p_business_group_id,-1)
473: and element_type_id = p_val;
474:
475:
476: cursor cd is SELECT name from pay_input_values_f
477: WHERE nvl(business_group_id,nvl(p_business_group_id,-1))
478: = nvl(p_business_group_id,-1)
479: and input_value_id = p_val;
480:

Line 1239: cursor cd is SELECT input_value_id from pay_input_values_f

1235: = nvl(p_business_group_id,-1)
1236: and element_name = p_meaning;
1237:
1238:
1239: cursor cd is SELECT input_value_id from pay_input_values_f
1240: WHERE nvl(business_group_id ,nvl(p_business_group_id,-1))
1241: = nvl(p_business_group_id,-1)
1242: and name = p_meaning
1243: and element_type_id = (SELECT element_type_id from pay_element_types_f