APPS.PSB_ACCOUNT_POSITION_SET_PVT dependencies on PSB_POSITION_SET_LINE_VALUES

Line 529: -- with Psb_position_set_line_values table. The Delete_Row API deletes

525: WHERE rowid = p_row_id ;
526:
527: --
528: -- When we delete a set line, we also need to delete all records associated
529: -- with Psb_position_set_line_values table. The Delete_Row API deletes
530: -- not only the line_id but related child records as well.
531: --
532: FOR l_lines_rec IN
533: (

Line 1221: l_value_sequence_id psb_position_set_line_values.value_sequence_id%TYPE ;

1217: l_account_position_set_id
1218: psb_account_position_sets.account_position_set_id%TYPE;
1219:
1220: l_line_sequence_id psb_account_position_set_lines.line_sequence_id%TYPE ;
1221: l_value_sequence_id psb_position_set_line_values.value_sequence_id%TYPE ;
1222: l_target_attribute_id psb_account_position_set_lines.attribute_id%TYPE ;
1223:
1224: l_target_attribute_value_id
1225: psb_position_set_line_values.attribute_value_id%TYPE ;

Line 1225: psb_position_set_line_values.attribute_value_id%TYPE ;

1221: l_value_sequence_id psb_position_set_line_values.value_sequence_id%TYPE ;
1222: l_target_attribute_id psb_account_position_set_lines.attribute_id%TYPE ;
1223:
1224: l_target_attribute_value_id
1225: psb_position_set_line_values.attribute_value_id%TYPE ;
1226: --
1227: CURSOR l_sets_csr IS
1228: SELECT *
1229: FROM psb_account_position_sets

Line 1485: FROM psb_position_set_line_values_v

1481:
1482: FOR l_values_rec IN
1483: (
1484: SELECT *
1485: FROM psb_position_set_line_values_v
1486: WHERE line_sequence_id = l_lines_rec.line_sequence_id
1487: )
1488: LOOP
1489: