APPS.PSB_BUDGET_POSITION_PVT dependencies on PSB_POSITION_ASSIGNMENTS

Line 345: FROM psb_position_assignments asgn ,

341: pd('Attribute id ' || l_set_lines_rec.attribute_id );
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

Line 357: (SELECT 1 FROM psb_position_assignments

353: asgn.attribute_value = vals.attribute_value
354: )
355: /* Bug 4545909 Start */
356: AND ((worksheet_id IS NULL AND NOT EXISTS
357: (SELECT 1 FROM psb_position_assignments
358: WHERE worksheet_id = p_worksheet_id
359: AND attribute_id = asgn.attribute_id
360: AND position_id = asgn.position_id))
361: OR worksheet_id = p_worksheet_id

Line 619: FROM psb_position_assignments

615: FROM psb_positions
616: WHERE data_extract_id = l_data_extract_id
617: MINUS
618: SELECT position_id
619: FROM psb_position_assignments
620: WHERE data_extract_id = l_data_extract_id
621: AND attribute_id = l_set_line_rec.attribute_id
622: )
623: LOOP

Line 671: FROM psb_position_assignments

667: --
668: FOR l_position_rec IN
669: (
670: SELECT position_id
671: FROM psb_position_assignments
672: WHERE attribute_id = l_set_line_rec.attribute_id
673: AND data_extract_id = l_data_extract_id
674: AND ( attribute_value_id = l_attribute_value_id
675: OR