DBA Data[Home] [Help]

APPS.PSB_BUDGET_POSITION_PVT dependencies on PSB_POSITION_SET_LINE_VALUES

Line 346: psb_position_set_line_values vals

342:
343: -- Check whether the position belongs to the current set.
344: SELECT COUNT(*) INTO l_matching_attributes_count
345: FROM psb_position_assignments asgn ,
346: psb_position_set_line_values vals
347: WHERE vals.line_sequence_id = l_set_lines_rec.line_sequence_id
348: AND asgn.position_id = p_position_id
349: AND asgn.attribute_id = l_set_lines_rec.attribute_id
350: AND (

Line 599: FROM psb_position_set_line_values

595: l_count_set_line_positions := 0 ;
596:
597: -- Check whether the attribute has been assigned values or not.
598: SELECT COUNT(*) INTO l_tmp_count
599: FROM psb_position_set_line_values
600: WHERE line_sequence_id = l_set_line_rec.line_sequence_id ;
601:
602: IF l_tmp_count = 0 THEN
603:

Line 651: FROM psb_position_set_line_values vals

647: FOR l_val_rec IN
648: (
649: SELECT attribute_value_id ,
650: attribute_value
651: FROM psb_position_set_line_values vals
652: WHERE line_sequence_id = l_set_line_rec.line_sequence_id
653: )
654: LOOP
655: